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.
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 2003I 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 anyInterventionI 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 this1)pinging the MURA0001 server,2)try pinging the ip address of the server, let me know the difference |
|
|
|
|
|