Icon View Incident Report

Serious Serious
Reported By: Greg Dalhoff
Reported On: 7/16/2008
For: Version 2.01 Build 1
# 2707 .NET Data Provider Installation Incorrectly Registers Compact Framework Assembly

I have managed to sucessfully set up a database running off a remote server, and can access my data using the manager, however I cannot seem to get the ElevateDB driver to connect using the .net data provider, when using VS2005.
This is on Windows XP SP2, using ElevateDB server v2.01 (Build 1) trial version.

I add a new connection from within the solution explorer using a new Database.

I then choose 'New Connection' and change my Data source to 'ElevateDB Database', which is available in the list.

Once I click OK the only option I have is to enter a connection string in the MISC -> ConnectionString field.
I enter for example

Clicking on "Test connection" returns "The connection succeded." but when I click OK I get the following error

"Failed to find or load the registered .Net Framework Data Provider"

Comments Comments and Workarounds
The issue was that the runtime assembly binding in the machine.config file was incorrectly pointing to the EDB Compact Framework assembly in the \edbproviderwm subdirectory (Windows Mobile) instead of the \edbprovider subdirectory (desktop).

The workaround is to change the second assembly binding in the machine.config to this instead:

<assemblyIdentity name="Elevate.ElevateDB.Data" publicKeyToken="cf9bc1202c75e9e2"/>
<codeBase version="" href="file:///C:\Program Files\ElevateDB DAC Trial\Version 2\assemblies\edbprovider\Elevate.ElevateDB.Data.dll"/>

Resolution Resolution
Fixed Problem on 7/17/2008 in version 2.01 build 2

Products Affected Products Affected
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial