Using a parameter with ODBC SQLite Connection

[spuff55]

Hi All

I have an issue with an ODBC connection to an SQLite database that previously worked perfectly with a parameter, but now it doesn't.

Since it last worked, I have moved the location of the SQLite DB, and updated the parameter to the new file location.

I am getting this error message.

And this is how the data source looks.

When I change the connection string to use the file path and not the parameter.. i.e. "Database = C:\SQLiteDB", it works perfectly.

But with "Param = SQLite" it does not.

Strange how the "param = " worked before but now it doesn't.

Anyone know whats going on here?

Matt

[Anonymous]

Hi @spuff55 ,

Here is a similar thread, please kindly refer to:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[spuff55]

HI

Thank you. I have the drivers installed and I know they are working, as when I do not use a parameter and link directly to the Sqlite file in my "Source" part of the query it works perfectly fine.

It is with using a parameter in the source that I am having a problem.

Regards

Matt