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.
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
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.
What is the oledb connection string for mysql?
Hi,
What is the connection string for mysql in contour form datasource?
Mydatabase name is contact,UserId is root,password is 1234,Network Name is localhost,Port- 3306
Help me to connect...
Thanks in advance,
Hari
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.
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.
Comment author was deleted
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...