If you've got the "Cannnot load file or assembly 'xxx, Version=yyy, ...' or one of its dependencies" error on assigning your DB connection to Connection property of appropriate Metadata Provider, chances are this error happens because this metadata provider was compiled with a different version of DB connection assembly. Using the trial version of Active Query Builder, you can setup binding redirection on your PC as follows. Having the full version you can recompile the metadata provider assembly with your version of DB connection assembly. (Even if you did not purchase the full source code, the source codes of metadata providers assemblies are included.)

To use any other version of your db client assembly you need to override the version binding using the following 'app.config' file (add it into your project). Below is the sample of binding redirection for VistaDB.NET20 assembly.

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="VistaDB.NET20"
          publicKeyToken="dfc935afe2125461"
          culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="y.y.y.zz" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
</configuration>
Don't forget to change the 'newVersion' attribute to the required version of your db client assembly.
More information can be found here.

This article was helpful for 1 person. Is this article helpful for you?