# Accessing Sqllite with another tool **URL:** \ **Category:** Databases\ **Created:** [January 27, 2016, 2:05pm UTC](https://forum.xojo.com/t/accessing-sqllite-with-another-tool/29427 "2016-01-27T14:05:03Z")\ **Posts on this page:** 16\ **Page:** 2
**Author:** ![Paul\_Lefebvre](https://forum.xojo.com/user_avatar/forum.xojo.com/paul_lefebvre/32/3152_2.png) [@Paul\_Lefebvre](https://forum.xojo.com/u/Paul_Lefebvre)\ **Post date:** [January 27, 2016, 3:41pm UTC](https://forum.xojo.com/t/accessing-sqllite-with-another-tool/29427/21 "2016-01-27T15:41:38Z")
You DB file opened fine for me in the SQLite tools I tried. Tables and data displayed properly with data. I did try a quick download of Eclipse with BIRT, but I get an error about Java SE 6 being required even though I already have Java8 on my system. Reminds me why I stopped using Java so many years ago. 🙂 Are you able to connect any other SQLite DB to this BIRT thing? Maybe try [Chinook](https://chinookdatabase.codeplex.com/releases/view/55681). ---
**Author:** ![Kem\_Tekinay](https://forum.xojo.com/user_avatar/forum.xojo.com/kem_tekinay/32/154_2.png) [@Kem\_Tekinay](https://forum.xojo.com/u/Kem_Tekinay)\ **Post date:** [January 27, 2016, 3:51pm UTC](https://forum.xojo.com/t/accessing-sqllite-with-another-tool/29427/22 "2016-01-27T15:51:36Z")
There is a separate installer for Java 6 and they can live side-by-side. ---
**Author:** ![DaveS](https://forum.xojo.com/letter_avatar_proxy/v4/letter/d/848f3c/32.png) [@DaveS](https://forum.xojo.com/u/DaveS)\ **Post date:** [January 27, 2016, 3:51pm UTC](https://forum.xojo.com/t/accessing-sqllite-with-another-tool/29427/23 "2016-01-27T15:51:48Z")
try changing the file extension… I have been digging around, and found articles that INFER, that the file content and file extension must match for BIRT to use it … ---
**Author:** ![Brent\_Eamer](https://forum.xojo.com/letter_avatar_proxy/v4/letter/b/dc4da7/32.png) [@Brent\_Eamer](https://forum.xojo.com/u/Brent_Eamer)\ **Post date:** [January 27, 2016, 4:14pm UTC](https://forum.xojo.com/t/accessing-sqllite-with-another-tool/29427/24 "2016-01-27T16:14:05Z")
@Dave, I tried that. No go. @Thomas, got it 🙂 @Scott, yes I verified the DB is ok With SQLite Browser. ---
**Author:** ![Norman\_P](https://forum.xojo.com/letter_avatar_proxy/v4/letter/n/858c86/32.png) [@Norman\_P](https://forum.xojo.com/u/Norman_P)\ **Post date:** [January 27, 2016, 4:15pm UTC](https://forum.xojo.com/t/accessing-sqllite-with-another-tool/29427/25 "2016-01-27T16:15:06Z")
That suggests BIRT and its ability to access the DB is what is at issue here ---
**Author:** ![Brent\_Eamer](https://forum.xojo.com/letter_avatar_proxy/v4/letter/b/dc4da7/32.png) [@Brent\_Eamer](https://forum.xojo.com/u/Brent_Eamer)\ **Post date:** [January 27, 2016, 4:39pm UTC](https://forum.xojo.com/t/accessing-sqllite-with-another-tool/29427/26 "2016-01-27T16:39:26Z")
I was mulling over converting the DB over to MySQL. Can you create MySQL databases with the Desktop Version? or do I need pro. I could probably do with with OLEDB, but I would rather not ---
**Author:** ![DaveS](https://forum.xojo.com/letter_avatar_proxy/v4/letter/d/848f3c/32.png) [@DaveS](https://forum.xojo.com/u/DaveS)\ **Post date:** [January 27, 2016, 4:43pm UTC](https://forum.xojo.com/t/accessing-sqllite-with-another-tool/29427/27 "2016-01-27T16:43:58Z")
Is the continuation of this issue an XOJO one? or a database/BIRT one? If it is XOJO oriented, than why is BIRT part of the problem? If it is a BIRT one, would it not best be solved on a more forum more focused on that tool? ---
**Author:** ![Brent\_Eamer](https://forum.xojo.com/letter_avatar_proxy/v4/letter/b/dc4da7/32.png) [@Brent\_Eamer](https://forum.xojo.com/u/Brent_Eamer)\ **Post date:** [January 27, 2016, 4:49pm UTC](https://forum.xojo.com/t/accessing-sqllite-with-another-tool/29427/28 "2016-01-27T16:49:50Z")
@Dave, not sure what the answer is on that one. Basically I have a SQLite DB created within XOJO that I would like to write reports on. I don’t want to purchase a third party report program. BIRT is open source, ergo my choice of BIRT ---
**Author:** ![Kem\_Tekinay](https://forum.xojo.com/user_avatar/forum.xojo.com/kem_tekinay/32/154_2.png) [@Kem\_Tekinay](https://forum.xojo.com/u/Kem_Tekinay)\ **Post date:** [January 27, 2016, 4:57pm UTC](https://forum.xojo.com/t/accessing-sqllite-with-another-tool/29427/29 "2016-01-27T16:57:49Z")
I just tried launching Eclipse and it tells me that I need at leave JVM 1.7 installed. This despite having 1.8.x installed. Not building a lot of confidence in this product… ---
**Author:** ![DaveS](https://forum.xojo.com/letter_avatar_proxy/v4/letter/d/848f3c/32.png) [@DaveS](https://forum.xojo.com/u/DaveS)\ **Post date:** [January 27, 2016, 5:12pm UTC](https://forum.xojo.com/t/accessing-sqllite-with-another-tool/29427/30 "2016-01-27T17:12:57Z")
> [@243542:@Brent Eamer](#): > > @Dave, not sure what the answer is on that one. Basically I have a SQLite DB created within XOJO that I would like to write reports on. I don’t want to purchase a third party report program. BIRT is open source, ergo my choice of BIRT Then in my opinion, this is now a BIRT issue and not an XOJO one. SQLite is SQLite, and XOJO creates them in a 100% standard manner. I have created SQLite databases with XOJO and used them with other tools, and have created SQLite databases with other tools and used them with XOJO… Of course you have the alternative of actually writing your report using XOJO and leave BIRT out of the equation entirely, but that is of course up to you. And NO, you don’t “need” a custom “Report Generator”… just some imagnination ---
**Author:** ![Brent\_Eamer](https://forum.xojo.com/letter_avatar_proxy/v4/letter/b/dc4da7/32.png) [@Brent\_Eamer](https://forum.xojo.com/u/Brent_Eamer)\ **Post date:** [January 27, 2016, 5:20pm UTC](https://forum.xojo.com/t/accessing-sqllite-with-another-tool/29427/31 "2016-01-27T17:20:09Z")
@Dave, so what exactly are you suggesting for a report writer? ---
**Author:** ![Bob\_Keeney](https://forum.xojo.com/letter_avatar_proxy/v4/letter/b/54ee81/32.png) [@Bob\_Keeney](https://forum.xojo.com/u/Bob_Keeney)\ **Post date:** [January 27, 2016, 5:31pm UTC](https://forum.xojo.com/t/accessing-sqllite-with-another-tool/29427/32 "2016-01-27T17:31:20Z")
> [@243551:@Brent Eamer](#): > > what exactly are you suggesting for a report writer? You could look at BKeeney Shorts [http://www.bkeeney.com/allproducts/bkeeney-shorts/](http://www.bkeeney.com/allproducts/bkeeney-shorts/). Embeddable report designer. External report files (or strings if you will). And if the report designer can’t actually do your report (some reports are just too complex) you can always create the report in code (which is how it started). 100% Xojo code (except for PDF’s which require an external plugin). ---
**Author:** ![DaveS](https://forum.xojo.com/letter_avatar_proxy/v4/letter/d/848f3c/32.png) [@DaveS](https://forum.xojo.com/u/DaveS)\ **Post date:** [January 27, 2016, 5:35pm UTC](https://forum.xojo.com/t/accessing-sqllite-with-another-tool/29427/33 "2016-01-27T17:35:10Z")
> [@243551:@Brent Eamer](#): > > @Dave, so what exactly are you suggesting for a report writer? XOJO itself… .this is what programming languages are all about\\ > [@243555:@Bob Keeney](#): > > you can always create the report in code (which is how it started). 100% Xojo code (except for PDF’s which require an external plugin). also PDF requires no plugin if you are on OSX ---
**Author:** ![Brent\_Eamer](https://forum.xojo.com/letter_avatar_proxy/v4/letter/b/dc4da7/32.png) [@Brent\_Eamer](https://forum.xojo.com/u/Brent_Eamer)\ **Post date:** [January 27, 2016, 5:39pm UTC](https://forum.xojo.com/t/accessing-sqllite-with-another-tool/29427/34 "2016-01-27T17:39:30Z")
@Dave, I had an initial look at XOJO reporting but it seemed a tad lean and primitive I’ve used Crystal Reports and Oracle Reports, that is what I am used to Unless you are suggesting I get into GDI and graphics stuff? @Bob, I will check it out Thanks all for the responses ---
**Author:** ![Brent\_Eamer](https://forum.xojo.com/letter_avatar_proxy/v4/letter/b/dc4da7/32.png) [@Brent\_Eamer](https://forum.xojo.com/u/Brent_Eamer)\ **Post date:** [February 2, 2016, 12:24am UTC](https://forum.xojo.com/t/accessing-sqllite-with-another-tool/29427/35 "2016-02-02T00:24:42Z")
Follow up to this problem. I looked at my code and saw that I was creating a “REALSQLDatabase”. This app was created over six years ago. I understood that RealSqlDatabase’s were similar or based on Sqllite but not exact. So I created a quick test app using “SQLiteDatabase” , created a table, added a few rows and with the Sqlite ODBC driver BIRT is now able to see and report off the table. ---
**Author:** ![system](https://forum.xojo.com/uploads/default/original/1X/455b4dcc0e61630e9f81940004ddffa49c432a46.png) [@system](https://forum.xojo.com/u/system)\ **Post date:** [October 29, 2020, 6:09pm UTC](https://forum.xojo.com/t/accessing-sqllite-with-another-tool/29427/36 "2020-10-29T18:09:50Z")
[Previous page](https://forum.xojo.com/t/accessing-sqllite-with-another-tool/29427.md?page=1)