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

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

What is MySQL? (Views: 2698)

DSNless connection to MS Access (Views: 2325)

How to Backup your MySQL DB databases (Views: 2444)

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