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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: Versioning

=20

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org=20
> [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
>=20
> Hey folks,
>=20
> 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=20=
=20
> app that supports odbc on windows. So I went to grab the=20
> latest odbc
> and noticed after I installed that the driver is 8.x. Should=20
> this be
> OK?

Yes.

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: Versioning

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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: Versioning

> 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

Re: Versioning

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


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

http://www.postgresql.org/docs/faq