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

Mon Oct 23 08:53:15 EDT 2006

Robert,
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?

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
>
>  
>