100% Australian Windows Web Hosting
  • Knowledge Base

Connection Strings 

Was this helpful? (4) (0)

SQL Server

The following connection string can be used to access SQL Server.
Please replace the SERVER, USERNAME, PASSWORD and DATABASE words with your settings.



ASP:

Driver={SQL Server}; Server=SERVER;Database=DATABASE;Uid=USERNAME;Pwd=PASSWORD;


ASP.NET:

Server=SERVER;Database=DATABASE;User ID=USERNAME;Password=PASSWORD;

Microsoft Access

ASP:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=x:\path\to\your\db.mdb