Thread: (ODBC) Error connecting to postgres 7.2.2
ODBC driver version insight distr. stms 6.40.0006
PostgreSQL database version 7.2.2
Hi All,
Probably a common question, but i couldn't find any answers on the net.
This ODBC driver connects fine to one of our servers running Postgres 7.0.2
It fails however to connect to another server running PG 7.2.2. After a very,
very long timeout it says something like : "Database does not exist or user
unknown".
I've logged the connection, and it fails on sending an empty query!. It doesnt
get a result and tears down the connection.
--
Regards,
Rick
REAC BV
---------------------------------------------------------------------------------------------------------------
"All men are mortal. Socrates was mortal. Therefore, all men are Socrates.
(Woody Allen)"
---------------------------------------------------------------------------------------------------------------
--
REAC BV
Sevillaweg 62
3047 AL ROTTERDAM
tel +31 10 4156419
fax +31 10 2450623
www.reac.nl
info@reac.nl
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Why not just try the PostgreSQL driver? http://gborg.postgresql.org/project/psqlodbc/projdisplay.php --- Rick <rick@reac.nl> wrote: > ODBC driver version insight distr. stms > 6.40.0006 > PostgreSQL database version 7.2.2 > > Hi All, > > Probably a common question, but i couldn't find any > answers on the net. > > This ODBC driver connects fine to one of our servers > running Postgres 7.0.2 > It fails however to connect to another server > running PG 7.2.2. After a very, > very long timeout it says something like : "Database > does not exist or user > unknown". > > I've logged the connection, and it fails on sending > an empty query!. It doesnt > get a result and tears down the connection. > > > -- > Regards, > > Rick > REAC BV > > --------------------------------------------------------------------------------------------------------------- > "All men are mortal. Socrates was mortal. > Therefore, all men are Socrates. > > (Woody Allen)" > --------------------------------------------------------------------------------------------------------------- > > > -- > REAC BV > Sevillaweg 62 > 3047 AL ROTTERDAM > tel +31 10 4156419 > fax +31 10 2450623 > www.reac.nl > info@reac.nl > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > > ---------------------------(end of > broadcast)--------------------------- > TIP 8: explain analyze is your friend __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com