OLE DB Connection Strings - Powered By Kayako SupportSuite

10 Sep 2010

Support Center » Knowledgebase » Databases » OLE DB Connection Strings

	OLE DB Connection Strings

Solution OLE DB Connection Strings:

While ODBC drivers are currently available, we nonetheless recommend the use of OLE DB instead. Example connection strings for various database systems are available below:

MS Access:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=;"

SQL Server:
"Provider=sqloledb;Data Source= 67.19.166.82,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"

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

Text:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder\;Extended Properties=""text;HDR=Yes;FMT=Delimited"""

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

Visual FoxPro:

Database container (.DBC):
"Provider=vfpoledb.1;Data Source=C:\MyDbFolder\MyDbContainer.dbc;Collating Sequence=machine"

Free table directory:
"Provider=vfpoledb.1;Data Source=C:\MyDataDirectory\;Collating Sequence=general"

MySQL:

MyODBC 2.50 Remote database:
"Driver={mySQL};Server=67.19.166.82;Port=3306;Option=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;"

MyODBC 3.51 Remote database:
"DRIVER={MySQL ODBC 3.51 Driver};SERVER=67.19.166.82;PORT=3306;DATABASE=myDatabase; USER=myUsername;PASSWORD=myPassword;OPTION=3;"

Please remember, though, that these are just generic examples; you should make sure you use your own credentials and database information instead of the examples here.

Article Details

Article ID:

Created On:

30 Aug 2006 11:34 AM