[ale] Win ODBC --> Linux postgreSQL

[Bob Kruger]

Allan;

I have some experience with Postgresql and ODBC, but not with SSH involved.  

I am not trying to be insulting, but in eliminating some of the simple stuff, can you verify that the version of Postgres tha tyou are dealing with was compiled with ODBC support?

V/r

Bob

-----Original Message-----
>From: Allan Metts <ametts2 at mindspring.com>
>Sent: Oct 11, 2006 8:39 AM
>To: ale at ale.org
>Subject: [ale] Win ODBC --> Linux postgreSQL
>
>Does anyone have experience debugging Windows ODBC database 
>connections to a Linux database?  I have some database work to do for 
>an upcoming proposal -- and what I need to do would go much smoother 
>if I could connect directly to our data center's postgresql 
>installation using MS Excel and MS Access.
>
>I set up the server's postgres installation with odbc, and have 
>verified connectivity to it on that machine using isql (also running 
>on this server) from the unixODBC package.  Postgresql is listening 
>on localhost port 5432 (which is not visible to the outside world).
>
>I set up a ssh tunnel on port 5432.
>
>Then I downloaded, installed, and configured the Windows ODBC drivers 
>for PostgreSQL, and they fail to connect.  telnetting to localhost 
>5432 on the client seems to indicate some sort of listener out there. 
>The relevant traces appear below.
>
>Anyone ever been here before?
>