ADOX MSDASQL Access Properties Collection is EMPTY
Due to alphabet ordering of "Columns" in a "Table" while reading MS Access "Catalog" using Jet I am using ODBC MS Access driver and OLEDB for ODBC provider:
CString sConn = _T("Provider=MSDASQL.1;Persist Security Info=False;Data Source=MS Access Database;Extended Properties=\"DSN=MS Access Database;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;DBQ=");
sConn += lpsJobPath;
sConn += _T(";\"");
All work fine, but Properties collection for Columns is empty. So I do not know "Default" values and "Seed" values.
While using Jet there is no such problem.
I am going to read Catalog with Jet first (temporary storing needed properties) then second time with ODBC...
But may be there is a better solution???