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();