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

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

VB6 & Sql Server 2000 connection

Reply to Message Icon

Name: wclairmont
Date: March 30, 2005 at 13:36:27 Pacific
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!




Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







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


Sponsored links

Ads by Google


Results for: VB6 & Sql Server 2000 connection

VB6.0 and SQL server & windows comp www.computing.net/answers/programming/vb60-and-sql-server-amp-windows-comp/7585.html

connecting sql server from java www.computing.net/answers/programming/connecting-sql-server-from-java/11451.html

sql server insvisible! www.computing.net/answers/programming/sql-server-insvisible/10569.html