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