short prom dresses prom gowns cheap party dresses uk ball dresses ball gowns long evening dresses evening gowns uk cocktail dresses uk cocktail wear shop dresses online uk long dresses uk plus size formal dresses
contact us  
 Lists for Developers
 
 
 ASCII
 C#
 Connection Str
 Delphi
 EBCDIC
 HTML
 Java
 Javascript
 Links
 PHP
 SQL
 VB.Net
 WINDOWS

Connection Strings

Table of Connection Strings

DB Connection String
Access

Access ODBC Connection String Driver

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

Access OLEDB Connection String Driver

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\directory\demo.mdb;User Id=admin;Password=;
DB2

DB2 ODBC Connection String

driver={IBM DB2 ODBC DRIVER};Database=demodb;hostname=myservername;port=myPortNum;protocol=TCPIP; uid=myusername; pwd=mypasswd

DB2 OLEDB Connection String

Provider=IBMDADB2;Database=demodeb;HOSTNAME=myservername;PROTOCOL=TCPIP;PORT=50000;uid=myusername;pwd=mypasswd;
DBase

DBase ODBC Connection String

Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\directory;

DBase OLEDB Connection String

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

Excel ODBC Connection String

Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDir=c:\directory;

Excel OLEDB Connection String

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties='"Excel 8.0;HDR=Yes;IMEX=1"'
Exchange

Exchange OLEDB Connection String

oConn.Provider = "EXOLEDB.DataSource" oConn.Open = "http://myServerName/myVirtualRootName"
Firebird

Firebird ODBC Connection String

DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=mypasswd;DBNAME=c:\directory\demo.fdb

Firebird OLEDB Connection String

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

FoxPro ODBC Connection String

Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\demo.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO

FoxPro OLEDB Connection String

Provider=vfpoledb.1;Data Source=c:\directory\demo.dbc;Collating Sequence=machine
Informix

Informix ODBC Connection String

Driver={Informix-CLI 2.5 (32 Bit)};Server=demoservername;Database=demodb;Uid=myusername;Pwd=mypasswd

Informix OLEDB Connection String

Provider=Ifxoledbc.2;User ID=myusername;password=mypasswd;Data Source=demodb@demoservername;Persist Security Info=true
MySQL

MySQL ODBC Connection String

DRIVER={MySQL ODBC 3.51 Driver};SERVER=myservername;PORT=3306;DATABASE=mydemodb; USER=myusername;PASSWORD=mypasswd;OPTION=3;

MySQL OLEDB Connection String

Provider=MySQLProv;Data Source=mydemodb;User Id=myusername;Password=mypasswd;
Oracle

Oracle ODBC Connection String

Driver={Microsoft ODBC for Oracle};Server=myservername;Uid=myusername;Pwd=mypassword;

Oracle OLEDB Connection String

Provider=msdaora;Data Source=mydemodb;User Id=myusername;Password=mypasswd;

Oracle .Net Connection String

Data Source=mydemodb;User Id=myusername;Password=mypasswd;Integrated Security=no;
SQL Server

SQL Server ODBC Connection String - Database Login

Driver={SQL Server};Server=myservername;Database=mydemodb;Uid=myusername;Pwd=mypasswd;

SQL Server ODBC Connection String - Trusted Connection

Driver={SQL Server};Server=mysername;Database=mydemodb;Trusted_Connection=yes;

SQL Server OLEDB Connection String - Database Login

Provider=sqloledb;Data Source=myservername;Initial Catalog=mydemodb;User Id=myusername;Password=mypasswd;

SQL Server OLEDB Connection String - Trusted Connection

Provider=sqloledb;Data Source=myservername;Initial Catalog=mydemodb;Integrated Security=SSPI;

SQL Server .Net Connection String - Database Login

Server=myservername;Database=mydemodb;User ID=myusername;Password=mypasswd;Trusted_Connection=False

SQL Server .Net Connection String - Trusted Connection

Server=myservername;Database=mydemodb;Integrated Security=SSPI;
Sybase

Sybase ODBC Connection String

Driver={SYBASE ASE ODBC Driver};Srvr=myservername;Uid=myusername;Pwd=mypasswd

Sybase OLEDB Connection String

Provider=Sybase.ASEOLEDBProvider;Server Name=myservername,5000;Initial Catalog=mydemodb;User Id=myusername;Password=mypassword

See Also: www.connectionstrings.com www.carlprothman.net

 
www.DevList.com