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: 2109)

What is MySQL? (Views: 2729)

How do I REPAIR all MySQL databases on my virtual / dedicated server? (Views: 2173)

How do I create a MySQL database in Cpanel ? (Views: 2206)

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