ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tony Elmore" <telm...@insightbb.com>
Subject RE: MySql Connection problem
Date Thu, 19 Oct 2006 04:40:34 GMT
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:rongrabowski@yahoo.com] 
Sent: Monday, October 16, 2006 11:16 PM
To: user-cs@ibatis.apache.org
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 <telmore@insightbb.com>

To: user-cs@ibatis.apache.org

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

     

     

   

   








Mime
View raw message