Connection to MySQL throws an exception

Posted by Nismeh under Sql Server on 10/1/2013 | Points: 10 | Views : 869 | Status : [Member] | Replies : 3
Hi,

I am connecting my window service to MySql. I am using ConnectionString = "Provider=SQLOLEDB;Server=192.168.1.147;Uid=root;Pwd=netweb12;Database=TDWC;"; But getting an error saying An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.

Can any one suggest?

IT KNOWLEDGE IS APPLIED KNOWLEDGE
So Just Do It



Responses

Posted by: Bandi on: 10/1/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Refer this
http://social.msdn.microsoft.com/Forums/vstudio/en-US/32071725-3122-4913-87b8-9d29bb3acbec/c-mysql-example-commandexecutereader-throws-exception

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Nismeh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 10/1/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
MySQL connection Strings
http://www.hosting.com/support/mysql/connectionstrings/
http://www.connectionstrings.com/mysql/

Access Mysql database from Windows Service.
http://forums.codeguru.com/showthread.php?518405-Access-Mysql-database-from-Windows-Service

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Nismeh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 10/1/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Are you connecting to MySQL or SQL server?

http://stackoverflow.com/questions/556014/provider-needed-to-be-specify-on-a-connectionstring
http://forums.asp.net/t/1347536.aspx

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Nismeh, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response