[Mono-list] Problem with MySQL Data Provider (ByteFx)

[beniniva@csr.unibo.it]

Hi,

I've just installed Mono Beta 3...but I've still problems:

##############
[root@or2 mono]# mcs provaByteFX.cs -r System.Data.dll -r ByteFX.Data.dll
Compilation succeeded
[root@or2 mono]# mono provaByteFX.exe
                                                                                
                                            
Unhandled Exception: ByteFX.Data.MySqlClient.MySqlException: Host
'localhost.localdomain' is not allowed to connect to this MySQL server
in <0x000d5> ByteFX.Data.MySqlClient.Driver:ReadPacket ()
in <0x00198> ByteFX.Data.MySqlClient.Driver:Open
(ByteFX.Data.MySqlClient.MySqlConnectionString)
in <0x0003c> ByteFX.Data.MySqlClient.MySqlInternalConnection:Open ()
in <0x000ef> ByteFX.Data.MySqlClient.MySqlPool:CreateNewPooledConnection ()
in <0x0021d> ByteFX.Data.MySqlClient.MySqlPool:GetPooledConnection ()
in <0x00053> ByteFX.Data.MySqlClient.MySqlPool:GetConnection ()
in <0x00112> ByteFX.Data.MySqlClient.MySqlPoolManager:GetConnection
(ByteFX.Data.MySqlClient.MySqlConnectionString)
in <0x0007c> ByteFX.Data.MySqlClient.MySqlConnection:Open ()
                                                                                
                                            
##############
And with sqlsharp:

SQL# \Provider MySql
The default Provider is LOADEXTPROVIDER
          Assembly: Mono.Data.MySql
  Connection Class: Mono.Data.MySql.MySqlConnection
 
SQL# \Provider MySqlNet
The default Provider is LOADEXTPROVIDER
          Assembly: ByteFX.Data
  Connection Class: ByteFX.Data.MySQLClient.MySQLConnection
 
SQL# \ConnectionString Server=localhost; Database=db1; UserID=root;
Password=rootpwd;
 
SQL# \Open
Attempt to open connection...
Loading external provider...
Error: unable to load the assembly of the provider: ByteFX.Data : File
'ByteFX.Data' not found.
################################

Any ideas?
thanks,
Valentina.


>Scrive Artur Brodowski <bzdurqa@wp.pl>:

> W li¶cie z pon, 28-06-2004, godz. 15:31, beniniva@csr.unibo.it pisze: 
> > I've mono 1 Beta with Fedora Core 2.
> > I try to test a connection string with MySQL Data Provider (ByteFx),
> compilation
> > is all right but running failed:
> 
> Install latest Mono release (RC has some issues, try Beta 3) -
> ByteFX.Data.dll version shoul be 0.7.6.1. Earlier versions of 
> the libary were broken due to namespace changes.
> 
> artb.
> -- 
> only so many songs can be sung with two lips two lungs and one tongue
> 
>