ODBC Error Message

[dcusick]

I have 4 reports that I run quarterly. The reports are already created and grab their data from a SQL Server. I've never had problems with these reports before... However today I tried to run it and the following happens.. It asks me to login(normal) and I do so.. Then out of nowhere, I get an error message.. The message is as follows:

ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]0

That's it.. No description of the error, just 0. Anyone know anything or have any ideas as to what I can do? Thanks in advance..

Doug

 

[dcusick]

Oh yeah, and after I hit OK, it says Error Detected by Database DLL.

Doug

 

[vidru]

First, step through your ODBC source to make sure the connection to the database is working. Then, try going to the Database menu and doing a 'Verify Database' on the reports. It's possible that the data structure has changed since the last time the reports were run. If your reports are based on stored procedures (as opposed to tables or views), there could be an error with the procedure(s).

-dave

 

[dcusick]

ah, I got it... It was actually a database issue. The data was corrupted... Guess I shoulda checked that first! Thanks for your help...

Doug