SQLite ODBC problem!

[dbarbul]

Does anybody know how to connect to SQLite database with ODBC interface?____I receive error message: No table names were found for this Data Source.____I am using RR version 10.1.1003.

[kfleming]

Can you create a User SQL report where you write the SELECT statement without an error?____Kathleen__R&R Support

[dbarbul]

I can not even connect to that data source!____Same ODBC data source, without any problem, I use with Clarion 6.____I use ODBC diver from http://www.ch-werner.de/sqliteodbc web site.

[dbarbul]

I also try to connect to that SQLite ODBC data source with OpenOffice.org 2.1 and I have no problem.____Dusan

[dbarbul]

This is my correspondence with author of SQLite ODBC driver:____> Dule Barbul wrote:__> __> When I try to create report with Report Writer for Windows SQL Edition__> version 10 I recevie error message like: "No table names were found for this__> Data Source".__> __> I ask for help on R&R User Discussion Forum but there was no answer.__> __> This ODBC data source was created with SQLite3 ODBC driver 0.71.00.00. I try__> to change parameters or driver versions but I have no luck.__> __> Same data source I use, without any problem, with OpenOffice.org 2.1 or__> Clarion for Windows 6.1.____Dusan,____from your description I think it is a similar problem as can be observed__with M$ Excel. SQLite does not have catalogs/schemas thus the initial__SQLTables() of the application can fail and the application then thinks__there aren^t any tables. In Excel the workaround is to toggle the display__options for tables, system tables, views. I^m afraid I have no solution__for it. What about asking the manufacturer of Report Writer for Windows__SQL Edition if they know a workaround.____Regards,__Christian______:( :(

[dbarbul]

>Can you create a User SQL report where you write the SELECT __>statement without an error? __>__>Kathleen __>R&R Support ____When I create a User SQL report and try to run report I receive error message:____"DB access: not supported"______Dusan B.