sqlite

[gllenx]

Is it possible to query a sqlite database from coldfusion? I set up sqliteodbc
and create an alias, but I get this error doing a simple query:

[Macromedia][SequeLink JDBC Driver][ODBC Socket]unsupported column attribute
12

[ShytKicker]

Forget about that database system. It is the worst. It is good for a private site that has no more than 3 tables. But anyway, try downloading a JDBC driver for it if it supports jdbc.

[gllenx]

Need it for a 3rd party DB... so I have no choice.

Thanks though, I've never used JDBC but it looks like there's a sqlite driver available for it.