Bug #12425 mysql oledb provider for MySQL server
Submitted: 8 Aug 2005 4:06 Modified: 11 Aug 2005 14:05
Reporter: leo Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:mysql-5.0.9-beta-win32 OS:Windows (windows advanced 2000)
Assigned to: CPU Architecture:Any

[8 Aug 2005 4:06] leo 
Description:
I use mysql oledb provider to connect the database(mysql-5.0.9-beta-win32).Here,i use mysql-oledb-3.0.0 for connection,when i am testing connection,it display that" the connention failed beacause of an error in initializing the provider".My parameters are "Provider=MySqlProv;Data Source=oledb;Integrated Security="";Password=1111;User ID=root;Location=127.0.0.1;Extended Properties=""".My systerm is windows advanced 2000.Waiting for help! my e-mail is vsleo@163.com.looking forward your letter.

How to repeat:
first,i install the MySQL database(mysql-5.0.9-beta-win32).For most of sets,i use the default values. i set the password for 1111.
second,i install the mysql-administrator-1.0.21-win.msi and mysql-query-browser-1.1.10-win.msi.
third,i install MyOLEDB3.exe(mysql-oledb-3.0.0 ).
forth,i creat  a mode named oledb through mysql query browser tool.
finally,i make a program through vb6.0.i make a module for creating a table, the main codes is:
    Dim cn As ADODB.Connection
    Dim connstr As String
    Set cn = New ADODB.Connection
    connstr = "Password=1111;User ID=root;Data Source=127.0.0.1;Location=oledb"
    cn.Provider = "MySqlProv"
    cn.ConnectionString = connstr
    cn.Open
    SQL = "create table TT(col1 int,col2 char(20))"
    Set rs = New ADODB.Recordset
    Set rs.ActiveConnection = cn
    rs.Open SQL, cn, adOpenKeyset, adLockOptimistic
then when i run the program it comes out a dialog ,when i click the ok button,it would display what i just say.
    Note: the port is 3306,i don't chang it.
[9 Aug 2005 8:35] Vasily Kishkin 
Could you please say me version of myodbc ?
[10 Aug 2005 3:41] leo 
i use the microsoft ado data control 6.0(oledb),
 
this days,i analyzed the mysql-oledb-3.0.0's source code(mysql ole db provider). After compiling it,i  debugg it ,when i trace it to a function named"net_safe_read(MYSQL *mysql)".it occurs this error:
   “Client does not support authentication protocol requested by server;consider upgrading MySQL client”

 error number:1251
[10 Aug 2005 3:47] leo 
i didn't install myodbc,i think using the mysql ole db provider to connecting the database does need installing the myodbc.
am i right?
this days,i analyzed the mysql-oledb-3.0.0's source code(mysql ole db provider). After compiling it,i  debugg it ,when i trace it to a function named"net_safe_read(MYSQL *mysql)".it occurs this error:
   “Client does not support authentication protocol requested by server;consider upgrading MySQL client”

 error number:1251
[11 Aug 2005 12:10] leo 
is the the mysql-oledb-3.0.0 not compatile with the mysql-5.0.9-beta-win32 server ?
[11 Aug 2005 14:05] Jim Winstead 
We don't make an OLE DB provider. You'll need to contact the makers of the provider you are trying to use, or switch to using our .NET or ODBC connectors. There is an article that explains how to use these connectors at http://dev.mysql.com/tech-resources/articles/dotnet/
[15 Aug 2005 6:20] leo 
thanks
[27 Feb 2007 4:20] Sean Deng 
Have you tried the MySQL OLE DB Provider at http://CherryCitySoftware.com?
[4 Sep 2007 5:07] Jorge Perez 
Try this one:

cConnString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;PORT=3306;DATABASE=YourDatabase;OPTION=19035;UID=YourUid;PWD=YourPassword"

Works for me !!
[4 Sep 2007 5:12] Jorge Perez 
Note: In this case cn.Provider MUST be "MSDASQL"

cn.Provider = "MSDASQL"