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

[Daniel Morgan]

SQL# does not support external providers put in the Mono GAC.
I need to fix this before Mono 1.0.

-----Original Message-----
From: mono-list-admin@lists.ximian.com
[mailto:mono-list-admin@lists.ximian.com] On Behalf Of Pablo Baena
Sent: Tuesday, June 29, 2004 12:32 PM
To: mono-list@lists.ximian.com
Subject: Re: [Mono-list] Problem with MySQL Data Provider (ByteFx)


This is a permission problem in your Mysql configuration.

On Tuesday 29 June 2004 14:32, beniniva@csr.unibo.it wrote:
> Hi,
>
> I've just installed Mono Beta 3...but I've still problems:
>
> ##############
> [root@or2 mono]# mcs provaByteFX.cs -r System.Data.dll -r=20
> ByteFX.Data.dll Compilation succeeded [root@or2 mono]# mono=20
> provaByteFX.exe
>
>
> Unhandled Exception: ByteFX.Data.MySqlClient.MySqlException: Host=20
> '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 ()=20
> in <0x000ef>=20
> ByteFX.Data.MySqlClient.MySqlPool:CreateNewPooledConnection () in=20
> <0x0021d> ByteFX.Data.MySqlClient.MySqlPool:GetPooledConnection () in=20
> <0x00053> ByteFX.Data.MySqlClient.MySqlPool:GetConnection () in=20
> <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=3Dlocalhost; Database=3Ddb1; =
UserID=3Droot;=20
> Password=3Drootpwd;
>
> 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=B6cie z pon, 28-06-2004, godz. 15:31, beniniva@csr.unibo.it=20
> > pisze:
> > > I've mono 1 Beta with Fedora Core 2.
> > > I try to test a connection string with MySQL Data Provider=20
> > > (ByteFx),
> >
> > compilation
> >
> > > is all right but running failed:
> >
> > Install latest Mono release (RC has some issues, try Beta 3) -=20
> > ByteFX.Data.dll version shoul be 0.7.6.1. Earlier versions of the=20
> > libary were broken due to namespace changes.
> >
> > artb.
> > --
> > only so many songs can be sung with two lips two lungs and one=20
> > tongue
>
> _______________________________________________
> Mono-list maillist  -  Mono-list@lists.ximian.com=20
> http://lists.ximian.com/mailman/listinfo/mono-list
_______________________________________________
Mono-list maillist  -  Mono-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list