unspecified error (occurs at random)

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

unspecified error (occurs at random)

Author

Topic

neilgoldsmith
Starting Member

3 Posts

Posted - 2007-12-17 : 01:24:45

We have a system that has been running for years and some of the .asp pages haven't been touched in years, but about 10 days ago the same SQL stmts that have always been there have been returning

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Unspecified error

This is on SQL Server 2000
MDAC 2.81.1128.0
Windows 2000 SP4
IIS

The problem is this occurs at random. The statement will execute 5x, then fail once, then run 2 more times and fail again. There isn't a problem with the SQL itself as the same Select stmt will fail or pass randomly. I can also take and execute the stmt manually and it will also pass. There are about 5 places it occurs in our pages. Here is on particular example. Note that DataRS("acc_num") is a valid value and will return just fine if I manually execute it and will pass probably 75% of the time as it is, but 25% of the time will fail with above error.

CMD = "SELECT TOP 1 id, acc_num, businessType, mdCountry, cust_lec, First_Name, Last_Name FROM accounts WHERE (Acc_Num = '" & DataRS("acc_num") & "')"

AccRS.Open CMD, DBConn, adOpenForwardOnly

Not sure at all what is causing this. I've haven't been able to find anything conclusive in the SQL Profiler either.

Any ideas?

thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-17 : 01:39:10

Most likely mdac issue, try reinstall it.

neilgoldsmith
Starting Member

3 Posts

Posted - 2007-12-17 : 09:56:33

Thanks for the response.

What is the latest version of MDAC I should be using? I went to MS to download it, but the one it pointed me to was 2.81.1117 and I already have .1128 on.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-17 : 10:08:14

Why are you using adOpenForwardOnly? Try ReadOnly if you only are going to display the data and not edit it.

E 12°55'05.25"
N 56°04'39.16"

neilgoldsmith
Starting Member

3 Posts

Posted - 2007-12-17 : 11:55:05

I tried a ReadOnly cursor and got the same results.

thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-17 : 13:26:38