From: | anthony(dot)caduto(at)micorp(dot)com |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Access and PG ODBC problem |
Date: | 2004-10-04 21:39:03 |
Message-ID: | OF05E07CA7.146C1DC0-ON86256F23.00769846-86256F23.00770346@micorp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi,
I am trying to convert some access databases to use PG linked tables and
all was going good until I tried to do some stuff in VBA script..
Dim conn As New ADODB.Connection
Set conn = New ADODB.Connection
conn.Open
"driver={PostgreSQL};server=192.168.1.29;port=5432;database=mydb;uid=postgres;pwd=;ksqo=;"
Dim rs As New ADODB.Recordset
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseServer
rs.Open "select * from lw_partnershipdata.switchboard_remote", conn,
adOpenDynamic, adLockOptimistic, adCmdText
It all goes good until the last line and then I get this error:
Column "OID" does not exist
None of my tables have OIDs as they are large and I don't want the
overhead of the OIDs.
Any help/Ideas would be appreciated.
Thanks,
Tony Caduto
Senior Programmer/Analyst
M&I Trust and Investment Management
From | Date | Subject | |
---|---|---|---|
Next Message | Sandro Yaqub Yusuf | 2004-10-04 21:52:53 | Re: Executing SP in VB6 |
Previous Message | anthony.caduto | 2004-10-04 21:35:19 | Re: Schema support |