Connection String; MSSQL & MySQL databases

18 August 2006 3:35 AM
- Windows
- MySQL

MSSQL & MySQL Connection Strings: Server information
Applicable to Windows Hosting Only;

Please call your databases via following strings,

MySQL : "mysql.server" (without the quotes)
MSSQL: "mssql.server" (without the quotes)

Samples database connection strings:

mssql.server

Code:

"Data Source=mssql.server;Initial Catalog=pubs;User Id=username;Password=asdasd;"
"Server=mssql.server;Database=pubs;User ID=username;Password=asdasd;"

mysql.server

Code:

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=mysql.server;DATABASE=myDatabase; USER=myUsername;PASSWORD=myPassword;"
"$conn = mysql_connect('mysql.server', 'mysql_user', 'mysql_password');"

Connection String; MSSQL & MySQL databases

Related Articles

Comments

Categories

Tags