Correct DSN for sqlite3 odbc connection?

[abishur]

I'd like to create an odbc connection to an sqlite database I have. I'm using the docker install of FUXA and have setup sqlite3 on my linux machine. I have placed a file called my.db in the mapped appdata directory, but I'm not sure how to actually tell FUXA to use this file.

I've tried to create an ODBC connection with variations of the following line
DRIVER=SQLite3;SERVER=localhost;DATABASE=/usr/src/app/FUXA/server/_appdata/mydb.db

But when I try to see the list of tables found I get the error
TypeError: fncGetProperty is not a function

What is the correct DSN to be entering here to get it to work?

[abishur]

I worked it out! First the correct entry to put in DSN is:
driver=sqlite3;server=localhost;database=/usr/src/app/FUXA/server/_db/mydb.db
where mydb.db is the name of the sqlite database you are connecting to. Although technically I don't think server=localhost is required as I was able to delete that part and it still connected.

The thing that was getting me was that I hadn't entered anything into username or password as there is no security on an sqlite/sqlite3 database file. Once I put absolutely anything into the username and password fields it was able to read the database with no issue! 🎉

I'm not sure if the username and password fields are required by the driver being used or if it's something FUXA demands. If it's something FUXA demands than it might be worth while to have it check what driver is being used and not require a password for the sqlite/sqlite3 drivers.

Alternatively, a nice UI enhancement would be to break the existing DSN box into 3 separate entry boxes.

1 - An input for driver being used (or better yet a Drop down box listing installed drivers files based on what drivers in the odbc folder)
2 - A server field input box
3 - A database name input box

Then if sqlite or sqlite3 is selected disable or hide the username and password fields.