| 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) |
Standard Security: |
"Data Source=Aron1;Initial Catalog=pubs;User
Id=sa;Password=asdasd;" |
|
|
|
- or - |
|
|
|
"Server=Aron1;Database=pubs;User ID=sa;Password=asdasd;
Trusted_Connection=False" |
|
|
|
(booth connection strings
produces the same result) |
|
|
Trusted Connection: |
"Data Source=Aron1;Initial Catalog=pubs;Integrated
Security=SSPI;" |
|
|
|
- or - |
|
|
|
"Server=Aron1;Database=pubs;Trusted_Connection=True;" |
|
|
|
(booth connection strings
produces the same result) |
|
|
Connect via an IP address: |
"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)) |
|
|
Declare the SqlConnection: |
C#: |
|
|
|
using System.Data.SqlClient; |
|
|
|
SqlConnection oSQLConn = new SqlConnection(); |
|
|
|
oSQLConn.ConnectionString="my connectionstring"; |
|
|
|
oSQLConn.Open(); |
|
|
|
VB.NET: |
|
|
|
Imports System.Data.SqlClient |
|
|
|
Dim oSQLConn As SqlConnection = New SqlConnection() |
|
|
|
oSQLConn.ConnectionString="my connectionstring" |
|
|
|
oSQLConn.Open() |
|
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;","admin",
"" |
|
|
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;","admin", "" |
|
|
With password: |
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet
OLEDB:Database Password=MyDbPassword;","admin", "" |
| ORACLE |
ODBC |
New version: |
"Driver={Microsoft ODBC
for Oracle};Server=OracleServer.world;Uid=Username;Pwd=asdasd;" |
|
|
Old version: |
"Driver={Microsoft ODBC
Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;" |
|
OLE DB, OleDbConnection
(.NET) |
Standard security: |
"Provider=msdaora;Data
Source=MyOracleDB;User Id=UserName;Password=asdasd;" |
|
|
Standard Security: |
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User
Id=Username;Password=asdasd;" |
|
|
Trusted Connection: |
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;" |
|
OracleConnection (.NET)
|
Standard: |
"Data Source=Oracle8i;Integrated
Security=yes"; |
|
|
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" |
|
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 |
Local database: |
"Driver={mySQL};Server=mySrvName;Option=16834;Database=mydatabase;" |
|
|
Remote database: |
"Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;" |
|
OLE DB, OleDbConnection
(.NET) |
Standard: |
"Provider=MySQLProv;Data
Source=mydb;User Id=UserName;Password=asdasd;" |
|
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() |
| INTERBASE |
ODBC, Easysoft |
Local computer: |
"Driver={Easysoft IB6 ODBC};Server=localhost;Database=localhost:C:\mydatabase.gdb;Uid=username;Pwd=password |
|
|
Remote Computer: |
"Driver={Easysoft IB6 ODBC};Server=ComputerName;Database=ComputerName:C:\mydatabase.gdb;Uid=username;Pwd=password" |
|
ODBC, Intersolv |
Local computer: |
"Driver={INTERSOLV InterBase ODBC Driver
(*.gdb)};Server=localhost;Database=localhost:C:\mydatabase.gdb;Uid=username;Pwd=password" |
|
|
Remote Computer: |
"Driver={INTERSOLV InterBase ODBC Driver
(*.gdb)};Server=ComputerName;Database=ComputerName:C:\mydatabase.gdb;Uid=username;Pwd=password" |
|
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" |
| SYBASE |
ODBC |
Standard: |
"Driver={SYBASE SYSTEM
11};Srvr=Aron1;Uid=username;Pwd=password;" |
|
|
Intersolv 3.10: |
"Driver={INTERSOLV 3.10
32-BIT Sybase};Srvr=Aron1;Uid=username;Pwd=password;" |
| 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 |
IBM Informix OLE DB Provider: |
"Provider=Ifxoledbc.2;password=myPw;User
ID=myUser;Data Source=dbName@serverName;Persist Security Info=true" |
| MIMER SQL |
ODBC |
Standard Security: |
"Driver={MIMER};Database=mydb;Uid=myuser;Pwd=mypw;" |
|
|
Prompt for username and password: |
"Driver={MIMER};Database=mydb;" |
| DSN |
ODBC |
DSN: |
"DSN=myDsn;Uid=username;Pwd=;" |
|
|
File DSN: |
"FILEDSN=c:\myData.dsn;Uid=username;Pwd=;" |
| EXCEL |
ODBC |
STANDARD |
"Driver={Microsoft Excel
Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDir=c:\mypath;" |
|
OLEDB |
STANDARD |
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended
Properties=""Excel 8.0;HDR=Yes;IMEX=1""" |
| TEXT |
ODBC |
STANDARD |
"Driver={Microsoft Text Driver (*.txt;
*.csv)};Dbq=c:\txtFilesFolder\;Extensions=asc,csv,tab,txt;" |
|
OLEDB |
STANDARD |
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\txtFilesFolder\;Extended Properties=""text;HDR=Yes;FMT=Delimited""" |
| DBF / FOXPRO |
ODBC |
STANDARD |
"Driver={Microsoft dBASE
Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;" |
|
OLE DB, OleDbConnection
(.NET) |
STANDARD |
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended
Properties=dBASE IV;User ID=Admin;Password=" |
| Visual Fox Pro |
OLE DB, OleDbConnection
(.NET) |
STANDARD |
"Provider=vfpoledb.1;Data
Source=C:\testvfp.dbc" |
|
odbc |
Visual Foxpro database
(.DBC): |
"Driver={Microsoft Visual
FoxPro Driver};SourceType=DBC;SourceDB=c:\myvfpdb.dbc;Exclusive=No;Collate=Machine;" |
|
|
Free Table directory: |
"Driver={Microsoft Visual
FoxPro Driver};SourceType=DBF;SourceDB=c:\myvfpdbfolder;Exclusive=No;Collate=Machine;" |
| pervarsive |
odbc |
STANDARD |
"Driver={Pervasive ODBC Client Interface};ServerName=srvname;dbq=@dbname" |
|
oledb |
STANDARD |
"Provider=PervasiveOLEDB;Data Source=C:\path" |
| UDL |
UDL |
UDL |
"File Name=c:\myDataLink.udl;" |
