v16.1 QEA(X) repositories and ODBC access?

[Paolo F Cantoni]

It looks like we have to "bite the bullet" and move our snapshot reporisitories to SQLite (qea & qeax format).  Our snapshots appear to be exceeding the 2GB limit for eapx files and are producing "random" errors on project transfers.

As with user heba (in January this year) we need ODBC access to allow our additional background processing to be automated.

Investgation shows that Christian Werner's SQLite3 ODBC driver is the preferred solution.  Is anybody successfully accessing SQLite repositories via ODBC?  What Driver are you using?  How successful is it.  Do you ave any daatype mapping issues?

TIA,
Paolo

[qwerty]

Depends probably on the language you are using. I'm using the sqlite3 package with Python.

q.

[DeBAAT]

Hai.
I'm using the same SQLite3 driver with no problems whatsoever.
It took me some time to figure out why I couldn't connect in the first place and eventually came across that driver.
Works fine now.
Also works for access by Power BI for creating nice reports.

[Paolo F Cantoni]

Hai.
I'm using the same SQLite3 driver with no problems whatsoever.
It took me some time to figure out why I couldn't connect in the first place and eventually came across that driver.
Works fine now.
Also works for access by Power BI for creating nice reports.

Hi DeBAAT,

Any gotcha' with the driver installation or usage?

Paolo

[DeBAAT]

Any gotcha' with the driver installation or usage?

Not particularly. I just installed it and it worked.
If believe I could even use the same sql queries to access the data in the database as I used for MySQL. But this are really simple queries  .