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 [email protected] <mailto:[email protected]>
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