[Mono-list] How do i tell Mono (for ASP.NET, C#) where to find MySQL.Data.MySqlClient
Robert Jordan
robertj at gmx.net
Mon Oct 23 14:26:46 EDT 2006
Dick Steflik wrote:
> Robert,
> Yes, I have and when I look in the GAC using gacutil it says that it is
> there. Was I supposed to do something with the -package option on the
> gacutil command when I put it onto the GAC (I followed the direction on
> the MySql site and your instructions)?
I was pretty sure you're trying to run an aspx file, but now I have
the impression you're compiling from the command line.
If so, install the assembly using
pkgconfig -package mysql -i MySql.Data
and compile using
mcs -lib:/usr/lib/mono/MySql -r:MySql.Data ...
Replace /usr with your mono prefix.
Robert
>
> Dick
>
> Robert Jordan wrote:
>
>> Dick Steflik wrote:
>>
>>
>>> When I put the .dll (MtSql.Data.dll in ny application /bin directory,
>>> everything works OK ; but when I remove it and put the reference in
>>> web.config (just like Robert said to the compiler can't find it.
>>>
>>
>> Did you install the assembly into the GAC as already told
>> a few times? :-)
>>
>> Robert
>>
>>
>>
>>> Dick Steflik
>>> Binghamton University
>>>
>>> Bradley, Peter wrote:
>>>
>>>
>>>> Dick,
>>>>
>>>> I'm sorry to butt in, but I noticed things looked as though they might
>>>> start recursing. Infinitely, possibly :)
>>>>
>>>> First up: do you understand what the GAC is?
>>>>
>>>> Second: do you understand how the .NET Framework searches for
>>>> referenced
>>>> assemblies?
>>>>
>>>> Third: do you understand what strongly named assemblies are, and how
>>>> you
>>>> refer to them (i.e. with their strong name)?
>>>>
>>>> If you have a problem with any of these, perhaps we should take a step
>>>> back and explain some of those things first. If you already understand
>>>> all that stuff, please just ignore me and I promise I'll go away.
>>>>
>>>>
>>>> Peter
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: mono-list-bounces at lists.ximian.com
>>>> [mailto:mono-list-bounces at lists.ximian.com] On Behalf Of Robert Jordan
>>>> Sent: 23 October 2006 15:40
>>>> To: Mono-list at lists.ximian.com
>>>> Subject: Re: [Mono-list] How do i tell Mono (for ASP.NET,C#) where to
>>>> find MySQL.Data.MySqlClient
>>>>
>>>> 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
>>>>>
>>>>>
>>>>>
>>>> _______________________________________________
>>>> 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
More information about the Mono-list
mailing list