Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] Access 2000

From: Byron Nikolaidis <byronn(at)solipsys(dot)com>
To: Michael Doyle <relyod(at)co-operation-ireland(dot)ie>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] Access 2000
Date: 1999-08-23 17:34:00
Message-ID: 37C18608.D5D0AE6F@solipsys.com (view raw or flat)
Thread:
Lists: 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



In response to

pgsql-interfaces by date

Next:From: Lamar OwenDate: 1999-08-23 17:39:35
Subject: Re: [INTERFACES] with Tcl 8.2.0 -> libpgtcl.so: undefined symbol: PQresStatus
Previous:From: Michael DoyleDate: 1999-08-23 17:33:35
Subject: Re: [INTERFACES] Access 2000

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group