On my development system (which is English) the testlinq application (from the source of SQLite) works perfectly. Also the application I developed works just fine. When installing testlinq on a test machine (Windows XP SP2, DOTNET 3.5 SP1, DUTCH!!) it fails (DBFactory problem). I have tried to install the SQLite distribution without any improvement. I also tried to modify the testlinq.config to (according the manual):
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<system.data>
<DbProviderFactories>
<remove invariant="System.Data.SQLite"/>
<add name="SQLite Data Provider" invariant="System.Data.SQLite"
description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
</DbProviderFactories>
</system.data>
<connectionStrings>
<add name="northwindEntities" connectionString="metadata=res://*/NorthwindModel.csdl|res://*/NorthwindModel.ssdl|res://*/NorthwindModel.msl;provider=System.Data.SQLite;provider connection string="data source=c:\src\sqlite.net\testlinq\northwind.db"" providerName="System.Data.EntityClient" />
<add name="northwindEntities1" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SQLite;provider connection string="data source=c:\src\sqlite.net\testlinq\northwind.db"" providerName="System.Data.EntityClient" />
<add name="northwindEFEntities" connectionString="metadata=res://*/NorthwindModel.csdl|res://*/NorthwindModel.ssdl|res://*/NorthwindModel.msl;provider=System.Data.SQLite;provider connection string="data source=D:\SQLite\northwindEF.db"" providerName="System.Data.EntityClient" />
</connectionStrings>
</configuration>
I am sure that the path of the data source is good (I have on my dev. system the same tree and this is working)
Also won't work. The failure I get is always the same.
D:\SQLite>testlinq.exe
Onverwerkte uitzondering: System.Data.ProviderIncompatibleException: A null was
returned after calling the 'GetService' method on a store provider instance of t
ype 'System.Data.SQLite.SQLiteFactory'. The store provider might not be function
ing correctly.
bij System.Data.Common.DbProviderServices.GetProviderServices(DbProviderFacto
ry factory)
bij System.Data.Metadata.Edm.StoreItemCollection.Loader.InitializeProviderMan
ifest(Action`3 addError)
bij System.Data.Metadata.Edm.StoreItemCollection.Loader.OnProviderManifestTok
enNotification(String token, Action`3 addError)
bij System.Data.EntityModel.SchemaObjectModel.Schema.HandleProviderManifestTo
kenAttribute(XmlReader reader)
bij System.Data.EntityModel.SchemaObjectModel.Schema.HandleAttribute(XmlReade
r reader)
bij System.Data.EntityModel.SchemaObjectModel.SchemaElement.ParseAttribute(Xm
lReader reader)
bij System.Data.EntityModel.SchemaObjectModel.SchemaElement.Parse(XmlReader r
eader)
bij System.Data.EntityModel.SchemaObjectModel.Schema.HandleTopLevelSchemaElem
ent(XmlReader reader)
bij System.Data.EntityModel.SchemaObjectModel.Schema.InternalParse(XmlReader
sourceReader, String sourceLocation)
bij System.Data.EntityModel.SchemaObjectModel.Schema.Parse(XmlReader sourceRe
ader, String sourceLocation)
bij System.Data.EntityModel.SchemaObjectModel.SchemaManager.ParseAndValidate(
IEnumerable`1 xmlReaders, IEnumerable`1 sourceFilePaths, SchemaDataModelOption d
ataModel, AttributeValueNotification providerNotification, AttributeValueNotific
ation providerManifestTokenNotification, ProviderManifestNeeded providerManifest
Needed, IList`1& schemaCollection)
bij System.Data.Metadata.Edm.StoreItemCollection.Loader.LoadItems(IEnumerable
`1 xmlReaders, IEnumerable`1 sourceFilePaths)
bij System.Data.Metadata.Edm.StoreItemCollection.Init(IEnumerable`1 xmlReader
s, IEnumerable`1 filePaths, Boolean throwOnError, DbProviderManifest& providerMa
nifest, DbProviderFactory& providerFactory, Memoizer`2& cachedCTypeFunction)
bij System.Data.Metadata.Edm.StoreItemCollection..ctor(IEnumerable`1 xmlReade
rs, IEnumerable`1 filePaths)
bij System.Data.Metadata.Edm.MetadataCache.StoreMetadataEntry.LoadStoreCollec
tion(EdmItemCollection edmItemCollection, MetadataArtifactLoader loader)
bij System.Data.Metadata.Edm.MetadataCache.StoreItemCollectionLoader.LoadItem
Collection(StoreMetadataEntry entry)
bij System.Data.Metadata.Edm.MetadataCache.LoadItemCollection[T](IItemCollect
ionLoader`1 itemCollectionLoader, T entry)
bij System.Data.Metadata.Edm.MetadataCache.GetOrCreateStoreAndMappingItemColl
ections(String cacheKey, MetadataArtifactLoader loader, EdmItemCollection edmIte
mCollection, Object& entryToken)
bij System.Data.EntityClient.EntityConnection.LoadStoreItemCollections(Metada
taWorkspace workspace, DbConnection storeConnection, DbProviderFactory factory,
DbConnectionOptions connectionOptions, EdmItemCollection edmItemCollection, Meta
dataArtifactLoader artifactLoader)
bij System.Data.EntityClient.EntityConnection.GetMetadataWorkspace(Boolean in
itializeAllCollections)
bij System.Data.EntityClient.EntityConnection.InitializeMetadata(DbConnection
newConnection, DbConnection originalConnection, Boolean closeOriginalConnection
OnFailure)
bij System.Data.EntityClient.EntityConnection.Open()
bij System.Data.Objects.ObjectContext.EnsureConnection()
bij System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
bij System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<
T>.GetEnumerator()
bij testlinq.Program.Main(String[ args) in D:\SQLiteSrc\testlinq\Program.cs:
regel 19
(You might see some dutch text in it. But always the result is problem with the DBFactory.
When I start my own application, same result:
System.ArgumentException: The specified store provider cannot be found in the configuration, or is not valid. ---> System.ArgumentException: Kan de aangevraagde .Net Framework-gegevensprovider niet vinden. Mogelijk is deze niet geïnstalleerd.
bij System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)
bij System.Data.EntityClient.EntityConnection.GetFactory(String providerString)
--- Einde van intern uitzonderingsstackpad ---
bij System.Data.EntityClient.EntityConnection.GetFactory(String providerString)
bij System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString)
bij System.Data.EntityClient.EntityConnection..ctor(String connectionString)
bij System.Data.Objects.ObjectContext.CreateEntityConnection(String connectionString)
bij System.Data.Objects.ObjectContext..ctor(String connectionString, String defaultContainerName)
bij POIDBModel.POIDBEntities..ctor()
bij PHOffline.POIAdministrator_Load(Object sender, EventArgs e)
bij System.EventHandler.Invoke(Object sender, EventArgs e)
bij System.Windows.Forms.Form.OnLoad(EventArgs e)
bij System.Windows.Forms.Form.OnCreateControl()
bij System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
bij System.Windows.Forms.Control.CreateControl()
bij System.Windows.Forms.Control.WmShowWindow(Message& m)
bij System.Windows.Forms.Control.WndProc(Message& m)
bij System.Windows.Forms.ScrollableControl.WndProc(Message& m)
bij System.Windows.Forms.ContainerControl.WndProc(Message& m)
bij System.Windows.Forms.Form.WmShowWindow(Message& m)
bij System.Windows.Forms.Form.WndProc(Message& m)
bij DevExpress.XtraEditors.XtraForm.WndProc(Message& msg)
bij System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
bij System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
bij System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
I am desperate. I am not sure what to change and I would like to distrubute my application. I do not think this has to do with a language.??
Can some one help me to fix this!?
If you need more information please let me know.
Marcel