Re: VB6 ODBC

Jaap,

I am using psqlodbc_09_03_0400 downloaded as psqlodbc_09_03_0400.zip
(5.9mb) to talk to postgresql-9.6.1-1-windows-x64.exe

https://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_09_03_0400.zip

https://get.enterprisedb.com/postgresql/postgresql-9.6.9-1-windows-x64.exe
(closest version to my current version)

My VB6 ADO connection string is: Provider=MSDASQL;Driver=PostgreSQL ODBC
Driver(ANSI);SERVER=localhost;PORT=5432;UID=postgres;Pwd=xxxxxxxx;DATABASE=fred;ByteaAsLongVarBinary=1;BoolsAsChar=0;

I have not used the unicode driver, only the ANSI driver for connections
to postgres.

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 12:33, Tom Goodman wrote:
> 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
>
>