Hi Guys,
Broadly, I'm trying to read and write to a postgres database from a VB6 application.
There's seems to be two main ways to accomplish this; OleDB or ODBC and I hit a
roadblock with both of them.
I've just installed postgres 8.3.1 using the pginstaller package on a WinXp Pro
x64 SP2 Box. I also installed the PgOleDB v1.0.0.20 and psqlODBC drivers
v08.03.0100.
It would seems that PgOleDB is a read-only provider (a show stopper for me).
From what I've read in the oledb-devel list archives there a bit of movement on
adding write functionality but currently it's not finished.
On the ODBC front there's no driver listed in my OBDC data source administrator
with which to make a dsn (after driver installation). I've found posts
suggesting I need to run the 'other' data source administrator. Both:
%SystemRoot%\system32\odbcad32.exe, and
%SystemRoot%\sysWOW64\odbcad32.exe
list the same drivers available.
From reading elsewhere I think the source of the issue is that I need an x64
driver to achieve what I'm trying to do but I can't find one.
Any suggestions how I might make this work? Hopefully short of "install WinXp
vanilla" :)
-Karl.
