[Mono-list] How do i tell Mono (for ASP.NET, C#) where to find MySQL.Data.MySqlClient

Sun Oct 22 22:08:56 EDT 2006

Hi,

Here we go:

1) install MySql.Data into the GAC:

gacutil -i MySql.Data.dll

2) obtain MySql.Data's assembly name:

gacutil -l MySql.Data

The output should look like this (in one line), but
your version might be different:

MySql.Data, Version=1.0.7.30073, Culture=neutral, 
PublicKeyToken=8e323390df8d9ed4

3) create "web.config":

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
   <system.web>
     <compilation debug="true">
       <assemblies>
         <!-- insert *your* assembly name -->
         <add assembly="MySql.Data, Version=1.0.7.30073, 
Culture=neutral, PublicKeyToken=8e323390df8d9ed4" />
       </assemblies>
     </compilation>
   </system.web>
<configuration>

4) create a demo page "demo.aspx"

<%@ Page %>
<%@ Import namespace="MySql.Data.MySqlClient" %>
<script runat="server">
void Page_Load (object sender, EventArgs e)
{
	// test whether we can create a dummy connection
         MySqlConnection con = new MySqlConnection ();
}
</script>
<html>
<body>
</body>
</html>

Robert

steflik wrote:
> Robert,
> I'ver built the web.config and done everything you said to but Mono 
> still can't find MySql.Data.
> 
> I tried putting the MySql.Data.dll in the application /bin directory and 
> that seems to work but the better way to do this would be via the 
> web.config.
> 
> I'm trying to use Mono for an ASP.NET segment for a class I teach on web 
> programming here at the University and I really hate to have each of the 
> students place the .dll in their /bin directory.
> 
> Dick Steflik
> Binghamton University
> 
> Robert Jordan wrote:
> 
>> Hi,
>>
>> You have to create web.config in the directory of the ASP.NET
>> application. Have a look at the test site that that gets
>> installed into $prefix/lib/xsp/test.
>>
>> MySql.Data.MySqlClient is just a namespace. The assembly is
>> MySql.Data.
>>
>> Robert
>>
>> steflik wrote:
>>> Robert,
>>> I'm new at this, where do I find the web.config file, I've been looking
>>> around and it isn't obvious.  Also, my the impot that is failing is
>>> "import MySql.Data.MySqlClient"; is that the assembly you are 
>> referring to?
>>> Dick Steflik
>>>
>>> Robert Jordan wrote:
>>>
>>>> Dick Steflik wrote:
>>>>
>>>>
>>>>> I can get Mono to build a command line program using MySql (and it
>>>>> runs nicely)  but I have to tell the C# compiler where the dll is.
>>>>> How do I do this for ASP.NET using C#.
>>>>> I'm using Mono on FC5 with Apache and Mono 1.1.17....
>>>>>
>>>> Copy the MySql assembly into the bin folder of your ASP.NET app
>>>> or install the assembly into the GAC and specify the assembly name
>>>> in the web.config:
>>>>
>>>> <configuration>
>>>> <system.web>
>>>> <compilation>
>>>> <assemblies>
>>>>    <add assembly="MySql.Data, Version=x.x.x.x, Culture=neutral,
>>>> PublicKeyToken=...."/>
>>>> </assemblies>
>>>> </compilation>
>>>> </system.web>
>>>> </configuration>
>>>>
>>>> You can obtain the full assembly name with
>>>>
>>>> gacutil -l | grep MySql
>>>>
>>>> Robert
>>>>
>>>> _______________________________________________
>>>> Mono-list maillist  -  Mono-list at lists.ximian.com
>>>> http://lists.ximian.com/mailman/listinfo/mono-list
>>>>
>>>>
>>>>
>> _______________________________________________
>> Mono-list maillist  -  Mono-list at lists.ximian.com
>> http://lists.ximian.com/mailman/listinfo/mono-list
>>
>>  
>>
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
> 