Re: [INTERFACES] Access 2000 - Mailing list pgsql-interfaces

From Byron Nikolaidis
Subject Re: [INTERFACES] Access 2000
Date
Msg-id 37C18608.D5D0AE6F@solipsys.com
Whole thread Raw
In response to Access 2000  (Michael Doyle <relyod@co-operation-ireland.ie>)
List pgsql-interfaces

Michael Doyle wrote:

> At 12:16 23/08/99 -0400, Byron Nikolaidis wrote:
> >
> >Do you see any error messages, either on screen or in any of the logfiles?
> >
> >Byron
>
> Byron,
>
> In the log files I see access issues the following:
>         query 'SELECT Config, nValue from MSysConf'
>
> to which the server responds
>         'ERROR: msysconf: Table does not exist.'
>
> In other words, Access seems to be looking for a configuration table
> which PostgreSQL does not have. When it can't find it, Access then
> refuses to do any more.
>

This is normal and has always been there.  It is an optional file to configure
some things in Access.

Can you attach both the psqlodbc.log and sql.log files?  There might be a
subtle thing in how it gets the tables.

Byron




pgsql-interfaces by date:

Previous
From: Michael Doyle
Date:
Subject: Re: [INTERFACES] Access 2000
Next
From: Lamar Owen
Date:
Subject: Re: [INTERFACES] with Tcl 8.2.0 -> libpgtcl.so: undefined symbol: PQresStatus