From: | "Andrew Maclean" <a(dot)maclean(at)cas(dot)edu(dot)au> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | ODBC MSAccess |
Date: | 2006-01-17 01:09:58 |
Message-ID: | 006c01c61b02$bc965090$c5d24e81@acfr.usyd.edu.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am accessing PostgreSQL through MS Access.
Everything works Ok if I manually connect through Access using the ODBC
Dialog.
However I wrote a VB function that opens the database and connects to it.
This works provided there is no int8 column in the PostgresSQL table.
When I use the ODBC interface to link the tables, int8 columns on PostGreSQL
are mapped to Number in Access and everything works OK.
However when I use connection string as in VB the int8 columns are mapped to
Binary in Access.
Does anyone know what parameters I need to set in the ODBC string to fix
this? I can't find any documentation.
There is an Int8 section in the ODBC interface but I cant find any
corresponding parameter to set in a connection string.
By the way the options I am using in the VB connection string are:
"PORT=5432;SSLMODE=prefer;A6=;A7=100;A8=8192;B0=254;B1=8190;BI=8190;C2=dd_;C
X=1b503a9"
Thanks
Andrew
___________________________________________
Andrew J. P. Maclean
Centre for Autonomous Systems
The Rose Street Building J04
The University of Sydney 2006 NSW
AUSTRALIA
Ph: +61 2 9351 3283
Fax: +61 2 9351 7474
URL: http://www.cas.edu.au/
___________________________________________
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Browne | 2006-01-17 03:35:24 | Re: Create/Erase 5000 Tables in PostGRE SQL in execution |
Previous Message | Jim C. Nasby | 2006-01-16 23:14:41 | Re: Ref cursor with Geometric Function |