You are not logged in.
- Topics: Active | Unanswered
Pages: 1
#1 Re: mORMot 1 » Newbie connecting to an .accdb Database » 2020-07-14 07:33:50
I had success with connecting and creating an accdb Database!
The problem was the "Initial Catalog=ace.1" part of the connection string, which the GitHub\mormot\SQLite3\Samples\15 - External DB performance project added automatically.
I started an own test project with the call
Props := TOleDBACEConnectionProperties.Create( '....\TestDb.accdb', '', '', '' );
and got the working connection string:
'Provider=Microsoft.ACE.OLEDB.12.0;Data Source=....\TestDb.accdb;User Id=;Password=;'
The fDBMS: TSQLDBDefinition property of Props: TOleDBACEConnectionProperties is still dJet. Is this correct?
Also I noticed that there is no call TOleDBACEConnectionProperties.RegisterClassNameForDefinition; in the initialization section of the SynOleDB unit.
Everything worked though.
Thx for your support and greetings.
#2 Re: mORMot 1 » Newbie connecting to an .accdb Database » 2020-07-13 08:13:53
Im sorry for posting code. I tried to delete all the irrelevant part.
Not posting the exception message was kind of stupid of me though.
This is the exception message, if the database not exists (translated from german):
Exception at $756DC5AF. Error in an OLE DB process consisting of several steps. Check the individual OLE DB status values, if available. Data was not processed.
If the database exists, I get the message
Exception class EOleSysError with message 'OLE error 80040E21'
If I can do any more tests let me know.
Thx and greetings.
#3 Re: mORMot 1 » Newbie connecting to an .accdb Database » 2020-07-09 17:25:43
Thx for providing the new connection class!
I tried it, but unfortunately without success:
Im still changing the mormot\SQLite3\Samples\15 - External DB performance project for my tests.
Im calling the new with class with
Test(TOleDBACEConnectionProperties,'...\TestDb.accdb','','','','',true);
If my TestDb doesnt exists, I got an exception at
function TOleDBConnectionProperties.CreateDatabase: boolean;
var Catalog: _Catalog;
DB: OleVariant;
begin
.
.
.
DB := Catalog.Create(ConnectionString); // <- exception here
.
.
.
end;
If my TestDb exists, I got an exception at
function TOleDBConnectionProperties.GetSchema(const aUID: TGUID;
const Fields: array of RawUTF8; var aResult: IRowset): boolean;
var i, res, n: integer;
C: TOleDBConnection;
SRS: IDBSchemaRowset;
PG, OG: PGUID;
PI, OI: PInteger;
Args: array of Variant;
begin
.
.
.
C.fSession.QueryInterface(IDBSchemaRowset,SRS); // exception here
.
.
.
end;
My connection string is:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=...\TestDb.accdb;Initial Catalog=ace.1;User Id=;Password=;
Let me know, how I can give you more detailed information about the problem.
#4 Re: mORMot 1 » Newbie connecting to an .accdb Database » 2020-07-07 11:13:06
Thx for your fast response!
Yes, I did some tests with TOleDBJetConnectionProperties without luck.
I experimented in the GitHub\mormot\SQLite3\Samples\15 - External DB performance project and tried to alter the test to connect with my .accdb database:
Test( TOleDBJetConnectionProperties,'....\TestDb.accdb','','','','',true);
#5 mORMot 1 » Newbie connecting to an .accdb Database » 2020-07-07 10:06:40
- chopseo
- Replies: 9
Hello,
Im just getting started with the mORMot framework and need to connect to an .accdb database.
Any sample code or link would be great.
I did some connection attempts with the TOleDBJetConnectionProperties class without success.
Usually I connect with the Microsoft.ACE.OLEDB.12.0 provider to this kind of database.
I did a search and found nothing here on the forum.
Im on Windows 7 with Delphi 2006.
Thx and greeting
chopseo
Pages: 1