Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DBNETLIB][ConnectionOpen (Connect()).]

Author  Topic 

DeepakNewton
Starting Member

39 Posts

Posted - 2009-08-04 : 02:54:08
Hi All,
I am using VB to Connect SQLserver 2000 and the environment is windows 2003
I am getting an error only at times
DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. when I trying to Insert some Data......

This Happens Only at times ( say 30 to 60 mins ) . after that It is working fine without anyIntervention

I am Using the Connection String as

PROVIDER=SQLOLEDB;Server=MURA0001;DATABASE=MURASAFE;uid=;pwd=;
I am Unable to Track IT

Please help me in this regard.
Regards,
Deepak N


arunsqladmin
Yak Posting Veteran

74 Posts

Posted - 2009-08-06 : 05:14:00
there might be some problem with the network, when u get this error. try to test the connectivity(it might be a dns problem) by trying this
1)pinging the MURA0001 server,
2)try pinging the ip address of the server,
let me know the difference
Go to Top of Page
   

- Advertisement -