Connection String VB

[ssccaann43]

Bueno por solicitud de SKL, acá les dejo una info importante para conectar a cualquier base de datos desde VB.

SQL Server 2008

SQL Server Native Client 10.0 OLE DB Provider

 

Standard Security

Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword;

Connecting to an SQL Server instance

Provider=SQLNCLI10;Server=myServerName heInstanceName;Database=myDataBase; Trusted_Connection=yes;

Trusted Connection

Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase; Trusted_Connection=yes;

SQL Server Native Client 10.0 ODBC Driver

Standard security

Driver={SQL Server Native Client 10.0};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Trusted Connection

Driver={SQL Server Native Client 10.0};Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;

Connecting to an SQL Server instance

Driver={SQL Server Native Client 10.0};Server=myServerName heInstanceName; Database=myDataBase;Trusted_Connection=yes;

SQL Server 2005

SQL Server Native Client 9.0 OLE DB Provider

 

Standard Security

Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword;

Connecting to an SQL Server instance

Provider=SQLNCLI;Server=myServerName heInstanceName;Database=myDataBase; Trusted_Connection=yes;

Trusted Connection

Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase; Trusted_Connection=yes;

SQL Native Client 9.0 ODBC Driver

Standard security

Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

 

Trusted Connection

Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase; Trusted_Connection=yes;

 
SQL Server 2000

Microsoft OLE DB Provider for SQL Server

Standard Security

Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

Trusted connection

  Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

Connecting to an SQL Server instance 

Provider=sqloledb;Data Source=myServerName heInstanceName;Initial Catalog=myDataBase;Integrated Security=SSPI;

Connect via an IP address

Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

Microsoft SQL Server ODBC Driver

  Standard Security

Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Trusted connection

Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Trusted_Connection=Yes;

   
   

ORACLE

Microsoft OLE DB Provider for Oracle

Standard security

Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;

 

Trusted connection

Provider=msdaora;Data Source=MyOracleDB;Persist Security Info=False;Integrated Security=Yes;

   

Oracle Provider for OLE DB

Standard Security

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;[/q]

[/l]   

Trusted Connection

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;

 

Oracle XE, VB6 ADO

Provider=OraOLEDB.Oracle;dbq=localhost:1521/XE;Database=myDataBase;User Id=myUsername;Password=myPassword;

   
   

MySQL

MySQLDriverCS

 

Standard

Location=myServerAddress;Data Source=myDataBase;User ID=myUsername;Password=myPassword;Port=3306;Extended Properties="""";

   

MySQL OLEDB

 

Standard

Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;

   

MyODBC 2.50

 

Local database

Driver={mySQL};Server=localhost;Option=16834;Database=myDataBase;

Remote database

Driver={mySQL};Server=myServerAddress;Option=131072;Stmt=;Database=myDataBase; User=myUsername;Password=myPassword;

 

Specifying TCP/IP port

Driver={mySQL};Server=myServerAddress;Port=3306;Option=131072;Stmt=; Database=myDataBase; User=myUsername;Password=myPassword;

   

MySQL Connector/ODBC 3.51

Local database

Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;

 

Remote database

Driver={MySQL ODBC 3.51 Driver};Server=myServerAddress;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;

Specifying TCP/IP port

Driver={MySQL ODBC 3.51 Driver};Server=myServerAddress;Port=3306;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;

    MySQL Connector/ODBC 5.1

Local database

Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;

Remote database

Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;

Specifying TCP/IP

Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Port=3306;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;

 

Specifying socket

Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Database=myDataBase;User=myUsername; Password=myPassword;Socket=MySQL;Option=3;

   
   

INFORMIX

IBM Informix OLE DB Provider

Standard

  Provider=Ifxoledbc;Data Source=dbName@serverName;User ID=myUsername;Password=myPassword;

Persisting security info in the connection string

Provider=Ifxoledbc;Data Source=dbName@serverName;User ID=myUsername;Password=myPassword;Persist Security Info=true;

   

IBM Informix ODBC Driver

Informix 3.30

Dsn='';Driver={INFORMIX 3.30 32 BIT};Host=hostname;Server=myServerAddress;Service=service-name;Protocol=olsoctcp;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

PostgreSQL

PostgreSQL OLE DB Provider

Standard

(PgOleDb requires a PQLib of version 7.4 or up and it also requires a backend of version 7.4 or up. Timestamps are only guarenteed to work with backends of version 8.0 and up.)

Provider=PostgreSQL OLE DB Provider;Data Source=myServerAddress;location=myDataBase;User ID=myUsername;password=myPassword;timeout=1000;

   

PostgreSQL ODBC Driver (psqlODBC)

    Standard

Driver={PostgreSQL};Server=IP address;Port=5432;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

    ANSI

Driver={PostgreSQL ANSI};Server=IP address;Port=5432;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

   
  FIREBIRD     IBPhoenix Open Source ODBC Driver    Standard

Driver=Firebird/InterBase(r) driver;Uid=SYSDBA;Pwd=masterkey; DbName=d:\firebird\examples\test.fdb;

 
      Access     Microsoft Jet OLE DB 4.0      Standard security

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;

      With database password

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:Database Password=MyDbPassword;

    Workgroup (system database)

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:System Database=system.mdw;

    DataDirectory functionality

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\myDatabase.mdb;User Id=admin;Password=;

     Microsoft Access ODBC Driver      Standard Security

Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;

    Workgroup

Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;

    Exclusive

Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=admin;Pwd=;

    Enable admin statements

Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;ExtendedAnsiSQL=1;

   
   
Si requieren conectar a otra BD pues solo diganme...
 
Saludos...
 
Miguel Núñez

[LeandroA]

Muy bueno ssccaann43 muchas gracias por el aporte.

[seba123neo]

muy bueno,tambien recomiendo esta pagina, tiene cualquier cadena de conección en cualquier motor de bases de datos, es buenisima realmente:

ConnectionStrings

si ponen una seccion de bases de datos o algo, me apunto ya que estoy bastante metido en el tema.

saludos.

[Abusito]

si algo muy bueno la informacion es de todos y por ende se comparte agradesco todo lo que aprendido de esta pagina auque creo q mi cabeza cualkier dia ia va hacer click saludos a todos

[manhawk]

Como se puede conectarse a una base de datos Anywhere
Salu2