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 |
|
DBlanky
Starting Member
3 Posts |
 Posted - 2008-01-07 : 17:33:53
|
| Hi all,We have recently been having some problems with our server, and im stuck for ideas of what to try next!Basically we have a busy period every 2 hours where we have many records that need to be processed etc, but we are getting an error coming back saying 'Invalid connection string attribute'.Now this would be fine but we are using a UDL and 80% of the records are going in fine and its just this few that are coming back with this error. This happens at 3mins and 55 secs past the hour everytime too.Now i ran SQL profiler over this time and there are records and such being processed fine, then all of a sudden at 3min and 55 secs past there is a mass 'Audit Logout' noted in profiler.It would seem to me it has nothing to do with the connection string as it was working perfectly fine before.The processing is done using a VB6 dll being called through ASP on IIS 6. Does anyone have any ideas on what to try next or advice?Thanks allDanny |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-07 : 22:59:44
|
| Do you use connection pooling? Have enough connections in the pool? |
 |
|
|
|
|
|
Invalid connection string attribute