Unable to open the database file

[rguenette]

Hi,

Same problem as in this post: http://forums.devart.com/viewtopic.php?f=38&t=30421
When deployed, the DotConnect sends an exception when trying to connect to Salesforce.

A. The exception:
Devart.Data.SQLite.y: Unable to open the database file
at Devart.Data.Salesforce.i.a(HeaderOptions A_0)
at Devart.Data.Salesforce.an.a(i A_0, Object A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, i A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionPool.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection)
at Devart.Common.DbConnectionFactory.b(DbConnectionBase A_0)
at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at Devart.Common.DbConnectionBase.Open()
at Devart.Data.Salesforce.SalesforceConnection.Open()
at API.RefreshModel()

B. My web.config:
- Connection string: <add name="SFEntitiesConnectionString" connectionString="Data Cache=D:\\Web_Site\\goe.onixedit.com\\sf.db;Metadata Cache=D:\\Web_Site\\goe.onixedit.com\\sf_metadata.db;metadata=~/App_Code/SFModel.csdl|~/App_Code/SFModel.ssdl|~/App_Code/SFModel.msl;provider=Devart.Data.Salesforce;provider connection string="User Id=XXX;Password=XXX;Security Token=XXX;Persist Security Info=True;System Objects=True;Host=login.salesforce.com"" providerName="System.Data.EntityClient"/>
- I also added this code block:
<system.data>
<DbProviderFactories>
<remove invariant="Devart.Data.Salesforce"/>
<add name="dotConnect for Salesforce" invariant="Devart.Data.Salesforce" description="Devart dotConnect for Salesforce" type="Devart.Data.Salesforce.SalesforceProviderFactory, Devart.Data.Salesforce, Version=2.3.221.0, Culture=neutral, PublicKeyToken=09af7300eec23701"/>
</DbProviderFactories>
</system.data>

C. My website runs in a FullTrust environnement and I granted the FullControl right to everyone to the website directory.

D. My Files
- Root: licenses.licx
- Bin: App_Licenses.dll, Devart.Data.dll, Devart.Data.Salesforce.dll, Devart.Data.Salesforce.Entity.dll, sqlite3.dll
- App_Code: SFModel.csdl, SFModel.edml, SFModel.edps, SFModel.msl, SFModel.ssdl

Any ideas what I am missing?

[rguenette]

I created a new website in IIS and I don't know what I did differently this time but now it works ...