August 9, 2006 at 7:38 pm
VB 6.0, ADO 2.7 application, SQL Server 2000 sp3a
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
The above error was encountered every 30 seconds or so during a batch operation where many inserts / updates are taking place, each opening and closing a connection (I'm hoping this uses connection pooling).
I set the connect timeout property to 120 seconds in the connection string for each new connection and that seemed to overcome the problem, but the app is running slowly.
I turned on Performance monitor to look at the SQL Server connections - it ranges from 2 to 5 (rarely it will hit 6). It seems like when the max number of connections hits 5, the application tries/waits to connect to the server and after about 30 seconds or so it starts processing again with the subsequent connections happening instantly. The number of connections shows 2 or 3 again, then when it hits 5, shortly before or after this, the app will wait again to connect to the server.
I don't think I have MSDE installed, which has a governor that may be limiting the concurrent connections - in the Add/Remove programs it says "Microsoft SQL Server 2000" Version 8.00.761.
SQL Server is installed on Windows XP SP2 and the VB application is running on the same machine.
Any ideas out there? Thanks for the help!
August 10, 2006 at 5:27 am
run sp_server_info @attribute_id =2, that attribute tells which edition of sql server you are connected to
August 10, 2006 at 4:01 pm
Thank you. That command gave me what I thought, I have the SQL Server 2000 Developer Edition.
It is still unclear to me then, why, when there are about 5 connections showing in Performance Monitor, it takes 30 seconds or so for the application to wait to make its next connection? It this some sort of "denial of service" worm protection? If so, how can I disable it? Any more ideas appreciated.
Results of the command:
attribute_id,attribute_name,attribute_value
2,DBMS_VER,Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 1)
(1 row(s) affected)
August 11, 2006 at 12:57 am
If you connect to the windows xp from another computer you may run into the maximum allowed inbound connections of windows xp: http://support.microsoft.com/?scid=kb;en-us;314882
Windows home:5
Windows pro :10
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply