error connecting using ByteFX ADO.NET data provider to a MySQL 5.0.0a database

[Dominique Plante]

I was wondering if someone has had the error
"ByteFX.Data.MySqlClient.MySqlException: Bad handshake" when trying to talk
to a MySQL 5.0.0a database when using ByteFX's ADO.NET data provider.

I used pretty much the same code to connect to a table in an Access Database
with no problem.

The code and the error page I get are shown below.

Any help would be greatly appreciated.
 
Thanks,
Dominique
 
<%@ Page Language="C#" Debug="true" %>
<%@ import Namespace="ByteFX.Data.MySqlClient" %>

 
    public void Page_Load()
    {
    String mySqlConnectionString
="DataSource=localhost;Database=test;Username=dplante;Password=secret;Persis
t Security Info=true";
    MySqlConnection dbconn = new MySqlConnection(mySqlConnectionString);
    dbconn.Open();
    String sql="SELECT * FROM update_track";
    MySqlCommand dbcomm=new MySqlCommand(sql,dbconn);
    MySqlDataReader dbread = dbcomm.ExecuteReader();
    update_track.DataSource = dbread;
    update_track.DataBind();
    dbread.Close();
    dbconn.Close();
    }
 





    
    
    
    
    
    update_id
    description
    os
    bugTraqID
    
    
    
    
   
<%#DataBinder.Eval(Container.DataItem,"update_id")%>
   
<%#DataBinder.Eval(Container.DataItem,"description")%>
    <%#DataBinder.Eval(Container.DataItem,"os")%>
   
<%#DataBinder.Eval(Container.DataItem,"bugTraqID")%>
    
    
    
    
    
    
    


 
ERROR PAGE I GET:
 
Server Error in '/' Application. 

Bad handshake 
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code. 

Exception Details: ByteFX.Data.MySqlClient.MySqlException: Bad handshake

Source Error: 
 
Line 7:  String mySqlConnectionString
="DataSource=localhost;Database=test;Username=dplante;Password=secret;Persis
t Security Info=true";
Line 8:  MySqlConnection dbconn = new
MySqlConnection(mySqlConnectionString);
Line 9:  dbconn.Open();
Line 10: String sql="SELECT * FROM update_track";
Line 11: MySqlCommand dbcomm=new MySqlCommand(sql,dbconn);

Source File: C:\dev\sandbox\ASP.NETSandbox\wmSandbox\nwMySQLCS.aspx    Line:
9 

Stack Trace: 
 
[MySqlException: Bad handshake]
   ByteFX.Data.MySqlClient.Driver.ReadPacket() +167
   ByteFX.Data.MySqlClient.Driver.AuthenticateSecurely(Packet packet, String
password) +46
   ByteFX.Data.MySqlClient.Driver.Authenticate(String userid, String
password, Boolean UseCompression) +210
   ByteFX.Data.MySqlClient.Driver.Open(MySqlConnectionString settings) +393
   ByteFX.Data.MySqlClient.MySqlInternalConnection.Open() +45
   ByteFX.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() +168
   ByteFX.Data.MySqlClient.MySqlPool.GetPooledConnection() +454
   ByteFX.Data.MySqlClient.MySqlPool.GetConnection() +56
  
ByteFX.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString
settings) +208
   ByteFX.Data.MySqlClient.MySqlConnection.Open() +69
   ASP.nwMySQLCS_aspx.Page_Load() in
C:\dev\sandbox\ASP.NETSandbox\wmSandbox\nwMySQLCS.aspx:9
   System.Web.Util.ArglessEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e) +10
   System.Web.UI.Control.OnLoad(EventArgs e) +55
   System.Web.UI.Control.LoadRecursive() +27
   System.Web.UI.Page.ProcessRequestMain() +731
 

Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573


-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Dominique Plante - dplante AT pacbell dot net
Agile Developer for Hire - San Francisco Bay Area
http://www.binaryshift.com
-Founder of the Bay Area Software Developers Tribe -http://basd.tribe.net-



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

how to create a table with column name 'key'?

[Dominique Plante]

I hope you can answer the following question.  I am
wondering how to create a table with a column named
key.  I have RTFMed and that didn't help.  I'm using
3.23.47-max-debug.


The following fails (after selecting a database):

mysql> create table test (key varchar(255), value
varchar(255));

With the following error:
ERROR 1064: You have an error in your SQL syntax near
'varchar(255), value varch
ar(255))' at line 1

Any suggestions?

Many thanks,
Dominique

__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php