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: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of Robert Jordan >> Sent: 23 October 2006 15:40 >> To: [email protected] >> 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 - [email protected] >>>>>>>> http://lists.ximian.com/mailman/listinfo/mono-list >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>> _______________________________________________ >>>>>> Mono-list maillist - [email protected] >>>>>> http://lists.ximian.com/mailman/listinfo/mono-list >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>> _______________________________________________ >>>>> Mono-list maillist - [email protected] >>>>> http://lists.ximian.com/mailman/listinfo/mono-list >>>>> >>>>> >>>>> >>>> _______________________________________________ >>>> Mono-list maillist - [email protected] >>>> http://lists.ximian.com/mailman/listinfo/mono-list >>>> >>>> >>>> >>>> >>> _______________________________________________ >>> Mono-list maillist - [email protected] >>> http://lists.ximian.com/mailman/listinfo/mono-list >>> >>> >> >> _______________________________________________ >> Mono-list maillist - [email protected] >> http://lists.ximian.com/mailman/listinfo/mono-list >> >> _______________________________________________ >> Mono-list maillist - [email protected] >> http://lists.ximian.com/mailman/listinfo/mono-list >> >> >> > > > ------------------------------------------------------------------------ > > _______________________________________________ > Mono-list maillist - [email protected] > http://lists.ximian.com/mailman/listinfo/mono-list _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
