What connection string should I used for my database ?

Here are some sample connection strings to get you started:

MS Access

ODBC - "Driver={Microsoft Access Driver (*.mdb)}Dbq=\\NAS1\yourhomedirectory\data\yourdatabase.mdb Uid=Admin Pwd="

OLE DB - "Provider=Microsoft.Jet.OLEDB.4.0Data Source=\\NAS1\yourhomedirectory\data\yourdatabase.mdb User ID=admin Password="

SQL Server

OLE DB - "Data Source=sqlx.pacificonline.com Initial Catalog=SQLXABC123 User ID= SQLXABC123 Password=sqlpassword" 

http://www.connectionstrings.com/ is an excellent site that has links to just about every connection string possible.

Add Feedback