[ale] Win ODBC --> Linux postgreSQL

Terry Lee Tucker terry at leetuckert.net
Wed Oct 11 11:58:32 EDT 2006


On Wednesday 11 October 2006 08:39 am, Allan Metts <ametts2 at mindspring.com> 
thus communicated:
>  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?
>
>  Allan
>

I would suggest you go to www.postgresql.org and subscribe to a mailing list. 
They have several mailing lists and I think there is one for ODBC; however, 
the "general" list is also a great place to ask questions.
-- 
Terry Lee Tucker
Turbo's IT Manager
Turbo, division of Ozburn-Hessey Logistics
2251 Jesse Jewell Pkwy NE
Gainesville, GA 30501
Tel: (336) 372-6812  Fax: (336) 372-6812  Cell: (336) 363-4719
terry at turbocorp.com
www.turbocorp.com




More information about the Ale mailing list