What are valid connection strings on the Windows platform?

MySQL:
Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;

MSAccess:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\IIS0001\home\mydomain.com\db.mdb;User Id=admin;Password=;

Driver={Microsoft Access Driver (*.mdb)};Dbq=\\IIS0001\home\mydomain.com\db.mdb;Uid=Admin;Pwd=;

MSSQL(.NET Framework Data Provider for SQL Server):
Provider=SQLNCLI10;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

  • 84 Users Found This Useful
Was this answer helpful?

Related Articles

Backup and Restore MS-SQL Database.

MS SQL databases are backed up and restored using the MS SQL Web Data Administrator tool, This...

Can I use Microsoft SQL Server Management Studio to manage my MSSQL database?

We run Microsoft SQL Server 2008 on our servers, only Microsoft SQL Server Management Studio 2008...

Powered by WHMCompleteSolution