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 |
|
imanta
Starting Member
6 Posts |
 Posted - 2007-08-13 : 20:58:00
|
| I have a script that performs a number of reiterative tasks very quickly on a SQL database. After a few thousand requests (2-3 minutes) I get the following error:Error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.Code: 80004005Source: Microsoft OLE DB Provider for ODBC DriversThe connection string looks like:Driver={SQL Server};Server=45.22.11.33;Uid=test;Pwd=test;Database=TestI have changed nothing and it always does this. It doesn't matter if in my script I open and close the connection on every request or leave it open the whole time.Additionally, the script and the database are on the same machine.Thanks for any help. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-13 : 22:11:13
|
| Which protocol did you use? Any network issue? |
 |
|
|
imanta
Starting Member
6 Posts |
Posted - 2007-08-13 : 22:58:49
|
| It is using an IP so I assume TCP/IP. Also it fails typically around the same spot every time (~1300 to 1500 records) so I can't believe it is network related. Almost like its a connection issue with the database. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-13 : 23:21:01
|
| Not necessary tcp/ip if you didn't specify port number. I'll try with another protocol and check timeout setting, then set network monitoring in this case. |
|
|
|
imanta
Starting Member
6 Posts |
Posted - 2007-08-13 : 23:38:08
|
| I actually just switched to localhost for the IP server name and it seems to be working fine... not sure but I am guessing because I was specifying an IP, it was going out and back again and this is where the problems came up.Thanks! |
|
|
|
|
|
|
Question on VBScript connection issue and SQL 2005