Qt how to open SQL Compact Server file .sdf

[ketest]

I am trying to open a SQL Compact Server file .sdf with Qt. I have the following code:

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setDatabaseName("C:\\testresults.sdf");
bool Success = db.open();
 
sprintf(writeToMonitorBuffer, "dblastError = %s", (const char *)db.lastError().text().toLatin1());
writeToMonitor(writeToMonitorBuffer);
 
sprintf(writeToMonitorBuffer, "db.open(): Success/Fail = %s", Success ? "Pass" : "Fail");
writeToMonitor(writeToMonitorBuffer);

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setDatabaseName("C:\\testresults.sdf");
bool Success = db.open();

sprintf(writeToMonitorBuffer, "dblastError = %s", (const char *)db.lastError().text().toLatin1());
writeToMonitor(writeToMonitorBuffer);

sprintf(writeToMonitorBuffer, "db.open(): Success/Fail = %s", Success ? "Pass" : "Fail");
writeToMonitor(writeToMonitorBuffer);

To copy to clipboard, switch view to plain text mode 

I am getting the error message:

dblastError = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified QODBC3: Unable to connect

dblastError = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified QODBC3: Unable to connect

To copy to clipboard, switch view to plain text mode 

And I get:

db.open(): Success/Fail = Fail

db.open(): Success/Fail = Fail

To copy to clipboard, switch view to plain text mode 

In the past I have connected to MS Access database by using

db.setDatabaseName("Driver={Microsoft Access Driver (*.mdb, *.accdb)};DSN='';DBQ=C:\\temp\\TestEng_TestDatabase.accdb");

db.setDatabaseName("Driver={Microsoft Access Driver (*.mdb, *.accdb)};DSN='';DBQ=C:\\temp\\TestEng_TestDatabase.accdb");

To copy to clipboard, switch view to plain text mode 

Not sure what I should be putting for
"Driver={???}

[ChrisW67]

There is no out-of-the-box ODBC driver for Sql Server Compact Ed AFAICT. Your options are limited to .Net or OLEDB interfaces.

[ketest]

So what does that mean? Qt cannot open a SQL compact server file?
How would I implement the .Net or OLEDB interface in Qt?

[ChrisW67]

There is no ODBC support for Sql Server Compact Ed and therefore the standard Qt ODBC Sql database driver cannot access it.

Your C++ program can access Sql Server Compact Ed databases using the Microsoft OLE DB API directly.
You may also be able to access the data through ActiveQt.
You could, of course, write a Qt SQL driver specifically for Sql Server Compact Ed.