New error when opening SSCE (Compact) databases
Posted: Mon 13 Jul 2015 23:03
Hello Devart!
We just updated to SDAC 7.1.5 (previously we had 7.1.3). Now we're seeing a new error when attempting to connect to SSCE (Compact Edition) databases. This error prevents any database access, so it's rather critical for us.
The error message:
The variables in caps above are constants we've defined so we can tweak these values easily at any point.
We just updated to SDAC 7.1.5 (previously we had 7.1.3). Now we're seeing a new error when attempting to connect to SSCE (Compact Edition) databases. This error prevents any database access, so it's rather critical for us.
The error message:
Here's the C++ code we've used over the years (with very few changes) to connect:There was an error parsing the query. [Token line number: 1, Token line offset, 5, 0,Token in error:TRANSACTION,,]
Code: Select all
MSCompactConnection* connectionSSCE = new TMSCompactConnection(NULL);
connectionSSCE->ConnectString = "";
connectionSSCE->Database = dbFileName;
connectionSSCE->IsolationLevel = Msaccess::ilIsolated;
connectionSSCE->LoginPrompt = false;
connectionSSCE->LockTimeout = SSCE_LOCK_TIMEOUT;
connectionSSCE->TransactionCommitMode = cmSynchCommit;
connectionSSCE->InitMode = (options.Lock) ? imExclusive : imReadWrite;
connectionSSCE->Username = SSCE_USER_NAME;
connectionSSCE->Password = dbPass;
TMSCompactConnectionOptions* cco = connectionSSCE->Options;
cco->Encrypt = true;
cco->CompactVersion = cv40;
cco->DefaultLockTimeout = SSCE_LOCK_TIMEOUT;
cco->MaxBufferSize = SSCE_MAX_BUFFER_SIZE;
cco->MaxDatabaseSize = SSCE_MAX_DB_SIZE;
cco->TempFileDirectory = gHypSettings->TempPath;
mConnection = connectionSSCE;
mConnection->Connect();