Обсуждение: user "Admin" does not exist / relation "mysysconf" does not exist
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
--- 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