Thread: Win32 ODBC Issue!
Hello!
I have installed Redhat Linux 7.2 and Postgresql-7.1 as a database.
I have a server-side program, which works with postgresql on Linux (writes some data to it) and need to write a client program on Windows.
I downloaded a driver from odbc.postgresql.org, but it is outdated (v.7.01): It doesn't support encrypted passwords, so it cannot connect to my database (even I do not supply passwords at all)
Where can I download the latest ODBC driver?
Thanks in advance.
Hello Медер, Monday, December 03, 2001, 8:49:47 AM, you wrote: МБ> Hello! МБ> I have installed Redhat Linux 7.2 and Postgresql-7.1 as a database. МБ> I have a server-side program, which works with postgresql on Linux (writes some data to it) and need to write a clientprogram on Windows. МБ> I downloaded a driver from odbc.postgresql.org, but it is outdated (v.7.01): It doesn't support encrypted passwords,so it cannot connect to my database (even I do not supply passwords at all) МБ> Where can I download the latest ODBC driver? МБ> Thanks in advance. ODBC driver is NOT outdated. Drivers has their own versioning, that is not the same as Postgresql's one. ODBC does not support encrypted passwords, so you have to use plain text authentification with your Windows client. BTW, the latest version of Postgresql ODBC drivers is 7.01.0009. -- Best regards, evgeny mailto:evgeny@iplus.ru
> -----Original Message----- > From: luk@iplus.ru [mailto:luk@iplus.ru] > Sent: 03 December 2001 07:43 > To: pgsql-odbc@postgresql.org > Subject: Re: [ODBC] Win32 ODBC Issue! > > > ODBC driver is NOT outdated. Drivers has their own > versioning, that is not the same as Postgresql's one. ODBC > does not support encrypted passwords, so you have to use > plain text authentification with your Windows client. > > BTW, the latest version of Postgresql ODBC drivers is 7.01.0009. Actually we are vaguely following the PostgreSQL versions - at least in Major/Minor number. The revision number doesn't follow PostgreSQL though. The formatting of the number is also slightly different - this is to comply with certain elements of the ODBC spec which expects version numbers in xx.xx.xxxx form - hence the PostgreSQL 7.1 ODBC drivers version is 07.01.xxxx Regards, Dave.
Can you post your pg_hba.conf file _to the list_, and note what your client IP address is please - this is almost certainly where the problem lies I would guess. Regards, Dave. > -----Original Message----- > From: bakirov@green.net.kg [mailto:bakirov@green.net.kg] > Sent: 03 December 2001 14:02 > To: Dave Page > Subject: Re: [ODBC] Win32 ODBC Issue! > > > Hi there! > > I have tried to give trust and plain password access > settings, but both did not work me! By the way I have a Java > application, which uses Postgresql JDBC (v7.2, installed by > default), which comes with RedHat Linux. I wrote an > application on Java and it just works fine with database, > whether it uses encrypted or plain passwords, but I have no > luck with ODBC :( ---- > :-) > I downloaded the latest ODBC form odbc.postgresql.org (which > is 7.01.009) and tried it - the problem persists - even I use > plain passwords and make that host(network) trust (no > password). It gives me an error (encrypted passwords not supported). > > Any idea? > > Thanks... > > ----- Original Message ----- > From: "Dave Page" <dpage@vale-housing.co.uk> > To: "'evgeny'" <evgeny@don.sitek.net>; <pgsql-odbc@postgresql.org> > Sent: Monday, December 03, 2001 1:49 PM > Subject: Re: [ODBC] Win32 ODBC Issue! > > > > > > > > > -----Original Message----- > > > From: luk@iplus.ru [mailto:luk@iplus.ru] > > > Sent: 03 December 2001 07:43 > > > To: pgsql-odbc@postgresql.org > > > Subject: Re: [ODBC] Win32 ODBC Issue! > > > > > > > > > ODBC driver is NOT outdated. Drivers has their own > versioning, that > > > is not the same as Postgresql's one. ODBC does not > support encrypted > > > passwords, so you have to use plain text authentification > with your > > > Windows client. > > > > > > BTW, the latest version of Postgresql ODBC drivers is 7.01.0009. > > > > Actually we are vaguely following the PostgreSQL versions > - at least > > in Major/Minor number. The revision number doesn't follow > PostgreSQL > > though. The formatting of the number is also slightly > different - this > > is to > comply > > with certain elements of the ODBC spec which expects > version numbers > > in xx.xx.xxxx form - hence the PostgreSQL 7.1 ODBC drivers > version is > > 07.01.xxxx > > > > Regards, Dave. > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org > >
The first correct match in the file is used: host ispstat 0.0.0.0 0.0.0.0 crypt host ispstat 192.168.0.0 255.255.255.0 trust So *all* connections will use crypt. Try swapping the 2 entries around (note that that will open up your database to the entire 192.168.0.x subnet which may be a bad thing - you might want to try password instead of trust :-) ). Regards, Dave. > -----Original Message----- > From: bakirov@green.net.kg [mailto:bakirov@green.net.kg] > Sent: 03 December 2001 15:17 > To: Dave Page > Subject: Re: [ODBC] Win32 ODBC Issue! > > > Here is my conf. file > > Regards, Mika. > > > ----- Original Message ----- > From: "Dave Page" <dpage@vale-housing.co.uk> > To: "'????? ???????'" <bakirov@green.net.kg> > Cc: <pgsql-odbc@postgresql.org> > Sent: Monday, December 03, 2001 7:08 PM > Subject: Re: [ODBC] Win32 ODBC Issue! > > > > Can you post your pg_hba.conf file _to the list_, and note what your > client > > IP address is please - this is almost certainly where the > problem lies > > I would guess. > > > > Regards, Dave. > > > > > -----Original Message----- > > > From: bakirov@green.net.kg [mailto:bakirov@green.net.kg] > > > Sent: 03 December 2001 14:02 > > > To: Dave Page > > > Subject: Re: [ODBC] Win32 ODBC Issue! > > > > > > > > > Hi there! > > > > > > I have tried to give trust and plain password access > settings, but > > > both did not work me! By the way I have a Java application, which > > > uses Postgresql JDBC (v7.2, installed by default), which > comes with > > > RedHat Linux. I wrote an application on Java and it just > works fine > > > with database, whether it uses encrypted or plain > passwords, but I > > > have no luck with ODBC :( ---- > > > :-) > > > I downloaded the latest ODBC form odbc.postgresql.org (which > > > is 7.01.009) and tried it - the problem persists - even I use > > > plain passwords and make that host(network) trust (no > > > password). It gives me an error (encrypted passwords not > supported). > > > > > > Any idea? > > > > > > Thanks... > > > > > > ----- Original Message ----- > > > From: "Dave Page" <dpage@vale-housing.co.uk> > > > To: "'evgeny'" <evgeny@don.sitek.net>; <pgsql-odbc@postgresql.org> > > > Sent: Monday, December 03, 2001 1:49 PM > > > Subject: Re: [ODBC] Win32 ODBC Issue! > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > From: luk@iplus.ru [mailto:luk@iplus.ru] > > > > > Sent: 03 December 2001 07:43 > > > > > To: pgsql-odbc@postgresql.org > > > > > Subject: Re: [ODBC] Win32 ODBC Issue! > > > > > > > > > > > > > > > ODBC driver is NOT outdated. Drivers has their own > > > versioning, that > > > > > is not the same as Postgresql's one. ODBC does not > > > support encrypted > > > > > passwords, so you have to use plain text authentification > > > with your > > > > > Windows client. > > > > > > > > > > BTW, the latest version of Postgresql ODBC drivers is > 7.01.0009. > > > > > > > > Actually we are vaguely following the PostgreSQL versions > > > - at least > > > > in Major/Minor number. The revision number doesn't follow > > > PostgreSQL > > > > though. The formatting of the number is also slightly > > > different - this > > > > is to > > > comply > > > > with certain elements of the ODBC spec which expects > > > version numbers > > > > in xx.xx.xxxx form - hence the PostgreSQL 7.1 ODBC drivers > > > version is > > > > 07.01.xxxx > > > > > > > > Regards, Dave. > > > > > > > > ---------------------------(end of > > > > broadcast)--------------------------- > > > > TIP 6: Have you searched our list archives? > > > > > > > > http://archives.postgresql.org > > > > > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 3: 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 > > >
> The first correct match in the file is used: > > host ispstat 0.0.0.0 0.0.0.0 crypt > host ispstat 192.168.0.0 255.255.255.0 trust > > So *all* connections will use crypt. Try swapping the 2 entries around (note > that that will open up your database to the entire 192.168.0.x subnet which > may be a bad thing - you might want to try password instead of trust :-) ). FYI, 7.2 ODBC will support MD5 encrypted passwords. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
> -----Original Message----- > From: Bruce Momjian [mailto:pgman@candle.pha.pa.us] > Sent: 03 December 2001 16:29 > To: Dave Page > Cc: '????? ???????'; 'pgsql-odbc@postgresql.org' > Subject: Re: [ODBC] Win32 ODBC Issue! > > > > The first correct match in the file is used: > > > > host ispstat 0.0.0.0 0.0.0.0 crypt > > host ispstat 192.168.0.0 255.255.255.0 trust > > > > So *all* connections will use crypt. Try swapping the 2 > entries around > > (note that that will open up your database to the entire > 192.168.0.x > > subnet which may be a bad thing - you might want to try password > > instead of trust :-) ). > > FYI, 7.2 ODBC will support MD5 encrypted passwords. Yes, so I saw. pgAdmin II already supports that rather nice new feature (and in fact did within a very short time of your patch being committed :-) ). Dave.
Hello Медер, Monday, December 03, 2001, 8:49:47 AM, you wrote: МБ> Hello! МБ> I have installed Redhat Linux 7.2 and Postgresql-7.1 as a database. МБ> I have a server-side program, which works with postgresql on Linux (writes some data to it) and need to write a clientprogram on Windows. МБ> I downloaded a driver from odbc.postgresql.org, but it is outdated (v.7.01): It doesn't support encrypted passwords,so it cannot connect to my database (even I do not supply passwords at all) МБ> Where can I download the latest ODBC driver? МБ> Thanks in advance. ODBC driver is NOT outdated. Drivers has their own versioning, that is not same as Postgresql's one. ODBC does not support encrypted passwords, so you have to use clear text authentification with your Windows client. BTW, the latest version of Postgresql ODBC drivers id 7.01.0009. -- Best regards, evgeny mailto:evgeny@iplus.ru