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;

  • 229 Users Found This Useful
Was this answer helpful?

Related Articles

How do I backup my MySQL database?

Backing up your MySQL database can be done in several ways1. Using the backup tool from the Web...

How can I manage my MySQL database?

Once you have created a database using your Fast Name Control Panel you will be able to manage it...

How can I upload my MySQL database?

There are numerous ways to upload a MySQL database, we would strongly recommend trying methods 2...

How do I connect to MySQL via SSH (telnet)?

You can connect to the server using SSH Telnet, once logged into the system you can access MySQL...

How do I connect to my MySQL database?

A simple php script to open a connection to a database$dbhost = 'localhost';$dbuser = 'db...

Powered by WHMCompleteSolution