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 |
|
lbstech
Starting Member
3 Posts |
 Posted - 2008-10-03 : 16:33:49
|
| i was wondering if anyone could lend some advice. I'm experiencing a major issue at a customer site that has got me completely stumped. The kicker is that since data is confidential I cannot get a database backup in my own test environment to test whether the problem is environment or data related.The basic problem is that while running a query on a particular table in their database the query will loop through the result set (VB6 with ado using MDAC 2.8) until a certain point at which the program controlling the loop crashes and MDAC spits out Server Does not exist or Access is Denied. Both of those reasons have been confirmed as not being the cause.Also I have compiled the program that is handling the recordset in three different ways to limit the number of results (1 - 1000, 1001 - 1999, 2000-3000) and the program completes successfully in this manner. I am stumped as to what could cause the error, and everything I have tried has resulted in little help and a lot of frustration. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
lbstech
Starting Member
3 Posts |
Posted - 2008-10-03 : 16:45:59
|
| What would cause the connection to intermittently drop (mid query)? Or rather, what types of questions / things should I be asking the network admin to check. What types of tests can be run? Other queries don't experience the same problem, what can I check to find out what is different about this one? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
lbstech
Starting Member
3 Posts |
Posted - 2008-10-05 : 08:27:25
|
| Ok, I was able to run another test. I actually created a utility the ran the same query on the database and ran it from the desktop of the server. I still receive the same error. My frustrations continue. |
|
|
|
|
|
|
Query crashing, error reported: Server DNE