Hi most helpful people!
I am in the process of changing my DB engine from Sql 2005 to MySql after learning that sql 2005 will not support network drive references. I have downloaded and installed mysql-5.5.21 and the mysql-connector-net-6.5.4. I have also added the mysql.data.client reference from the .net2 assembly. In other words, my "Imports MySql.Data.MySqlClient" namespace is valid. But when I go into add new data source I am presented with an Oracle database choice but not with a mysql choice. Additionally I am not sure what Server name they are asking for - mysql.exe. This is my first ever venture into mysql so by definition migrating from SQL 2005 to MySql under VS 2005. Any insights would be greatly appreciated.
Respectfully,
Gordon Haas
I am in the process of changing my DB engine from Sql 2005 to MySql after learning that sql 2005 will not support network drive references. I have downloaded and installed mysql-5.5.21 and the mysql-connector-net-6.5.4. I have also added the mysql.data.client reference from the .net2 assembly. In other words, my "Imports MySql.Data.MySqlClient" namespace is valid. But when I go into add new data source I am presented with an Oracle database choice but not with a mysql choice. Additionally I am not sure what Server name they are asking for - mysql.exe. This is my first ever venture into mysql so by definition migrating from SQL 2005 to MySql under VS 2005. Any insights would be greatly appreciated.
Respectfully,
Gordon Haas