ZapTools Update

[sub]

Interesting....are you running zapimport from within the GBPVR directory?
Is there a system.data.sqlite.dll file in the directory? What is the date on the file and version(right-click and select properties and then version tab).

You can probably only rely on that DbProviderFactories.GetFactory method if the user has added SQLite to the machine.config file, or if there is a specific zaptools.config that explicitly defines SQLite as an additional DBProvider. Having the SQLite DLL in the same directory is not enough to make it seen as a DBProviderFactory. GB-PVR doesnt use this method, so doesnt have this same problem.

[UncleJohnsBand]

You can probably only rely on that DbProviderFactories.GetFactory method if the user has added SQLite to the machine.config file, or if there is a specific zaptools.config that explicitly defines SQLite as an additional DBProvider. Having the SQLite DLL in the same directory is not enough to make it seen as a DBProviderFactory. GB-PVR doesnt use this method, so doesnt have this same problem.

Thanks sub.....I have the following loaded on my machine.

xHerbiex and ydekmekji try loading the ADO.Net 2.0 provider.

[xHerbiex]

downloaded and installed ADO v1.0.29 but still getting same error. system.data.sqlite.dll is version 1.0.27.1 dated 28 feb @ 10am

I noticed the gui for the ado doesn't show any supported environments. Is this correct? .net 2.0 framework is installed.

[bmountney]

I found that I was able to solve this error by adding the follwing lines to the zapimport.exe.config file:

<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>

I also had to add those lines to the Web.config file for the WebAdmin because I was getting a similar error when I attempted to use that with the zapdb.db3 database file present.

I took those configuration lines from the test.exe.config that was included with the "ADO.NET 2.0 Provider" package.

[UncleJohnsBand]

I got some code from sub that should resolve this issue so that you don't need to load anything or modify the config.....I'll post shortly.....

[UncleJohnsBand]

Give this version a try......it seems to resolve the issue.

[xHerbiex]

zapimport seems to work with the new version. Thank you .

Now when I go to the web admin I'm getting a similar error:

Server Error in '/gbpvr' Application.
Unable to find the requested .Net Framework Data Provider. It may not be installed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.

Source Error:

Line 76: if (File.Exists(Path.Combine(Global.Settings.GetInstallDir(), "zapdb.db3")))
Line 77: {
Line 78: DbProviderFactory zapFactory = DbProviderFactories.GetFactory("System.Data.SQLite");
Line 79: zapConnection = zapFactory.CreateConnection();
Line 80: zapConnection.ConnectionString = "Data Source=" + databaseFileName + ";Version=3;New=True";


Source File: c:\Program Files\devnz\gbpvr\web\App_Code\classes\ZapTools.cs Line: 78

Stack Trace:

[ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.]
System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName) +102
gbweb.ZapTools.OpenZapDB() in c:\Program Files\devnz\gbpvr\web\App_Code\classes\ZapTools.cs:78
gbweb.classes.ProgrammeDisplay..ctor() in c:\Program Files\devnz\gbpvr\web\App_Code\classes\ProgrammeDisplay.cs:19
gbweb.guide.Page_PreRender(Object sender, EventArgs e) in c:\Program Files\devnz\gbpvr\web\Guide.aspx.cs:108
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +13
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +45
System.Web.UI.Control.OnPreRender(EventArgs e) +80
System.Web.UI.Control.PreRenderRecursiveInternal() +88
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5731


Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

[UncleJohnsBand]

zapimport seems to work with the new version. Thank you .

Now when I go to the web admin I'm getting a similar error:

Server Error in '/gbpvr' Application.
Unable to find the requested .Net Framework Data Provider. It may not be installed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.

Source Error:

Line 76: if (File.Exists(Path.Combine(Global.Settings.GetInstallDir(), "zapdb.db3")))
Line 77: {
Line 78: DbProviderFactory zapFactory = DbProviderFactories.GetFactory("System.Data.SQLite");
Line 79: zapConnection = zapFactory.CreateConnection();
Line 80: zapConnection.ConnectionString = "Data Source=" + databaseFileName + ";Version=3;New=True";


Source File: c:\Program Files\devnz\gbpvr\web\App_Code\classes\ZapTools.cs Line: 78

Stack Trace:

[ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.]
System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName) +102
gbweb.ZapTools.OpenZapDB() in c:\Program Files\devnz\gbpvr\web\App_Code\classes\ZapTools.cs:78
gbweb.classes.ProgrammeDisplay..ctor() in c:\Program Files\devnz\gbpvr\web\App_Code\classes\ProgrammeDisplay.cs:19
gbweb.guide.Page_PreRender(Object sender, EventArgs e) in c:\Program Files\devnz\gbpvr\web\Guide.aspx.cs:108
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +13
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +45
System.Web.UI.Control.OnPreRender(EventArgs e) +80
System.Web.UI.Control.PreRenderRecursiveInternal() +88
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5731


Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Yep...that fix is coming tonight as well....visit the EWA thread for the release.

[xHerbiex]

OK. Thanks for your efforts.

[ww4397]

zapimport seems to work with the new version. Thank you .

Now when I go to the web admin I'm getting a similar error:

Server Error in '/gbpvr' Application.
Unable to find the requested .Net Framework Data Provider. It may not be installed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.

Source Error:

Line 76: if (File.Exists(Path.Combine(Global.Settings.GetInstallDir(), "zapdb.db3")))
Line 77: {
Line 78: DbProviderFactory zapFactory = DbProviderFactories.GetFactory("System.Data.SQLite");
Line 79: zapConnection = zapFactory.CreateConnection();
Line 80: zapConnection.ConnectionString = "Data Source=" + databaseFileName + ";Version=3;New=True";


Source File: c:\Program Files\devnz\gbpvr\web\App_Code\classes\ZapTools.cs Line: 78

...

I'm getting this error also.