On 1/4/07, Kurt Cleeren <[EMAIL PROTECTED]> wrote:
Hi,
I'm using Coldfusion MX 6 and I'm trying to connect to an sqlite3
database.
Does anyone know what's the best way to do this?
Kurt, from my CF days (they are only a fond memory now, thank
goodness), only way to connect to a db via CF is either through ODBC,
or JDBC, or, if you have CF Enterprise, then native db drivers.
The retail edition of SQLite doesn't have "drivers." SQLite itself is
everything... it is the server, the client, the driver, the language,
etc. I use Perl, and DBD::Perl can be thought of as the SQLite driver
for Perl... it is actually SQLite embedded in a Perl module. Actually,
the retail edition of SQLite does come with bindings for Tcl (maybe
other languages as well), but what you really need is a language
agnostic driver.
Now, if you Google hard enough, you will find a SQLite ODBC driver,
but last I looked, it was flaky, and was, understandably, Windows
only. So, I had little interest in it. Since CFMX allows creating
custom CF functions via C/C++, you might, if you have the skills, want
to tinker with creating a CF object with entire SQLite embedded in it.
That would likely be very good performance-wise, and great service to
the rest of the CF community (whatever exists).
Hope this helps a little.
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
---------------------------------------------------------------------
collaborate, communicate, compete
=====================================================================
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
