We have created a web service (.NET 4.0) that uses dotConnect for Salesforce to read data from Salesforce to pass back to our ASP.NET applications. We've gotten to work ok on our local machines, but when migrating the web service to our test server, we're getting an error:
"Unable to load DLL 'sqlite3': The specified module could not be found. (Exception from HRESULT: 0x8007007E)"
This seems to indicate that we're missing some DLL's for the web service to work. What DLL's are needed for Sqlite to function? These DLL's do not appear in my BIN folder on my development machine.
Note that running an installation routine, as the documentation indicates that we should do (running as "minimal") is not an option. Our server administrators require that all 3rd party DLL's be located in the BIN folder of the web service. This makes the web service more portable when and if it needs to be relocated to another server.
Required DLL's
Re: Required DLL's
The "minimal" install is not necessary.
The list of the DDLs which are required by all dotConnect for Salesforce applications: Devart.Data.dll, Devart.Data.Salesforce.dll, sqlite3.dll.
The Entity Framework projects also need: Devart.Data.Salesforce.Entity.dll and Devart.Data.Salesforce.Entity.Migrations.dll.
The SSIS packages use Devart.SSIS.Salesforce.dll.
For more information, please refer to http://www.devart.com/dotconnect/salesf ... yment.html.
The list of the DDLs which are required by all dotConnect for Salesforce applications: Devart.Data.dll, Devart.Data.Salesforce.dll, sqlite3.dll.
The Entity Framework projects also need: Devart.Data.Salesforce.Entity.dll and Devart.Data.Salesforce.Entity.Migrations.dll.
The SSIS packages use Devart.SSIS.Salesforce.dll.
For more information, please refer to http://www.devart.com/dotconnect/salesf ... yment.html.