Hi Hari,

Am not sure this would work with mysql. You also get your connection string from your web.config when you specified during Installation of your Umbraco Instance where your db will be.

Something like if am not wrong.

<add key="umbracoDbDSN" value="server=dev2;database=umbraco_iorim;user id=sql_eservices;password=slash!0" />

Hi Fuji, 

Thanks for ur reply. I want to connect it through the olebb connection string in the umbraco contour datasource. what i have to do for it? It is asking the provider name.

Hari am not sure what Provider name mysql needs to make the connection with your db. By default when you create a Prevalue Source and Choose SQl Database, it will automatically give you your Provider like this

Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword;

and you only have to change the Value of the Server, Database, Uid, Pwd according to your web.config and specify your Table Name, Key Column, Value Column as per your db.

Hi,

Think you'll first need a MySQL OLE DB Provider and based on that provider you can then specify the connection string

http://cherrycitysoftware.com/ccs/providers/ProvMySQL.aspx

Fuji and Tim thanks for ur suggestions  

is working on a reply...