Thread: Access and PG ODBC problem

anthony.caduto@micorp.com wrote:
>
> 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.

Don't know if this will help - but did you try checking "Row Versioning"
on in the ODBC driver?

Andrew Ayers

-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain
informationthat is privileged, confidential and exempt from disclosure under applicable law. If you are not the
intendedaddressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use,
copy,disclose or distribute to anyone the message or any information contained in the message. If you have received
thismessage in error, please immediately advise the sender by reply email, and delete the message. Thank you. 

---

From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of anthony.caduto@micorp.com
Sent: 04 October 2004 22:39
To: pgsql-odbc@postgresql.org
Subject: [ODBC] Access and PG ODBC problem

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. 
 

---

From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of anthony.caduto@micorp.com
Sent: 05 October 2004 15:07
To: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Access and PG ODBC problem

Hi Dave,
Thanks for the Info, switching to that latest snapshot did the trick.

Would it be possible to get a updated msi installer out there with the newest version? 

---

From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of anthony.caduto@micorp.com
Sent: 05 October 2004 15:19
To: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Access and PG ODBC problem

Hi Dave,
Is the MSI script available somewhere so I could build my own installer?  

 

 
The latest snapshot is a lot more stable than the Nov 2003 stable release and i will need the version that does not have the OID issue to continue with my Access/Postgresql rollout.

Any reason why you are using MSI instead of something like Inno Setup (http://www.jrsoftware.com)?  

 

 

I would be willing to maintain a snapshot installer if you need some extra help.