|
 |
activex_data_objects thread: OpenSchema method: problem with MS Access and adSchemaForeignKeys
Message #1 by "Cormac O'Keeffe" <9923837@s...> on Thu, 6 Feb 2003 21:48:11
|
|
Driver="Microsoft Access Driver (*.mdb)";
DataBasePath="C:\Inetpub\FYP\fypadmin.mdb";
Source="Driver=#Driver#;DBQ=#DataBasePath#";
ConnectionObject.Open("#Source#",
adModeUnknown,
adFailIfNotExists,
adOpenRecordUnspecified);
Message #2 by "Cormac O'Keeffe" <9923837@s...> on Thu, 6 Feb 2003 21:54:40
|
|
The following code is written in Coldfusion (cfml). All i am doing is
opening a ADODB.Connection called ConnectionObject on an MS Access
database.
#############################################
Driver="Microsoft Access Driver (*.mdb)";
DataBasePath="C:\Inetpub\FYP\fypadmin.mdb";
Source="Driver=#Driver#;DBQ=#DataBasePath#";
ConnectionObject.Open("#Source#",
adModeUnknown,
adFailIfNotExists,
adOpenRecordUnspecified);
##############################################
I then use the OpenSchema method:
MyFieldList=ConnectionObject.OpenSchema(adSchemaColumns);
This works fine and i can pull back the information i want.
When i attempt this:
MyFieldList=ConnectionObject.OpenSchema(adSchemaPrimaryKeys);
I get an error from the server:
"Object or provider is not capable of performing requested operation"
My question is which provider do i need to use in order for me to be able
to use OpenSchema(adSchemaPrimaryKeys) ?
And what do i need to change in my connection string to achieve this?
Cheers,
Cormac
|
|
 |