Re: user "Admin" does not exist / relation "mysysconf" does not exist

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: Philippe Lang <philippe(dot)lang(at)attiksystem(dot)ch>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: user "Admin" does not exist / relation "mysysconf" does not exist
Date: 2004-05-24 13:51:07
Message-ID: 20040524135107.90312.qmail@web20813.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc


--- Philippe Lang <philippe(dot)lang(at)attiksystem(dot)ch>
wrote:
> Hello,
>
> I'm using MS Access 2000, Postgresql ODBC driver
> 7.03.02.09 (the latest
> at the moment), and Postgresql 7.4.2 under FreeBSD.
>
> Everything works fine, except that I have noticed
> some strange messages
> in /var/log/messages, from the database server:
>
> --------------------------------------
> 1) user "Admin" does not exist
> --------------------------------------
> I have configured my ODBC connection with the pgsql
> user, and relinked
> all tables from the Access database, but everytime I
> start a connection
> to the serveur, I get this error. I have spoofed the
> network with
> etherreal, and I could see that the client first
> tries a connection with
> the admin username, which fails, and only then with
> the correct
> username.
>
> That's a waist of time, were does that come from? Is
> that problem
> application (Access) based? Or is that maybe an ODBC
> problem? When I
> connect to the server with pgAdmin III, I do not see
> anything like that
> in the log.
>

Access attempts to connect first as user "Admin".
Yes, it's a waste of time, but it doesn't hurt
anything.

>
> --------------------------------------
> 2) relation "mysysconf" does not exist
> --------------------------------------
> What exactly is this relation? Does anyone know?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/achowMsysconfTableAttachedSqlDatabasesS.asp

>
>
> Thanks to all
>
> Philippe
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the
> postmaster-------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster



__________________________________
Do you Yahoo!?
Yahoo! Domains Claim yours for only $14.70/year
http://smallbusiness.promotions.yahoo.com/offer

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Karsten Hilbert 2004-05-24 23:59:29 Re: I want to use postresql for this app, but...
Previous Message Philippe Lang 2004-05-24 09:32:39 user "Admin" does not exist / relation "mysysconf" does not exist