locked
Create add connection in vs2005 server explorer to the MySql data base using the MySql connector 5.0.9.0 RRS feed

  • Question

  • User1153004090 posted

    Hi Folks,

    I am using the MySql connector 5.0.9.0, I tried to  add the connection in the vs2005 server explorer to the MySql data base. But i could not able to find the MySQL Oledb provider in the providers list. To my understanding MySQL connector 5.0.9.0 does not provide the OLEDB provider. DO i need to install MySQL OLEDB provider again? I am thinking that if i install aging the MySQL connector another version it conflicts the MySQL 5.0.9.0 .Because Already My application using the MySql.data.dll from the (MySql 5.0.9.0 ) location C:\Program Files (x86)\MySQL\MySQL Connector Net 5.0.9\Binaries\.NET 2.0.

    Could you please suggest on this , how can i overcome this issue.

    Many thanks,

    Chandra

     

     

    Thursday, September 13, 2012 10:51 AM

All replies

  • User1630798415 posted

    do you have MySQL Database (MySQL Data Provider)?

    Friday, September 14, 2012 7:17 AM
  • User1153004090 posted

    Hi Santosh,

    I have installed the MySQL Connector Net 6.1.6 under the C:\Program Files (x86)\MySQL\MySQL Connector Net 6.1.6, now i do not have problems , i could able to add the connection through the server explorer uisng the MySql Data provider.

    But the thing is i am uisng the windows 7 64 bit PC , it is a bit tricky on the Windows 7 64 bit. When i tried to install MySQL Connector Net 6.1.6  , it is automatically choose the path C:\Program Files\MySQL , i have changed this path to C:\Program Files (x86)\MySQL\

    Now no issues.

    Thank you,

    Chandra

     

    Friday, September 14, 2012 7:28 AM
  • User1153004090 posted

    Hi Friends,

    I could able to create the connection in server explorer window (Add connection), but when i treid to create the crystal report from the "Standard report creation wizard", could not able to make connection to the MySQL data base (Because there is no MySQL connector in the standard report creation wizard). Could you please help me in this issue, How can i create crystal report from the standard report creation wizard?

    Many thanks,
    Chandra

     

     

    Monday, September 17, 2012 10:11 AM
  • User1630798415 posted

    please refer this, which explains MySQL connector in the standard report creation wizard

    http://docs.oracle.com/cd/E17952_01/refman-5.1-en/connector-net-programming-crystal.html

    Tuesday, October 2, 2012 6:20 AM