Re: Need help with Visual Basic 6 and PostgreSQL

[Finn Lassen <dcio(at)AxiomInt(dot)com>]

A basic question:
In a connection string, if you only specify a driver name ("PostgreSQL 
ANSI"), instead of a DSN configured with the ODBC Data Source 
Administrator, do any configuration changes made with the ODBC Data 
Source Administrator affect the driver itself?
In other words, does registering an ODBC driver automatically make it 
subject to any configurations made with ODBC Data Source Administrator?

I still don't understand the:
"ERROR: Column "oid" does not exist;"
I get when executing the " rsOut.Open ..." statement below.
Can the ODBC driver only handle tables with oid columns?

   Dim cn As ADODB.Connection
   Dim rsOut As ADODB.Recordset
   Set cn = New ADODB.Connection
   Set rsOut = New ADODB.Recordset
   With cn
       .ConnectionString = "Driver={PostgreSQL 
ANSI};Server=localhost;Port=5432;Database=postgres;Uid=user;Pwd=secret;"
       .Open
       With rsOut
            rsOut.Open """Contact1""", dbOut, adOpenDynamic, 
adLockOptimistic, adCmdTable

Finn