Accessing Sqllite with another tool

Databases
21

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. :slight_smile:

Are you able to connect any other SQLite DB to this BIRT thing? Maybe try Chinook.

22

There is a separate installer for Java 6 and they can live side-by-side.

23

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 ā€¦

24

@Dave, I tried that. No go.
@Thomas, got it :slight_smile:
@Scott, yes I verified the DB is ok With SQLite Browser.

25

That suggests BIRT and its ability to access the DB is what is at issue here

26

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

27

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?

28

@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

29

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ā€¦

30

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

31

@Dave, so what exactly are you suggesting for a report writer?

32

You could look at 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).

33

XOJO itselfā€¦ .this is what programming languages are all about\\

also PDF requires no plugin if you are on OSX

34

@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

35

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.