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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I connect from SQL server 6.5 client to a SQL server 7.0 server?

Status
Not open for further replies.

zf

Programmer
Joined
Jul 13, 2000
Messages
2
Location
CA
I have a client is installed SQL server 6.5 and IIS4.0. I want connect to a SQL server 7 through internet. I have a asp page in client machine. It work well in another client Machine that installed SQL server 7. Have anybody can tell me why?<br>There are some SQL server 6.5 database in my client machine. I don't want get any trouble in those database.<br>Thanks!&nbsp;&nbsp;&nbsp;&nbsp;
 
When I use ADO in a asp page connect to a SQL server 7 that locate in other machine I get the error message:<br><br>Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br><br>[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation. <br><br>What reason? <br>How can I fix it? <br><br>
 
I have had simular problems, DOUBLE AND TRIPLE check your ODBC CONECTIONS and even make sure your MDAC is correct. I hope that helps...>Dug
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top