From: Byron Nikolaidis <byronn@insightdist.com>
To: Michael Davis <michael.davis@prevuenet.com>
Cc: 'pgsql-interfaces@postgresql.org' <pgsql-interfaces@postgresql.org>
Subject: Re: Access problems
Date: Fri, 26 Feb 1999 09:05:21 -0500
Message-ID: <36D6AA21.970B847D@insightdist.com> (raw)
References: <93C04F1F5173D211A27900105AA8FCFC145205@lambic.prevuenet.com>
Michael Davis wrote:
> The sql.log file is over 5M. There are no references to foreign keys
> anywhere in the log file. I noticed the following:
> Orders 138:118 ENTER SQLExecDirect
> HSTMT 0x09072230
> UCHAR * 0x040f10f0 [ -3] "SELECT
> Config, nValue FROM MSysConf\ 0"
> SDWORD -3
> This failed because my Postgres database does not have this table. Any idea
> what MsysConf, what it contains, or how to create it? Could this have
> anything to do with my Access subform problem?
>
No. This is a normal Access warning. It is looking for a configuration file
for the Jet database engine. It is optional.
But it is interesting that there are no references to "SQLForeignKeys". What's
up with that? Are there any references to SQLPrimaryKeys?
I don't understand -- if it doesn't call SQLForeignKeys, how else would it find
out about this information?
Byron
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, michael.davis@prevuenet.com
Subject: Re: Access problems
In-Reply-To: <36D6AA21.970B847D@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox