Computing.Net > Forums > Programming > VB6 & Sql Server 2000 connection

Computing.Net: Over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to sign up now, it's free!

VB6 & Sql Server 2000 connection

Reply to Message Icon

Original Message
Name: wclairmont
Date: March 30, 2005 at 13:36:27 Pacific
Subject: VB6 & Sql Server 2000 connection
OS: Win 2k
CPU/Ram: Intel P3 512MB
Comment:

I am attempting to access a local sql server 2000 db, but to no avail. Here is the connection string I am trying, but receive the typical [Microsoft][ODBC SQL SERVER DRIVER][DBNETLIB] SQL Server does not exist or access denied error.

Here is the connection string I am trying, maybe someone out there can lend a hand.
Set MyConn = New ADODB.Connection
Set rst = New ADODB.Recordset
MyConn.CursorLocation = adUseClient

MyConn.ConnectionString =
"Driver={SQL Server}; Server=TMCW051/techserv; DB=TechServ;UID=techserv;PW=techserv"

MyConn.open

UID=techserv is setup as an admin on the SQL Server.
Thanks a bunch!



Report Offensive Message For Removal








Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home








Do you have your own blog?

Yes
No
I did before
I will soon


View Results

Poll Finishes In 4 Days.
Discuss in The Lounge
Poll History




Data Recovery Software