> 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