Crystal Reports Error "unable to open table"
Crystal Reports Error "unable to open table"
(OP)
We recently upgraded to Businessworks version 8.0 and Pervasive 9.61 and when we did our reports that are stored in Crystal Reports will no longer work. I keep getting this message:
ODBC error:[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface] unable to open table:ARCustomer
I need help finding out why my table won't open and/or what I need to do to add a new table to make my report work. Any help would be greatly appreciated!!
Thank you!
ODBC error:[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface] unable to open table:ARCustomer
I need help finding out why my table won't open and/or what I need to do to add a new table to make my report work. Any help would be greatly appreciated!!
Thank you!
RE: Crystal Reports Error "unable to open table"
If so, then it's possible that the BusinessWorks install overwrote some of your data.
Can you access the ARCustomer table through the Pervasive Control Center?
Do any other tables fail?
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Crystal Reports Error "unable to open table"
Also, I'm not sure what the Pervasive Control Center is or how to access it. I have very very limited knowledge of pervasive but if you tell me where it's at then I can see if I can access the table via the control center :)
Thanks for your help!
Stacey
RE: Crystal Reports Error "unable to open table"
It is possible that MANAGER doesn't have rights to the tables you are trying to get to. The "admin" user for a PSQL database is "Master". I doubt you'll have that password though. I haven't worked much with BusinessWorks but I'd be surprised if they give you that access.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Crystal Reports Error "unable to open table"