🚀 go-pugleaf

My app uses an OpenSchema() call to get a list of field names when a database
is opened, to verify that the ones required for correct operation exist.  The
database is an Access 2000 .mdb file.

The syntax of the call was this:

dataConn->OpenSchema(siColumns, EmptyParam, EmptyParam, FieldNames);

'FieldNames' is a TADODataSet object.

The call works consistently on this machine, and on another machine at the
office.

It does not work on any other machines at the office, or on another machine
here.  An exception is thrown with the "blah blah blah not supported by
provider" message.

Both machines here use Windows 2000, as do most (if not all) machines at the
office.

Well, after a large amount of searching, I tried setting the restrictions
parameter, like this:

Variant tvars[3];

tvars[0]=Unassigned();
tvars[1]=Unassigned();
tvars[2]=cstring; // name of table

dataConn->OpenSchema(siColumns, VarArrayOf(tvars, 2), EmptyParam,
FieldNames);

And it works on both machines here now.  I haven't tried it on the other
office machines yet.

So, why does this call work with an empty second parameter on one machine but
not another?


--
 - Mike

Remove 'spambegone.net' and reverse to send e-mail.