Attached are the results for the Microsoft.Jet.OLEDB.4.0 Provider. The ODBC driver
http:[EMAIL PROTECTED]/msg00525.html and DBD::ADO return quite different results (for various reasons): ODBC DBD::ADO -------------------- ----------------- ------------------------- SQL_CATALOG_TERM DATABASE Database SQL_DATA_SOURCE_NAME mytest DBD-ADO-2.4.02\mytest.mdb SQL_DBMS_NAME ACCESS MS Jet SQL_DRIVER_NAME odbcjt32.dll DBD/ADO.pm SQL_DRIVER_VER 04.00.6019 02.04.0000 SQL_IDENTIFIER_CASE 3 4 SQL_KEYWORDS ALPHANUMERIC, ... AdminDB, ... SQL_OWNER_TERM Schema SQL_PROCEDURE_TERM QUERY STORED QUERY SQL_QUALIFIER_TERM DATABASE Database SQL_SCHEMA_TERM Schema SQL_TABLE_TERM TABLE Table SQL_USER_NAME admin Admin Most remarkable: SQL_IDENTIFIER_CASE. AFAIK, Access identifiers are not case-sensitive. Steffen
SQL_CATALOG_LOCATION 1 SQL_CATALOG_TERM Database SQL_CONCAT_NULL_BEHAVIOR 1 SQL_DATA_SOURCE_NAME DBD-ADO-2.4.02\mytest.mdb SQL_DBMS_NAME MS Jet SQL_DBMS_VER 04.00.0000 SQL_DBMS_VERSION 04.00.0000 SQL_DRIVER_NAME DBD/ADO.pm SQL_DRIVER_VER 02.04.0000 SQL_IDENTIFIER_CASE 4 SQL_IDENTIFIER_QUOTE_CHAR ` SQL_KEYWORDS AdminDB,Alphanumeric,Autoincrement,BAND,Binary,BNOT,BOR,BXOR,Byte,Comp,Compression,Container,Counter,CreateDB,Currency,Database,DateTime,Disallow,ExclusiveConnect,Float4,Float8,General,Guid,IEEEDouble,IEEESingle,Ignore,Image,Index,Inheritable,Integer1,Integer2,Integer4,Logical,Logical1,Long,LongBinary,LongChar,LongText,Memo,Money,Note,Number,Object,OLEObject,OwnerAccess,Pad,Parameters,Password,Percent,Pivot,Proc,SelectSchema,SelectSecurity,Short,Single,Space,String,Tableid,Text,Top,Transform,Uniqueidentifier,UpdateIdentity,UpdateOwner,UpdateSecurity,Varbinary,YesNo SQL_OWNER_TERM Schema SQL_PROCEDURE_TERM STORED QUERY SQL_QUALIFIER_LOCATION 1 SQL_QUALIFIER_TERM Database SQL_SCHEMA_TERM Schema SQL_TABLE_TERM Table SQL_USER_NAME Admin
