SQLite dbExpress driver from bcp-software with D2007 Win32?

[Jan Doggen]

Hello,
Has anyone gotten the SQLite dbExpress driver from www.bcp-software.nl
gotten to work in D2007 Win32?
This is what I did:
1) I added to dbxdrivers.ini:
[Installed Drivers]
SQLite=1

[SQLite]
LibraryName=DbxSQLite3.dll
GetDriverFunc=getSQLDriverSQLite3
VendorLib=sqlite3.dll
RoleName=Cache=2000|TextLength=1024
2) I added to dbxconnections.ini:
[SQLiteConnection]
DriverName=SQLite
Database=Test.db
(just a guess; I have no idea what else to add. What about all these
DriverUnit...DriverAssembly entries I see with other databases?)

3) I placed DbxSQLite3.dll in c:\Program Files\Codegear\RAD Studio\5.0\bin
(note that the install.txt talks about sqlite.dll and getSQLDriverSQLite,
but I got an error "Missing driverfunc: getSQLDriverSQLite" and peeked with
an editor in DbxSQLite3.dll to discover that it was getSQLDriverSQLite3).
4) sqlite3.dll is in Windows\System32 and registered.

5) I drop a TSQLConnection on the form, set LoginPrompt to false, if I try
to set active to true I get an access violation

Any ideas?
Thanks in advance
Jan Doggen

========================================================================================
http://www.jandoggen.org http://www.beautyofpeople.com
http://www.puddingclub.nl

[Bob Swart]

Hi Jan,

Post by Jan Doggen
Has anyone gotten the SQLite dbExpress driver from www.bcp-software.nl
gotten to work in D2007 Win32?

Is this a dbExpress 3.0 or DBX4 driver? If it's a dbExpress 3.0 driver,
you may have to add a reference to the DBXDynalink to perform the
adaption between the dbExpress 3.0 driver and the DBX4 framework.

Post by Jan Doggen
[Installed Drivers]
SQLite=1
[SQLite]
LibraryName=DbxSQLite3.dll
GetDriverFunc=getSQLDriverSQLite3
VendorLib=sqlite3.dll
RoleName=Cache=2000|TextLength=1024

I would add to dbxdrivers.ini the following (if it's a dbExpress 3.0
driver, which I assume it is):

[SQLite]
DriverUnit=DBXDynalink
DriverPackageLoader=TDBXDynalinkDriverLoader,DbxDynalinkDriver100.bpl
DriverAssemblyLoader=Borland.Data.TDBXDynalinkDriverLoader,Borland.Data.DbxDynalinkDriver,Version=11.0.5000.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b
MetaDataPackageLoader=TDBXSybaseASAMetaDataCommandFactory,DbxReadOnlyMetaData100.bpl
MetaDataAssemblyLoader=Borland.Data.TDBXSybaseASAMetaDataCommandFactory,Borland.Data.DbxReadOnlyMetaData,Version=11.0.5000.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b
GetDriverFunc=getSQLDriverSQLite3
LibraryName=DbxSQLite3.dll
VendorLib=sqlite3.dll
RoleName=Cache=2000|TextLength=1024

Post by Jan Doggen
(just a guess; I have no idea what else to add. What about all these
DriverUnit...DriverAssembly entries I see with other databases?)

That's because these are still dbExpress 3.0 drivers, that have to use
the DBXDynalink package as adapter to be used with the DBX4 framework.

You need to go to a third-party vendor like CoreLab to get real DBX4
drivers that can be linked into your executable and don't need the
DBXDynalink package for example (as described in my Delphi VCL Database
Development book).

Post by Jan Doggen
5) I drop a TSQLConnection on the form, set LoginPrompt to false, if I try
to set active to true I get an access violation

If this still doesn't work, then I would ask the makers of this driver
if they have a true DBX4 version.

Post by Jan Doggen
Any ideas?
Thanks in advance
Jan Doggen

Groetjes,
Bob Swart

[Jan Doggen]

Thanks this works.
I also left a message in the Aducom forum describing what to do.
Jan

Post by Bob Swart
Hi Jan,

Post by Jan Doggen
Has anyone gotten the SQLite dbExpress driver from www.bcp-software.nl
gotten to work in D2007 Win32?

Is this a dbExpress 3.0 or DBX4 driver? If it's a dbExpress 3.0 driver,
you may have to add a reference to the DBXDynalink to perform the adaption
between the dbExpress 3.0 driver and the DBX4 framework.

Post by Jan Doggen
[Installed Drivers]
SQLite=1
[SQLite]
LibraryName=DbxSQLite3.dll
GetDriverFunc=getSQLDriverSQLite3
VendorLib=sqlite3.dll
RoleName=Cache=2000|TextLength=1024

I would add to dbxdrivers.ini the following (if it's a dbExpress 3.0
[SQLite]
DriverUnit=DBXDynalink
DriverPackageLoader=TDBXDynalinkDriverLoader,DbxDynalinkDriver100.bpl
DriverAssemblyLoader=Borland.Data.TDBXDynalinkDriverLoader,Borland.Data.DbxDynalinkDriver,Version=11.0.5000.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b
MetaDataPackageLoader=TDBXSybaseASAMetaDataCommandFactory,DbxReadOnlyMetaData100.bpl
MetaDataAssemblyLoader=Borland.Data.TDBXSybaseASAMetaDataCommandFactory,Borland.Data.DbxReadOnlyMetaData,Version=11.0.5000.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b
GetDriverFunc=getSQLDriverSQLite3
LibraryName=DbxSQLite3.dll
VendorLib=sqlite3.dll
RoleName=Cache=2000|TextLength=1024

Post by Jan Doggen
(just a guess; I have no idea what else to add. What about all these
DriverUnit...DriverAssembly entries I see with other databases?)

That's because these are still dbExpress 3.0 drivers, that have to use the
DBXDynalink package as adapter to be used with the DBX4 framework.
You need to go to a third-party vendor like CoreLab to get real DBX4
drivers that can be linked into your executable and don't need the
DBXDynalink package for example (as described in my Delphi VCL Database
Development book).

Post by Jan Doggen
5) I drop a TSQLConnection on the form, set LoginPrompt to false, if I
try to set active to true I get an access violation

If this still doesn't work, then I would ask the makers of this driver if
they have a true DBX4 version.

Post by Jan Doggen
Any ideas?
Thanks in advance
Jan Doggen

Groetjes,
Bob Swart
--
Bob Swart Training & Consultancy (eBob42.com) Forever Loyal to Delphi
CodeGear Technology Partner -- CodeGear RAD Studio Reseller (BeNeLux)
Delphi Win32 & .NET books on Lulu.com: http://stores.lulu.com/drbob42
Blog: http://www.drbob42.com/blog - RSS: http://eBob42.com/weblog.xml

[Bob Swart]

Hi Jan,

Post by Jan Doggen
Thanks this works.

I'm glad it did; it sure sounded like the dbExpress 3.0 adapter was
missing...

Post by Jan Doggen
I also left a message in the Aducom forum describing what to do.

I don't know where/what the Adocum forum is, but I'm glad it's solved now.

Post by Jan Doggen
Jan

Groetjes,
Bob Swart

[albert drent]

Post by Bob Swart
Hi Jan,

Post by Jan Doggen
Thanks this works.

I'm glad it did; it sure sounded like the dbExpress 3.0 adapter was
missing...

Post by Jan Doggen
I also left a message in the Aducom forum describing what to do.

I don't know where/what the Adocum forum is, but I'm glad it's solved now.

Post by Jan Doggen
Jan

Groetjes,
Bob Swart

Hi Bob,

Aducom has it's own (open-source) SQLite components and it's forum is on
www.aducom.com. We also do some maintenance on the Zeos implementation
of SQLite which was contributed.

We are not involved with the components on bcp-software in any way. We
have found the message on our forum, but don't know what to do with it.

We have a DBX4 port for SQLite in development, but it's not going very
fast due to several reasons.

Albert Drent
aducom software
groningen - netherlands

[Jan Doggen]

Oops sorry
looks like I mixed some things up ;-)
I was investigating 4 ways to access SQLite at the same time ;-)
Jan

Post by albert drent

Post by Bob Swart
Hi Jan,

Post by Jan Doggen
Thanks this works.

I'm glad it did; it sure sounded like the dbExpress 3.0 adapter was
missing...

Post by Jan Doggen
I also left a message in the Aducom forum describing what to do.

I don't know where/what the Adocum forum is, but I'm glad it's solved now.

Post by Jan Doggen
Jan

Groetjes,
Bob Swart

Hi Bob,
Aducom has it's own (open-source) SQLite components and it's forum is on
www.aducom.com. We also do some maintenance on the Zeos implementation of
SQLite which was contributed.
We are not involved with the components on bcp-software in any way. We
have found the message on our forum, but don't know what to do with it.
We have a DBX4 port for SQLite in development, but it's not going very
fast due to several reasons.
Albert Drent
aducom software
groningen - netherlands

[albert drent]

Post by Jan Doggen
Oops sorry
looks like I mixed some things up ;-)
I was investigating 4 ways to access SQLite at the same time ;-)
Jan

Post by albert drent

Post by Bob Swart
Hi Jan,

Post by Jan Doggen
Thanks this works.

I'm glad it did; it sure sounded like the dbExpress 3.0 adapter was
missing...

Post by Jan Doggen
I also left a message in the Aducom forum describing what to do.

I don't know where/what the Adocum forum is, but I'm glad it's solved now.

Post by Jan Doggen
Jan

Groetjes,
Bob Swart

Hi Bob,
Aducom has it's own (open-source) SQLite components and it's forum is on
www.aducom.com. We also do some maintenance on the Zeos implementation of
SQLite which was contributed.
We are not involved with the components on bcp-software in any way. We
have found the message on our forum, but don't know what to do with it.
We have a DBX4 port for SQLite in development, but it's not going very
fast due to several reasons.
Albert Drent
aducom software
groningen - netherlands

I thought so, but no worries. There are a lot of roads to Rome.