I can't deploy a test app on other machine

I can't deploy a test app on other machine

Postby costashu » Wed 19 Aug 2015 07:23

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.
costashu
 
Posts: 4
Joined: Tue 18 Aug 2015 14:44

Re: I can't deploy a test app on other machine

Postby MariiaI » Wed 19 Aug 2015 12:03

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/docs/?Deployment.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
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: I can't deploy a test app on other machine

Postby costashu » Wed 19 Aug 2015 15:02

I have included sqlite3.dll in the project and problem was fixed. Thank you.
costashu
 
Posts: 4
Joined: Tue 18 Aug 2015 14:44

Re: I can't deploy a test app on other machine

Postby MariiaI » Thu 20 Aug 2015 05:19

Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17


Return to LinqConnect (LINQ to SQL support)