| 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
|
Original Message
|
Name: wclairmont
Date: March 30, 2005 at 13:36:27 Pacific
Subject: VB6 & Sql Server 2000 connectionOS: Win 2kCPU/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