Connection to MySQL throws an exception

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

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

0	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

Latest Posts