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.
  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

How to Backup your MySQL DB databases

Backup command for mysql databases For those looking to get a regular backup of your MySQL...

How do I create a MySQL database in Cpanel ?

MySQL databases can be created through the cpanel control panel: Login to your control panel...

How do I create a MySQL database in Plesk ?

MySQL databases can be created through the plesk control panel: Login to your control panel...

How do I repair a damaged MySQL table, rebuild index or prepare for backup ?

It is always worth trying a repair of MySQL tables before backing them up to shrink the...

How do I create a MySQL Database in the Ensim control panel ?

To add a database (subject to hosting plan resources available) through your Ensim control panel:...

Powered by WHMCompleteSolution