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

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 (view raw or flat)
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

pgsql-odbc by date

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

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