[OTH1.02] 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?

 Print this Article

Also Read

[OTH1.01] Can I use Access Databases on my package with Hosting cPanel?

We only offer MySQL databases on our packages. Microsoft Access Databases are not fully ODBC...