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

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

javascript - Add class to another page attribute using URL id - Jquery -

firefox - Where is 'webgl.osmesalib' parameter? -