One of our customers is using an application which uses MS SQL Server ODBC (TCP/IP) to connect to a central SQL server 7 (or really MSDE). When they fire up the application, they often (not always) reicive an error-message: "[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied". They then have to reboot their PC's and try again, and this seems to work. Some PC's get it more often than others. The network generally seems ok since all other traffic floats nicely. They only have installed TCP/IP protocol. These situations started happening for no apparant reason (a while after initial installation), and the rate of occurence is increasing day by day. Any ideas?
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!
ODBC error connecting to SQL server 7.0
- Thread starter Bearmatic
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
