Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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 



  Return to Index