#8 ODBC-Connect fails for MS Access

[Anonymous]

The ODBC connect for MSAccess =

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=filename of Access file

fails with Message (retranslated):

System.InvalidCastException: Cannot convert object of type System.DBNull into type System.String.
At QueryExPlus.ODBCBrowser.AppendSchemas(DataTable dt, String schemaName, String schemaType, String SchemaColumnName, String NameColumnName)

By contrast the OLEDB.Net connect on same MSAccess db works fine with

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=filename of Access file;Persist Security Info=False

(Query ExPlus v2.0.2.8)

Lars
imnuxy-lf@yahoo.de