mysql - Difference between Provider value in OLEDB conncetion string MSDASQL and MSDASQL.1 -
i trying connect sql , mysql database through oledb. in case of mysql, connection string like:
provider=msdasql.1;persist security info=false;data source=mysql;initial catalog=information_schema;
or like:
provider=msdasql;persist security info=false;data source=mysql;initial catalog=information_schema;
the same suits sql connection string also.
the provider information in connection string differs provider=msdasql.1 , provider=msdasql
.
i don't know why provider value differs. why differ? there reason behind this?
and connection through microsoft ole db drivers odbc drivers
.
Comments
Post a Comment