Re: [PSQL v9.5]Cannot expand databases - No such table or object

Problems like this are usually related to "bad" DDF's, or possibly
DDF's with embedded pathnames. Try opening the System
Objects/Tables/X$File and let me know what you see for all of the paths
in the Xf$Loc column...
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach@xxxxxxxxxxxxxxxxxxxx
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 11/13/2007 ***

raschaoot@xxxxxxxxx wrote:

Dear all,

I am developing a little tool that needs to retrieve some specific
information out of our adminstrative software, which is used on
different locations (and thus with different data) in our company. The
administrative software makes use of the PSQL server, version 9.5; the
developer of our administrative software was very helpful in supplying
us with DDF files (obviously with the "please don't *** up anything"-
warning :o).

First I installed the PSQL v9.5 server (same version as on the
different machines) on my local machine. Put the DDF files together
with an old backup in a local directory, created the Database/DSN in
the PCC and finished the program. All well.

Next step: retrieve the data from the different servers. First to
test, I log into the server as administrator with PC-Anywhere, I put
the same DDF files with the same old backup in a local directory on
the server and created the database. No problems there, the database
appears beneath the engine.

However, when I try to expand the database afterwards in the PCC, I
get the following error:

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

I can create and delete database and engines on the server, but I
can't access them. I have the feeling this is something very basic -
probably has to do with rights and permissions- but I've been
searching for a couple of hours now and I can't seem to find the
origin. Every account has write access and besides, I'm logged in as
administrator - there shouldn't be any problem.

Anyone that can shed a light on this? The log (in which I'm only
trying to expand the database, it's not that big) but I didn't really
help out... perhaps it says something to someone of you, so I put it
online:

http://www.kunstrijshop.nl/jeroen/log.txt

Thanks a lot in advance for any help! Regards,


Jeroen van der Heide



--

.