ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> ODBC General Issues >> ODBC Error: SQLSTATE = S1000
http://www.istechforum.com/YaBB.pl?num=1110129065

Message started by Kelloggs on 03/06/05 at 09:11:04

Title: ODBC Error: SQLSTATE = S1000
Post by Kelloggs on 03/06/05 at 09:11:04

Hi,

everytime we want to open a table using Pervasive Control Center, we get the following error:

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

We notice is not happening on our Play Companies, just
the main company.

Also we are unable to use any of our MS Access and Crystal Reports

Please Help.

Kelloggs

PS: We just noticed that the X$file, X$Field and X$Index are empty.

Title: Re: ODBC Error: SQLSTATE = S1000
Post by kevind on 03/06/05 at 12:23:13

Make sure that you run ODBCDDF from within your main company
so that it creates the ODBC compatable .DDF files in the same
folder as your datafiles.

Title: Re: ODBC Error: SQLSTATE = S1000
Post by Kelloggs on 03/08/05 at 12:26:28

Thanks for your posting,
We did run the ODBCDDF and it fixed the problem.

But for a second time this week Pervasive Control Center can open any of the tables, and the ODBC connection is not working

This time we run the ODBCDDF and it couldnt fix the problem. What we did is copy the X$file, X$Field and X$Index files from a backup copy and paste into our main company.

Why suddenly these files are getting corrupted?

We are afraid of using any of our Crystal or MS Access Reports.

Any suggestions?

Ciao,

Kelloggs