Re: VB6 ODBC

Jaap,

To connect a VB6 application to PostgreSQL you need the 32 bit ODBC
driver even when Windows is 64 bit.

So pick-up the x86 version of the driver from
https://www.postgresql.org/ftp/odbc/versions/msi/ and install it.

Verify that you have the 32 bit driver installed by:

    Running the 32 bit version of ODBC Data Source Administration
c:\Windows\SysWOW64\odbcad32.exe

    Look at the Drivers tab to see PostgreSQL ODBC

Note that if you installed the 64 bit driver it will appear in the 64
bit version of ODBC Data Source Administration
c:\Windows\System32\odbcad32.exe

Tom

Tom Goodman, email TomGoodman(at)MHProEZ(dot)com <mailto:TomGoodman(at)MHProEZ(dot)com>
1406 Tenth St., Bay City, MI 48708, USA, Phone 989 893 1450
* God grant me the serenity to accept the code I cannot change
* the courage to change the code I can change
* and the wisdom to know the difference

On 2018-05-31 06:34, Jaap Van Oosten wrote:
> Hello sir's
> We want to run A VisiualBasic6 application connected with postgreSQL.
> This application was running with Windows XP over many years.
> Now the PC must be replaced by W7pro 64bit system.
> I have installed postgreSQL 8.4  and psqlodbc_9_00_0310-x64  and later
> versions.
> The W7 ODBC (32bit) datasource administrator does find : PostgreSql30
> unicode(x64) source. Connection test ok. Vb6 data environment finds:
> PostgreSql OLE DB Provider but this one cannot connect with the pgSQL
> server.
> I think this should be an ODBC type provider
>
> The question is:  is there a PostgreSql ODBC driver for W7pro 64b that
> will work with VB6.?
> Kind regards
> Jaap van Oosten