Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
solart
Posting Yak Master
148 Posts |
 Posted - 2002-06-18 : 15:51:56
|
| On a SQL 7 Windows NT 4 Build 1381 Service Pack 6 system, infrequently I have been getting the following error message:"Error [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation." The error message is quite generic An IIS server on another platform interfaces with the server getting the error messages.I have viewed the windows logs, SQL Server Agent logs, the SQL Server logs themselves and find no events which would provide clues to what is happening.There are a good number of messages that the max connections have been reached, but not around the time the problems occur.The ODBC driver on the platform generating the errors is "SQL Server 3.70.09.61".The ODBC driver on the IIS platform (connecting server) is "SQL Server 3.70.06.90".I am thinking about renaming the ODBC driver on the IIS platform and copying the ODBC driver from the other platform to it. This would then have both platforms using the same ODBC driver (SQL Server 3.70.09.61).I don't know if the "old" ODBC driver is registered.I don't know if I need to register the "newer" ODBC driver on the IIS platform.Please share any views, opinions, etc. I will appreciate it.Thanks in advance!!!! solart |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-18 : 16:40:57
|
| I don't think you can "rename" an ODBC driver and have it perform the same as the one with the actual name. What you CAN do is install the latest MDAC components on the SQL Server, IIS box, and however many client computers connect to it. Go here:http://www.microsoft.com/data/download.htmI would recommend MDAC 2.6 RTM or SP1. You really don't need MDAC 2.7 since you're not running XP. Download and install the MDAC components and your ODBC drivers will be up to date. It is not only better but also easier than trying to rename/copy/register files. |
 |
|
|
solart
Posting Yak Master
148 Posts |
Posted - 2002-06-18 : 16:49:07
|
| My sincere thank you!!solart |
|
|
|
|
|
|
ODBC driver error infrequently