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

Mon Oct 23 10:40:07 EDT 2006

Dick,

steflik wrote:
> Thanks for the patience but I got the same result. If the MySql.Data.dll 
> isn't in the /bin directory the compuiler can't find it. This may sound 
> stupid but what directory shoiuld the .dll be in?

In the GAC (Global Assembly Cache), see (1) below.

Robert

> 
> Thanks,
> 
> Dick Steflik
> Binghamton University
> 
> Robert Jordan wrote:
> 
>> 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
>>>
>>>    
>>>
>> _______________________________________________
>> 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
> 