BUG: Mac ODBC App Via TCP/IP May Cause Connections to HangID: Q128726
|
A Macintosh ODBC application connected to SQL Server using TCP/IP sockets
may cause other SQL Server connections to hang when you run certain
queries, such as sp_who.
For instance, when Microsoft Query is used to send ad hoc queries, such as
sp_who to SQL Server, the Macintosh client may hang after repeating this
query a few times. When this occurs, other TCP/IP sockets clients can still
connect to the SQL Server, but any attempts to run any SQL commands will
cause that client to hang. After this, all existing connections will hang,
whether they are TCP/IP sockets clients or not. New connections can still
be made, but they will hang if you try to execute any SQL commands.
An alternative way of connecting to SQL Server from a Macintosh client is to use AppleTalk protocol ADSP. The ADSP Network Library (Net-Library) is also provided together with the TCP/IP sockets Net-Library for the Macintosh.
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 4.21a. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
Additional query words: tcp/ip mac hang odbc appletalk
Keywords : kb3rdparty kbbug4.21a SSrvWinNT
Version : 4.21a
Platform : WINDOWS
Issue type :
Last Reviewed: April 21, 1999