no such table or object

[smeyer56]

this morning when I came in and tried to run some reports I get this error on a table that was fine through yesterday. When I open the pervasive CC I get the error.

ODBC Error: SQLSTATE = S1000, Native error code = 0
Unable to open table: TixLine.
No such table or object.

Any ideas why or what to do to fix it?

 

[mirtheil]

That almost sounds like the data file for TixLine is missing. Does the data file exist?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[smeyer56]

Yes the dat file exist. There are two different DDF files, one for a complete set of information and one for a simplified set with "nice" descriptions. The complete one still works and the data is still as it show be but the other one doesn't

 

[smeyer56]

Never mind I got it. For some reason I needed to recreated the DSN on the server. Unfortunately when I tried to recreate it I got the same errors but when I created a new one with a new named database it works fine.