Knowledgebase

DSNLess connection to MS SQL

 

Below is an example connection string for access your MSSQL database via a DSNLess connection...

 

oConn.Open "Provider=SQLOLEDB.1;Password=PASSWORDHERE;Persist Security Info=True;User ID=USERID;Initial Catalog=DBNAME;Data Source=10.0.0.133"

 

Please remember to replace, the user id, password and db name where needed.

Add to Favourites    Print this Article

MySQL Alter Table - How to rename table names and column names in mysql ? (Views: 2334)

ASP JPEG Example code (Views: 1629)

How do I create a MySQL Database in the Ensim control panel ? (Views: 2241)

'80004005' Could not use ''; file already in use (Views: 2069)

How do I use a Microsoft Access database on Windows Plesk Hosting. (Views: 9262)