I am evaluating MySQLDirect .NET version 2.80.7.0, and i am trying to get it working in VS2005 Beta 2.
We want to use Jet, Sql and Mysql and want to use the DbProviderFactories from .Net 2.0.
I got a mail from your support desk wich advised me to change machine.config and add the following line in
Code: Select all
I have the following relevant code
Code: Select all
Private Const conProviderNameSpaceSQL As String = "System.Data.SqlClient"
Private Const conProviderNameSpaceJET As String = "System.Data.OleDb"
Private Const conProviderNameSpaceMySQL As String = "CoreLab.MySql"
Private varDbDataFactory As DbProviderFactory
Private varDbConnection As DbConnection
Select Case parServerReferentie.prpDbTypeGet
Case intDbcServerReferentie.enmDbType.encDbJet
varDbDataFactory = DbProviderFactories.GetFactory(conProviderNameSpaceJET)
Case intDbcServerReferentie.enmDbType.encDbMySql
varDbDataFactory = DbProviderFactories.GetFactory(conProviderNameSpaceMySQL)
Case intDbcServerReferentie.enmDbType.encDbSql
varDbDataFactory = DbProviderFactories.GetFactory(conProviderNameSpaceSQL)
End Select
System.InvalidOperationException: The requested .Net Framework Data Provider's implementation does not have an Instance field of a System.Data.Common.DbProviderFactory derived type..
CoreLab.MySql.MySqlDirectFactory inherits from CoreLab.Common and not System.Data.Common!
This is the Stack Trace from the error:
Code: Select all
at System.Data.Common.DbProviderFactories.GetFactory(DataRow providerRow)
at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)
at SnelStart.nspData.clsDbcConnection..ctor(intDbcServerReferentie parServerReferentie, intDbcDatabaseReferentie parDatabaseReferentie)
at tpnDbConnection.testDbConnection.TestConnectieMySqlOpen()
Regards.