When connecting VB to SQL Server, I am using Microsoft SQL Server driver. I find that when I use MapInfo SQL Server driver to open an ODBC table, there will be two connections (processes) in SQL Server Current Activity, the process description for one is is exec sp_server_info, the description for another process is blank. And when I create a new connection using MS ODBC SQL Server driver, although there is an error message: "[Microsoft][ODBC SQL Server Driver] Connection is busy with the results for another hstmt" , the table can be opened anyway, and there is only one process in SQL Server. The description of this process is the SQL Select statement of the opened table. So What is going on there? Why there are two processes when an ODBC table is opened? Thanks in advance. Sherry Xiao [EMAIL PROTECTED] wrote: > Answer: > > When connecting VB to SQL Server, which ODBC SQL Server driver are you > using? Microsoft? Can you give me the exact text of the error message? > There aren't any settings that I know of in the Server_Connect() function > to specify user numbers. Maybe you should issue a Server Disconnect > Statement when you are done with the connection. > > Cindy > MapInfo Technical Support ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
