DNN Connection Strings for Other Providers

 

Alternate Solutions to Consider

Database Type

Connection String Examples

IBM DB2

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

Informix

Provider=Ifxoledbc.2;password=myPw;User ID=myUser;Data [email protected];Persist Security Info=true

Firebird

User=SYSDBA;Password=masterkey;Database=SampleDatabase.fdb;DataSource=localhost;Port=3050;Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=true;MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0

DBF/FoxPRo

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password=

Visual FoxPro

Provider=vfpoledb.1;Data Source=C:\MyDbFolder\MyDbContainer.dbc;Collating Sequence=machine

Pervasive

Provider=PervasiveOLEDB;Data Source=C:\path