From: | Karl Martindale <karl(at)posmaster(dot)com(dot)au> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Postgres -> VB6 |
Date: | 2008-04-07 01:40:40 |
Message-ID: | 47F97B98.9050801@posmaster.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | richard terry | 2008-04-07 03:45:13 | Re: best practices for dumping databases |
Previous Message | Tom Lane | 2008-04-07 01:24:04 | Re: best practices for dumping databases |