Hi, I need to acces a sqlite3 db file but I have no clue how...

[Guest]

Did you try ODBC

TIBCO WebFOCUS Adapter Administration Release 8207

[Toby Mills]

I would think you could get to it with JDBC.

Sometimes for JDBC connections, it helps to take WebFOCUS out of the equation and use another tool. Heres a free one that Ive used for JDBC connectivity testing before:

SQLite database tool - DbVisualizer

Drivers for SQLite - DbVisualizer

Looks like the sqllite adapter is already installed if you download db visualizer:

 

image.png905328 37.9 KB

 

If you can communicate with that, I bet you can set up your adapter in WebFOCUS.

[Mathijs .]

Thank you both for your suggestions.

I had tried ODBC but I selected the wrong one! Selecting sqlite3 driver solved my issue and now WebFocus can read my file.

[Mathijs .]

Hi,

I need to acces a sqlite3 db file but I have no clue how to do this with WebFocus.

I did not manage to find a suitable adapter in the reporting server console, I have tried the JDBC generic adapter with no success.

If anyone is familiar with this type of file it would be great!