November 2, 2007 at 11:52 pm
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Number = -2147467259
Source = Microsoft OLE DB Provider for SQL Server
Description = [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
I have problen in vb application
November 3, 2007 at 5:31 am
..Check whether the SQL Server is running or not
..Check on which port the server is listening
..Try connecting through EM or QA
..Check the connection string used in VB application
--Ramesh
November 4, 2007 at 9:48 pm
Thnx for reply
i got the answer
in connection string
set Connect Timeout=0 now it works
and you told something SQL Server port but default it is 1433 pls tell me more that if you have.
Regards
Gouri
November 5, 2007 at 5:47 am
...Setting ConnectTimeout to zero, will make the provider wait indefinitely till the connection is established or the remote server rejects the request from the host after a pre-defined time has elapsed. So its always better to set a timeout period for not only connections but also for command executions.
--Ramesh
November 5, 2007 at 5:57 am
Thnx...
August 13, 2010 at 12:33 am
i am using sql server2005 & management studio.. in xp
i connect it thriugh the network..
it causes error like
"[DBNETLIB][ConnectionOpen(connection())]SQLserver not found"
what can i do??
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply