Re: Need help with Visual Basic 6 and PostgreSQL

["Thomas H." <me(at)alternize(dot)com>]

> In other words, does registering an ODBC driver automatically make it 
> subject to any configurations made with ODBC Data Source Administrator?

as i understand it: partly. i.e. the connection pooling configuration 
options you specify in the ODBC Data Source Administrator is a global 
setting.

> 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?

no. i have no problems accessing a DB with and without oids using this 
connection string:

Driver={PostgreSQL 
UNICODE};Server=yourserver;Port=5432;Database=yourdb;UID=youruser;pwd=yourpassword;TrueIsMinus1=1;BoolsAsChar=0;TextAsLongVarchar=1;UseDeclareFetch=0

>             rsOut.Open """Contact1""", dbOut, adOpenDynamic, 
> adLockOptimistic, adCmdTable

try this:

rsOut.Open "SELECT * FROM ""Contact1""", dbOut, adOpenDynamic, 
adLockOptimistic

the problem might be the adCmdTable recordset type.

regards,
thomas