Is it possible to use wxDatabase with .accdb files via ODBC? Or another connection type?
I found a couple connection strings which include references to the .mdb format, but I'm not familiar enough with databases to know if I should expect this connection string to work or not. I've tried this:
Code: Select all
db = new wxOdbcDatabase();
db->Open(_T("Driver={Microsoft Access Driver (*.mdb)};Dbq=") + databaseLocation + _T(";Uid=Admin;Pwd=;"));
From briefly looking through the source, it looks like ODBC connections could possibly require DbType and DSN parameters - is this correct? If so, how can I determine the correct values?
Thanks,
Kerry