c# - Problem with Rhino-Etl and MySQL -
I have been using Rhino-ETL for a while and it is running very smooth although I have a mysql db There is a problem connecting.
Rhino.etl.ro.Rinotlix: Hornalen.Migration failed to execute operation. Processing ReadMessagesFromDb: Type name 'MySql.Data.MySqlClient' could not be found for connection string: testConnectionString --- & gt; System.InvalidOperationE xception: The type name 'MySql.Data.MySqlClient' could not be found on the string for connectivity: testConnectionString at Rhino.Etl.Core.Infrastructure.Use.Connect (string name) in rhino.et.l.core.example. NAFACUIT in Rhino.Atl.Core & gt; DD 0. MeVixt () Rhino.ETL.Core.Airam. Cores. SingerViventRevisioning Animator.mainext () Rhino.Etl.Core.Enumerables.EventRaisingEnumerator.MoveNext () in Rhino.et.l.core.pipeline. ThreadPullPlineIn the XQ & Lt; & Gt; C__DisplayClass1. & Lt; De corateEnumerableForExecution & gt; B__0 (object) --- The end of the internal exception stack trace ---
mysql.data is referenced and located in my bin folder
My connection string I Looks like .config
& lt; Add name = "testConnectionString" connectionString = "server = localhost; user id = dev; password = xxxxx; security information = true; database = test" provider name = "MySql.Data.MySqlClient" />
The connection string works fine in a simple website, to debug purposes, as the data source. I am running asp.net 3.5, win 7 and VS 2008, and I would appreciate any help on this issue.
A simple test is also working in the ETL project
MySql.Data.MySqlClient.MySqlConnection connection = New MySqlConnection (Configuration Manager. Connection Strings ["testConnectionString"] ConnectionString); Connection.Open (); MySqCommand command = connection.CreateCommand (); Command. Common Text = "Choose from Art"; MySqlDataReader Reader = command.ExecuteReader (); While (reader.Read ()) {System.Console.WriteLine (reader.GetInt32 ("artId")); } Connection.Close (); After doing some work with Type.GetType ("xxx"), it has started working with
& lt; Add name = "testConnectionString" connectionString = "server = localhost; user id = dev; password = xxxxx; continue the security information; true = database = test" provider name = "MySql.Data.MySqlClient.MySqlConnection, MySql.Data, version = 6.1.2.0, Culture = Neutral, Public Koken = c5687fc88969c44d "/ & gt;
Comments
Post a Comment