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

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

Microsoft JET Database Engine error '80040e14', Syntax error in... (Views: 2946)

How do I set the database permissions for a Microsoft Access file (*.mdb) on Windows Plesk. (Views: 2885)

What components are installed on the server? (Views: 1671)

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