Thanks Ron... I got it working by fixing a couple of things I had wrong...
Sql Server liked the host name of '(localhost)' but MySql wanted 'localhost' Also, port id needed to be specified as port=xxxx instead of localhost:xxxx TE -----Original Message----- From: Ron Grabowski [mailto:[EMAIL PROTECTED] Sent: Monday, October 16, 2006 11:16 PM To: [email protected] Subject: Re: MySql Connection problem Have you verified the connetion string works on a normal MySqlConnection (or whatever MySql's IDbConnection is)? using (IDbConnection connection = new MySqlConnection("...")) { Console.Write(connection.ConnectionState); } ----- Original Message ---- From: Tony Elmore <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, October 16, 2006 12:22:16 PM Subject: MySql Connection problem <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal { margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman"; } a:link, span.MsoHyperlink {color:blue; text-decoration:underline; } a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline; } p.MsoPlainText, li.MsoPlainText, div.MsoPlainText {margin:0in; margin-bottom:.0001pt; font-size:10.0pt; font-family:"Courier New"; } span.Style1 { color:fuchsia; font-weight:bold; font-style:italic; text-decoration:underline; } span.EmailStyle19 { color:black;} _filtered { margin:1.0in 1.25in 1.0in 1.25in; } div.Section1 {} --> p.MsoNormal {margin-left:18.75pt;} Hello. I've been working with SQL Server and I've been able to execute just fine. I am now wanting to connect to a MySql DB. So I installed the MySql Connector 1.0.7 and enabled the provider in the provider.config and changed the specified provider in the SqlMap.config file (as well as my connection string values in properties.config). However, when I attempt to perform a select statement, I receive the following error: 'Unable to connect to any of the specified MySql hosts. No such host is known'. The only oddity in the installation is that I've used a different port than the default. I've tried localhost:port and port=xxxx in the connection string. Any assistance would be appreciated. Regards, Tony
