We run Postgres on a solaris server.
I connect to the postgres database from win98 and winxp boxes using
postgres odbc driver ver. 7.02.00.05
works every time and i appreciate that.

but so far I am unable to connect from a windows 2000 server box on the
same network.
when i try to use control panel and set up a file dsn with the same
driver and same parameters, I get the error messsage "a connection could
not be made using the file datasource parameters entered"

I turned logging on, but nothing is written to c: so perhaps the
connection must be successful before anything is written to the log.

when I create a user dsn and then use a MS tool called ODBCTest and try
to connect I get SQL_ERROR=-1.
ODBCtest says I can get a detailed explanation of the error by clicking
an error button, but the button is disabled.

I have searched the postgres docs (admittedly not exhaustively) and
have come up with nothing.

I am a programmer not a network engineer and don't even know where I
should look next to search for the answer.

Any ideas?

Thanks in advance for any help you can extend.

Fred Parkinson


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

On Thursday 14 October 2004 15:46, you wrote:
You need to look in the error logs of the database. You should have some type
of message starting with "FATAL" which will give you a detailed error message
explaining why you can not get the connection. If you don't have those, then
either your logging needs to be tweaked or your not making contact between
the two machines, so verify your connection settings (hostname/port)

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html