Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting up SQL Server 6.5 from VB6.0 Enterprise Package

Status
Not open for further replies.

Bachenot

Programmer
Mar 6, 2000
28
US
I have the Enterprise edition of VB 6 using Windows 98.<br><br>With this package is a copy of SQL Server 6.5.<br><br>I would like to do some tests using SQL Server 6.5 on the Windows 98 machine.<br><br>All the documentation I have seen so far for connecting SQL Server assumes Windows NT.<br><br>Is there a way to set up the SQL Server connection on a Windows 98 machine?<br><br>Here are some of the connection errors I get:<br><br>--Under Microsoft SQL Enterprise Manager<br>A connection could not be established to BACHENOT - [DB library]. Unable to connect: SQL Server is unavailable or does not exist.<br>--Under Microsoft SQL Security Manager<br>SQL Server Error<br> Error: Unable to connect: SQL Server is unavailable or does not exist.<br> OS Error: 2106.&nbsp;&nbsp;ConnectionOpen(CreateFile())<br>--Under SQL Server Login when trying to connect using ODBC with my user name and password<br>Connection failed.<br>SQLState: '01000'<br>SQL Server Error: 10061<br>[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(connect())<br>Connection failed.<br>SQLState '08001'<br>SQL Server Error: 11<br>[Microsoft][ODBC SQL Server Driver][TCO/IP Sockets]General network error. Check your network documentation.<br>--Under SQL Server Login when trying to connect using ODBC without my user name and password<br> Microsoft SQL Server ODBC Driver Version 03.70.0690<br>Running connectivity tests...<br>Attempting connection<br>[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.<br>TESTS FAILED!<br> <br><br> <br><br><br><br><br><br><br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top