I can't deploy a test app on other machine

[costashu]

Exception is raised:

Code: Select all

Необработанное исключение: Devart.Data.Linq.LinqCommandExecutionException: Error on opening DbConnection. ---> Devart.Data.SQLite.SQLiteException: Unable to open database file ---> System.DllNotFoundException: Не удается
 загрузить DLL "sqlite3": Не найден указанный модуль. (Исключение из HRESULT: 0x8007007E)
   в Devart.Data.SQLite.ah.sqlite3_open_v2(Byte[] A_0, IntPtr& A_1, Int32 A_2, String A_3)
   в Devart.Data.SQLite.q.a(String A_0, EncryptionMode A_1, String A_2, Boolean A_3)
   в Devart.Data.SQLite.ad.n()
   --- Конец трассировки внутреннего стека исключений ---
   в Devart.Data.SQLite.ad.n()
   в Devart.Data.SQLite.s.a(DbConnectionOptions A_0, Object A_1, DbConnectionBase A_2)
   в Devart.Common.f.a(DbConnectionPool A_0, DbConnectionOptions A_1, DbConnectionBase A_2)
   в Devart.Common.DbConnectionPool.a(DbConnectionBase A_0)
   в Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection)
   в Devart.Common.f.c(DbConnectionBase A_0)
   в Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
   в Devart.Common.DbConnectionBase.Open()
   в Devart.Data.SQLite.SQLiteConnection.Open()
   в Devart.Data.Linq.DataContext.OpenConnection(IDbConnection connection)
   в Devart.Data.Linq.DataProvider.OpenConnection(IDbConnection connection)
   в Devart.Data.Linq.Engine.cm.g()
   --- Конец трассировки внутреннего стека исключений ---
   в Devart.Data.Linq.LinqCommandExecutionException.CanThrowLinqCommandExecutionException(String message, Exception e)
   в Devart.Data.Linq.Engine.cm.g()
   в Devart.Data.Linq.Engine.cm.b(IConnectionUser A_0)
   в Devart.Data.Linq.DataProvider.a(c1 A_0, Object[] A_1)
   в Devart.Data.Linq.DataProvider.c(Expression A_0)
   в Devart.Data.Linq.Engine.DataQuery`1.System.Linq.IQueryProvider.Execute[S](Expression expression)
   в System.Linq.Queryable.First[TSource](IQueryable`1 source)
   в SDL.EditAutosuggest.Class1..ctor()
   в ConsoleApplication1.Program.Main(String[] args)

Database file is existed.

[MariiaI]

To deploy applications written with the help of LinqConnect you should register run-time assemblies (e.g., for SQLite) Devart.Data.SQLite.dll, Devart.Data.dll, Devart.Data.SQLite.Linq.dll and Devart.Data.Linq.dll at Global Assembly Cache (GAC) or place them to the bin folder of your application.
For more information please refer to http://www.devart.com/dotconnect/sqlite ... yment.html

Please make sure that:
- your application have access to the engine library sqlite3.dll; you should put it either to the application folder or to a system-wide accessible folder;
- all the necessary assemblies are available for your application;
- you are using a correct connection string; it may differ from the one, which is used on the development computer.

The sqlite3.dll is included in the dotConnect for SQLite/LinqConnect installation and there are 2 versions available in these folders:
- C:\Program Files (x86)\Devart\dotConnect\SQLite
- C:\Program Files (x86)\Devart\dotConnect\SQLite\x64

[costashu]

I have included sqlite3.dll in the project and problem was fixed. Thank you.

[MariiaI]

Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.