[Mono-list] How do i tell Mono (for ASP.NET, C#) where to find MySQL.Data.MySqlClient
Dick Steflik
steflik at binghamton.edu
Mon Oct 23 14:40:11 EDT 2006
Robert,
You were correct the first time. I am trying to run an aspx file; I'm
not trying to any command line mono stuff (destop applications) only
aspx stuff with associated C# file that get compiled automatically.
Dick
Robert Jordan wrote:
>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
>>
>>
>
>_______________________________________________
>Mono-list maillist - Mono-list at lists.ximian.com
>http://lists.ximian.com/mailman/listinfo/mono-list
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-list/attachments/20061023/a74edbdd/attachment-0001.html
More information about the Mono-list
mailing list