dbTalk Databases Forums  

Pervasive Workgroup engine: "No such table or object" error

comp.databases.btrieve comp.databases.btrieve


Discuss Pervasive Workgroup engine: "No such table or object" error in the comp.databases.btrieve forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
eljainc@sbcglobal.net
 
Posts: n/a

Default Pervasive Workgroup engine: "No such table or object" error - 01-17-2007 , 05:53 PM






Hello,

I'm having a problem with PSQL version 9.50 (workgroup engine).
I am trying to access a database that contains several tables. I have
created a DSN
and created a database. This database is stored on a network drive on a
Windows 2000
server. However, after creating the database definition in the
Pervasive Control Center,
when I try to get properties or access the database, I get the
following error:

[LNA][Pervasive][ODBC Engine Interface][Data Record Manager] No such
table or object.


However, if I copy all of the database files (dbp, ddf) to a local
drive and do the same
thing, it works.

How can I overcome this problem?

Mike McWhinney


Reply With Quote
  #2  
Old   
Bill Bach
 
Posts: n/a

Default Re: Pervasive Workgroup engine: "No such table or object" error - 01-19-2007 , 07:16 AM






Check your file locations in the DDF's and make sure there are no
hardcoded paths in it. Do this with the query "SELECT * FROM X$File"
and look at the Xf$Loc column.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 03/2007 ***

eljainc (AT) sbcglobal (DOT) net wrote:

Quote:
Hello,

I'm having a problem with PSQL version 9.50 (workgroup engine).
I am trying to access a database that contains several tables. I have
created a DSN
and created a database. This database is stored on a network drive on
a Windows 2000
server. However, after creating the database definition in the
Pervasive Control Center,
when I try to get properties or access the database, I get the
following error:

[LNA][Pervasive][ODBC Engine Interface][Data Record Manager] No such
table or object.


However, if I copy all of the database files (dbp, ddf) to a local
drive and do the same
thing, it works.

How can I overcome this problem?

Mike McWhinney


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.