Connection strings for DSN

ODBC drivers for DSN

.NET libraries for DSN

ODBC DSN

Type ODBC Driver
Usage DSN=myDSN or FILEDSN=c:\myDsnFile.dsn
Manufacturer Microsoft

System DSN

DSN=myDsn;Uid=myUsername;Pwd=;
 
 

File DSN

FILEDSN=c:\myDsnFile.dsn;Uid=myUsername;Pwd=;
 
 

.NET Framework Data Provider for ODBC

Type .NET Framework Wrapper Class Library
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft

Use an ODBC driver from .NET

Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;

See the respective ODBC driver's connection strings options. The .net OdbcConnection will just pass on the connection string to the specified ODBC driver. Read more here.

 
 

Popular