Welcome, Guest. Please Login.
05/03/24 at 16:09:56
News:
Home Help Search Login


Pages: 1
Send Topic Print
ODBC Error: SQLSTATE = S1000 (Read 1764 times)
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
ODBC Error: SQLSTATE = S1000
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.
 
Back to top
 
« Last Edit: 03/06/05 at 11:23:33 by Kelloggs »  

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 639
Gender: male
Re: ODBC Error: SQLSTATE = S1000
Reply #1 - 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.
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: ODBC Error: SQLSTATE = S1000
Reply #2 - 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
 
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Pages: 1
Send Topic Print