- SQL Server
-
- ODBC
- Standard Security:
"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"
- Trusted connection:
"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;"
- Prompt for username and password:
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;"
- OLE DB, OleDbConnection (.NET)
- Standard Security:
"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"
- Trusted Connection:
"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
(use serverName/instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
- Prompt for username and password:
oConn.Provider = "sqloledb"
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Data Source=Aron1;Initial Catalog=pubs;"
- Connect via an IP address:
"Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
- SqlConnection (.NET)
- Data Shape
- MS Data Shape
"Provider=MSDataShape;Data Provider=SQLOLEDB;Data Source=Aron1;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
- Access
-
- ODBC
- 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="
- OLE DB, OleDbConnection (.NET)
- Standard security:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/somepath/mydb.mdb;User Id=admin;Password=;"
- Workgroup (system database):
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/somepath/mydb.mdb;Jet OLEDB:System Database=system.mdw;"
- With password:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/somepath/mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;"
- Oracle
-
- ODBC
- OLE DB, OleDbConnection (.NET)
- OracleConnection (.NET)
- Standard:
"Data Source=Oracle8i;Integrated Security=yes;"
This one works only with Oracle 8i release 3 or later
- Specifying username and password:
"Data Source=Oracle8i;User Id=username;Password=passwd;Integrated Security=no;"
This one works only with Oracle 8i release 3 or later
- Declare the OracleConnection:
C#: using System.Data.OracleClient; OracleConnection oOracleConn = new OracleConnection(); oOracleConn.ConnectionString = "my connectionstring"; oOracleConn.Open();
VB.NET: Imports System.Data.OracleClient Dim oOracleConn As OracleConnection = New OracleConnection() oOracleConn.ConnectionString = "my connectionstring" oOracleConn.Open()
- Core Labs OraDirect (.NET)
- Standard:
"User ID=scott; Password=tiger; Host=ora; Pooling=true; Min Pool Size=0;Max Pool Size=100; Connection Lifetime=0" - Data Shape
- MS Data Shape:
"Provider=MSDataShape.1;Persist Security Info=False;Data Provider=MSDAORA;Data Source=orac;user id=username;password=mypw"
- MySQL
-
- ODBC
- OLE DB, OleDbConnection (.NET)
- MySqlConnection (.NET)
- eInfoDesigns.dbProvider:
"Data Source=server;Database=mydb;User ID=username;Password=pwd;Command Logging=false"
- Declare the MySqlConnection:
C#: using eInfoDesigns.dbProvider.MySqlClient; MySqlConnection oMySqlConn = new MySqlConnection(); oMySqlConn.ConnectionString = "my connectionstring"; oMySqlConn.Open();
VB.NET: Imports eInfoDesigns.dbProvider.MySqlClient Dim oMySqlConn As MySqlConnection = New MySqlConnection() oMySqlConn.ConnectionString = "my connectionstring" oMySqlConn.Open()
- SevenObjects MySqlClient (.NET)
- Standard:
"Host=server; UserName=myusername; Password=mypassword;Database=mydb;"
- Core Labs MySQLDirect (.NET)
- Standard:
"User ID=root; Password=pwd; Host=localhost; Port=3306; Database=test;Direct=true; Protocol=TCP; Compress=false; Pooling=true; Min Pool Size=0;Max Pool Size=100; Connection Lifetime=0"
- Interbase
-
- ODBC, Easysoft
- ODBC, Intersolv
- OLE DB, SIBPROvider
- Standard:
"provider=sibprovider;location=localhost:;data source=c:/databases/gdbs/mygdb.gdb;user id=SYSDBA;password=masterkey"
- Specifying character set:
"provider=sibprovider;location=localhost:;data source=c:/databases/gdbs/mygdb.gdb;user id=SYSDBA;password=masterkey;character set=ISO8859_1"
- Specifying role:
"provider=sibprovider;location=localhost:;data source=c:/databases/gdbs/mygdb.gdb;user id=SYSDBA;password=masterkey;role=DIGITADORES"
- IBM DB2
-
- OLE DB, OleDbConnection (.NET) from ms
- TCP/IP:
"Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=XXX.XXX.XXX.XXX;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW"
- APPC:
"Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU Alias=MyRemote;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW"
- ODBC
- Sybase
-
- ODBC
- OLE DB
- Adaptive Server Anywhere (ASA):
"Provider=ASAProv;Data source=myASA"
- Adaptive Server Enterprise (ASE) with Data Source .IDS file:
"Provider=Sybase ASE OLE DB Provider; Data source=myASE"
Note that you must create a Data Source .IDS file using the Sybase Data Administrator. These .IDS files resemble ODBC DSNs.
- Adaptive Server Enterprise (ASE):
"Provider=Sybase.ASEOLEDBProvider;Srvr=myASEserver,5000;Catalog=myDBname;User Id=username;Password=password"
- some reports on problem using the above one, try the following as an alternative -
"Provider=Sybase.ASEOLEDBProvider;Server Name=myASEserver,5000;Initial Catalog=myDBname;User Id=username;Password=password"
This one works only from Open Client 12.5 where the server port number feature works,燼llowing fully qualified connection strings to be used without defining燼ny .IDS Data Source files.
- AseConnection (.NET)
- Informix
-
- ODBC
- Informix 3.30:
"Dsn='';Driver={INFORMIX 3.30 32 BIT};Host=hostname;Server=myserver;Service=service-name;Protocol=olsoctcp;Database=mydb;UID=username;PWD=myPwd
- Informix-CLI 2.5:
"Driver={Informix-CLI 2.5 (32 Bit)};Server=myserver;Database=mydb;Uid=username;Pwd=myPwd"
- OLE DB
- Mimer SQL
- PostgreSQL
-
- Core Labs PostgreSQLDirect (.NET)
- Standard:
"User ID=root; Password=pwd; Host=localhost; Port=5432; Database=testdb;Pooling=true; Min Pool Size=0; Max Pool Size=100; Connection Lifetime=0"
- DSN
- Excel
-
- ODBC
- OLE DB
- Standard:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
"HDR=Yes;" indicates that the first row contains columnnames, not data
"IMEX=1;" tells the driver to always read "intermixed" data columns as text
TIP! SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.
- Text
-
- ODBC
- OLE DB
- Standard:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:/txtFilesFolder/;Extended Properties=""text;HDR=Yes;FMT=Delimited"""
"HDR=Yes;" indicates that the first row contains columnnames, not data
- DBF / FoxPro
-
- ODBC
- OLE DB, OleDbConnection (.NET)
- Visual FoxPro
-
- OLE DB, OleDbConnection (.NET)
- Database container (.DBC):
"Provider=vfpoledb.1;Data Source=C:/MyDbFolder/MyDbContainer.dbc;Password=MyPassWord;Collating Sequence=machine"
- Free table directory:
"Provider=vfpoledb.1;Data Source=C:/MyDataDirectory/;Password=MyPassWord;Collating Sequence=general"
- ODBC
Microsoft Visual Foxpro site:
- Pervasive
-
- ODBC
- Standard:
"Driver={Pervasive ODBC Client Interface};ServerName=srvname;dbq=@dbname"
- OLE DB
- Standard:
"Provider=PervasiveOLEDB;Data Source=C:/path"
|