Reg Database connection

01-13-2004, 11:51 AM
Set adoConnection = New adodb.Connection

With adoConnection
.ConnectionString = "UID=tt;PWD=ttt;" _
& "DRIVER={SQL Server};DATABASE=pubs;" _

End With

In the above statement , is there anything wrong ?
I am not able to establish the connection.

Do we need to configure anything in my system for the Driver = { SQL Server } before running this statement..

What are all the things I should make sure before running the above statement ?

FYI, I am able to connect to SQL Query Analyser for this Database in this server giving the above user id and password.

Pls reply..


01-13-2004, 11:54 AM
Take a look at this ... should help you

01-13-2004, 12:03 PM
This may occures because of spaces before and after server name.

01-13-2004, 12:06 PM
before trying to configure your SQL Server settings...make sure you have the connectionstring correct, the above connection string is not correct: review this web page for a list of proper connection strings..

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum