Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
"Philippe Lang"
Date:
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.


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


Thanks to all

Philippe

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

From
Jeff Eckermann
Date:
--- Philippe Lang <philippe.lang@attiksystem.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