Database connection strings

Choosing the exact database connection string type for a project depends on the environment and the features/performance needed. The connection strings below are just examples what should work in most scenarios with both ASP/VBScript and dot Net. For a full list of connection strings, visit

To connect to an MS Access/Jet database file, you can use this connection string:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\database.mdb;"

To connect to an MS SQL Server, you can use this connection string (line wrapped):

"Provider=SQLOLEDB;Data Source=servername;Initial Catalog=databasename;User ID=user;Password=password;Network Library=DBMSSOCN;"

To connect to a MySQL server from MS Windows you need something like this (line wrapped):

"DRIVER={MySQL ODBC 3.51 Driver}; Server=servername; Database=databasename; UID=user; PWD=password; Option=3"

(To connect to a MySQL server, you have to install the MySQL ODBC driver)



RSS 2.0 feed All content
RSS 2.0 feed ajax
RSS 2.0 feed asp
RSS 2.0 feed aspnet
RSS 2.0 feed bicycle
RSS 2.0 feed copenhagen
RSS 2.0 feed databases
RSS 2.0 feed denmark
RSS 2.0 feed diy
RSS 2.0 feed dotnet
RSS 2.0 feed html
RSS 2.0 feed japan
RSS 2.0 feed javascript
RSS 2.0 feed modding
RSS 2.0 feed photography
RSS 2.0 feed utilities
RSS 2.0 feed vbscript