You are here:

Knowledgebase

Did you know that we are one of the cheapest domain registrars in the UK Find out more...

Portal Home > Knowledgebase > Databases > What are valid connection strings on the Windows platform?


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;

Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read

Language:

Testimonials

Fantastic support from polite staff - 10 stars!