Обсуждение: Versioning
Hey folks, Sorry if I missed this being covered in a FAQ, but the odbc driver version numbers are a little confusing. Do I need to match odbc driver version numbers to my postgres install version numbers? I have 7.4.6 on my redhat server, and want to connect with a 3rd party app that supports odbc on windows. So I went to grab the latest odbc and noticed after I installed that the driver is 8.x. Should this be OK? Thanks for any help! - Jim
> -----Original Message----- > From: pgsql-odbc-owner@postgresql.org > [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Jim Beard > Sent: 24 January 2006 17:02 > To: pgsql-odbc@postgresql.org > Subject: [ODBC] Versioning > > Hey folks, > > Sorry if I missed this being covered in a FAQ, but the odbc driver > version numbers are a little confusing. Do I need to match odbc > driver version numbers to my postgres install version numbers? I > have 7.4.6 on my redhat server, and want to connect with a 3rd party > app that supports odbc on windows. So I went to grab the > latest odbc > and noticed after I installed that the driver is 8.x. Should > this be > OK? Yes. Regards, Dave
Is there an easy way to test the ODBC and DSN settings external to the third party app I am using? I'm haven't made odbc connections before. Postmaster seems to be running with -i and I see it is listening to 5432 when I check netstat. The third party app either complains about not being able to connect when I try to configure the DSN, and failure to login when I try to make a connection using that DSN. How can I get better error messages? Is there a better app to use to confirm the odbc connection ability? Jim On Jan 24, 2006, at 9:06 AM, Dave Page wrote: > > >> -----Original Message----- >> From: pgsql-odbc-owner@postgresql.org >> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Jim Beard >> Sent: 24 January 2006 17:02 >> To: pgsql-odbc@postgresql.org >> Subject: [ODBC] Versioning >> >> Hey folks, >> >> Sorry if I missed this being covered in a FAQ, but the odbc driver >> version numbers are a little confusing. Do I need to match odbc >> driver version numbers to my postgres install version numbers? I >> have 7.4.6 on my redhat server, and want to connect with a 3rd party >> app that supports odbc on windows. So I went to grab the >> latest odbc >> and noticed after I installed that the driver is 8.x. Should >> this be >> OK? > > Yes. > > Regards, Dave > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster
> Postmaster seems to be running with -i and I see it is listening to > 5432 when I check netstat. The third party app either complains > about not being able to connect when I try to configure the DSN, and > failure to login when I try to make a connection using that DSN. What psqlodbc version do you use? What settings do you use? What way do you use to connect? You could try setup the DSN throught ODBC manager and test it with whatever you want (e.g. office, VBA, ...). I don't know what you use. > How can I get better error messages? Is there a better app to use to > confirm the odbc connection ability? Hard to say without more informations. What display you app? Regards, Luf
Thank you all for the effort. We were eventually able to resolve the problem. Mainly there were issues with the server configuration and not the odbc driver. Jim On Jan 24, 2006, at 12:18 PM, Ludek Finstrle wrote: >> Postmaster seems to be running with -i and I see it is listening to >> 5432 when I check netstat. The third party app either complains >> about not being able to connect when I try to configure the DSN, and >> failure to login when I try to make a connection using that DSN. > > What psqlodbc version do you use? What settings do you use? > What way do you use to connect? > You could try setup the DSN throught ODBC manager and test it with > whatever you want (e.g. office, VBA, ...). I don't know what you > use. > >> How can I get better error messages? Is there a better app to use to >> confirm the odbc connection ability? > > Hard to say without more informations. > What display you app? > > Regards, > > Luf > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that > your > message can get through to the mailing list cleanly