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 fuck up anything"-
warning ).

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

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 (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 11/13/2007 ***

raschaoot (AT) gmail (DOT) com wrote:



--

On 16 okt, 20:03, "Bill Bach" <golds... (AT) speakeasy (DOT) net> wrote:
On my server, I cannot expand the database at all so I cannot access
the System Objects either. On my local server, no pathnames are
embedded in the DDFs. I think the problem doesn't have to do with the
DDF - besides, they work fine on my local server in whatever directory
I put the data + DDFs.

If I create the DEMODATA database (which isn't present in the database
list, probably because PSQL came with my administrative software?)
using the default DEMODATA directory, I can't access it. I can create
an empty database, but cannot access it either. Ergo: there isn't any
database present, I can create new ones but then the PCC doesn't let
me access them.

Any shed of light? Thanks!

DEMODATA doesn't work? This is bad. I would recommend uninstalling &
starting the database engine install over again. Verify that DEMODATA
works FIRST, and then everything else should follow.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 11/13/2007 ***


raschaoot (AT) gmail (DOT) com wrote:



--

I understand that that would be the first reaction but I want to evade
a reinstall at all costs, for fear of our software seizing to run
afterwards (which would be utterly desastrous).

Besides, it should not be necessary because the PSQL server is
obviously functioning: the software works without problems (through
BTRIEVE) and if I log into the PCC and open the Active Users tab in
the monitor on a regular weekday, I can see that people are logged in
(through the software).

Anyway, I'm completely lost since it doesn't seem to have to do with
access rights either: even if I put access rights on "Allow everything
for everyone", the PSQL server still throws the earlier given
exception. Besides, I'm locally logged in as administrator.

Any suggestions?

The Btrieve and SQL interfaces are related, but still different.
Obviously, Btrieve is fine, but SQL is damaged in some way.

A reinstall from the server console (not via RDP) is in order.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 11/13/2007 ***

raschaoot (AT) gmail (DOT) com wrote:



--