This is a sample connection string which you can use with MS SQL 2005 / 2008 under ASP:

<%

dim conn
dim rs

strConn = "Driver={SQL Server};Server=YYYY;Database=XXXX;uid=XXXX;pwd=XXXX"
Set cnt = Server.CreateObject("ADODB.Connection")
cnt.ConnectionString= strConn
cnt.Open

%>

Database server = YYYY - You need to use the server address listed in "Database server" field when you were creating your database in Plesk.

For security reasons, we have changed specific settings with XXXX

NOTE: You MUST include the full database name, which consit of the user prefix and the name that you have given, for example XXX_DB
Was this answer helpful? 44 Users Found This Useful (168 Votes)

Most Popular Articles

How to create my MySQL database?

After you are done with the database creation you can use the phpMyAdmin tool to manipulate the...
MySQL Database info: username, password, hostname, database name

Your MySQL database username - is the same as your Control Panel username. our MySQL database...
MySQL administration with phpMyAdmin

MySQL administration with phpMyAdmin NOTE: If You Have Purchased Hosting From Us  Your...
MS Access

MS Access is typically used in conjunction with Windows servers running a MSSQL database. We do...
Maximum number of databases per hosting account

By default our hosting accounts come with a maximum of 50 databases per account. If for any...