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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-26 : 07:59:01
|
| Kevin writes "I have an ASP page that loops through a recordset and writes information to a seperate table based on certain criteria from the first recordset.Sometimes, it will make it all the way through the recordset and insert all the appropriate records into the seperate table just fine. Other times it will kick back the following error about half-way through...Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. This error doesn't make sense to me, because for the first say 1,000 records it can find the SQL Server and can write the information perfectly. I would understand if this never works, I would check my connection string and make sure I didn't sausage finger anything, but since it is an intermitent problem, I know that it can't be my conn string.Does anyone have any ideas?" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-04-26 : 08:01:51
|
| Sausage finger! I love it.My guess would be that you're not closing and disposing of your connection object properly. So your server is rejecting new connections.I am worried that you need to look that much, what is your asp page doing ? Could it be done inside one proc ?DamianIta erat quando hic adveni. |
 |
|
|
Krb_iiaba
Starting Member
16 Posts |
|
|
|
|
|
Weird Error