PDA

View Full Version : Getting error on SQLite ODBC connection



Richard Hogg
4-Oct-2018, 12:30 AM
Hi,
Back having a play with DAI after a long absence and testing connectability to a few different DB's. One I'm having trouble with is SQLite.
- Created a single table test DB,
- Made an ODBC 32 bit DSN (test here was ok),
- Gave the IUSR account read access to the db file (the file is on my local drive),
- Created a connection in DAI but it says it can't find it.
I've attached some screenshots.

Any ideas?
Cheers
Richard

Bob Cergol
5-Oct-2018, 08:45 AM
Hi Richard,

The error is pretty explicit. The DSN is not visible to the Dynamic AI instance for whatever reason....


You did install the SQL Lite ODBC driver and DSN on the server that is hosting Dynamic AI, yes?
Rights? Try changing the credential on the website in IIS from passive to specific user with Admin privileges. If that works then you can work backwards to see what rights are missing on the IUSR and/or DYNPOOL accounts.


Regards,
Bob