SQLite Provider

[hkelly]

Hi all,

My site uses a small SQLite database. However, in spite of uploading all the appropriate dll's I get the error message "Unable to find the requested .Net Framework Data Provider. It may not be installed." when trying to run.

Any advice?

Thanks,
Heath.

[bruce]

SQLLite is not installed on our server.

I did some research, it looks like you can bin deploy the SQLLite provider to the bin directory. http://sqlite.phxsoftware.com/forums/t/1713.aspx

i have not tested though.

[hkelly]

Thanks for pointing me in the right direction Bruce. I had installed all the dlls in the bin directory but I need to reference the fully qualified assembly name in my web.config as follows:

<add name="SQLite Data Provider"
invariant="System.Data.SQLite"
description=".Net Framework Data Provider for SQLite"
type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.66.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />

Everything is now working. Thanks for your help,

Heath.

[mjp]

Glad you got it working.