List:MySQL and .NET« Previous MessageNext Message »
From:Reggie Burnett Date:November 18 2004 4:44am
Subject:RE: Installer
View as plain text  
+1 for option

> -----Original Message-----
> From: Luke Venediger [mailto:lukev123@stripped]
> Sent: Wednesday, November 17, 2004 9:33 PM
> To: Reggie Burnett
> Cc: Lance Johnson; dotnet@stripped
> Subject: Re: Installer
> 
> Yep,
> 
> I'd prefer it if it wasn't installed in the GAC. I have a standard
> location for binaries in my development environment, including third
> party libraries, and having the MySQL DLL in the GAC may cause version
> issues later down the line.
> 
> So, having it as an option would be a great idea.
> 
> Cheers,
> Luke.
> 
> 
> On Thu, 18 Nov 2004 05:31:54 +0200, Luke Venediger <lukev123@stripped>
> wrote:
> >
> >
> > Yep,
> >
> > I'd prefer it if it wasn't installed in the GAC. I have a standard
> > location for binaries in my development environment, including third
> > party libraries, and having the MySQL DLL in the GAC may cause version
> > issues later down the line.
> >
> > So, having it as an option would be a great idea.
> >
> > Cheers,
> > Luke.
> >
> > On Wed, 17 Nov 2004 12:32:36 -0600, Reggie Burnett <reggie@stripped>
> wrote:
> > > The installer is trying to make the registry entry for vs.net 7.0 and
> 7.1 so
> > > the assembly appears in the Add Reference dialog box, however I think
> it's
> > > not working for this rev.  I'll clean it up for GA.
> > >
> > > I'm still debating whether to stuff it into the GAC. I may make it an
> > > installer option.
> > >
> > > -reggie
> > >
> > >
> > >
> > > > -----Original Message-----
> > > > From: Lance Johnson [mailto:ljohnson@stripped]
> > > > Sent: Wednesday, November 17, 2004 12:32 PM
> > > > To: dotnet@stripped
> > > > Subject: RE: Installer
> > > >
> > > > VS.Net doesn't actually add the GAC assemblies into the references
> area.
> > > > Instead if there's a directory you want added you have to make an
> edit
> > > > in your registry.  You can go to the following sites that show some
> good
> > > > info on this:
> > > >
> > > > http://www.syncfusion.com/FAQ/WinForms/FAQ_c62c.asp#q1014q
> > > > http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=591
> > > >
> > > > Hope that helps.
> > > >
> > > >
> > > > Lance Johnson
> > > > Software Developer
> > > > DOCS, Inc.
> > > > (800)455-7627 x401
> > > >
> > > > -----Original Message-----
> > > > From: Joshua Mouch [mailto:joshua@stripped]
> > > > Sent: Wednesday, November 17, 2004 12:18 PM
> > > > To: dotnet@stripped
> > > > Subject: Installer
> > > >
> > > > It'd be nice if the installer put the connector into the GAC
> > > > automatically.
> > > > Every release seems to install to a different directory, and I have
> to
> > > > go
> > > > through all my projects to change the reference paths. :P
> > > >
> > > > Which brings me to a question...
> > > > I copied the mysql connector dll to the assembly directory under
> > > > Windows.
> > > > When I look in the GAC directory, I see the Mysql.Data.dll file
> there,
> > > > but
> > > > for some reason, it doesn't show up when adding a reference to a
> project
> > > > from within Visual Studio.  All of the other GAC assemblies are
> there,
> > > > but
> > > > not Mysql.Data.dll.  Anybody else experienced this, or is my machine
> > > > just
> > > > messed up?  :-)
> > > >
> > > > Joshua Mouch
> > > > EmailScout Support Team
> > > > http://www.emailscout.net
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Jordan Sparks [mailto:jsparks@stripped]
> > > > Sent: Wednesday, November 17, 2004 1:02 PM
> > > > To: dotnet@stripped
> > > > Subject: RE: Last insert autoincrement id value with VB.NET
> > > >
> > > > I don't know of one.  But remember that you can simply build a
> function
> > > > to encapsulate that behavior.  For instance, I have:
> > > >
> > > >               public int NonQ(string command){
> > > >                       return NonQ(command,false);
> > > >               }
> > > >
> > > >               public int NonQ(string command,bool getInsertID){
> > > >                       cmd.CommandText=command;
> > > >                       int rowsChanged=0;
> > > >                       try{
> > > >                               con.Open();
> > > >                               rowsChanged=cmd.ExecuteNonQuery();
> > > >                               if(getInsertID){
> > > >                                       cmd.CommandText="SELECT
> > > > LAST_INSERT_ID()";
> > > >
> > > > dr=(MySqlDataReader)cmd.ExecuteReader();
> > > >                                       if(dr.Read())
> > > >
> > > > InsertID=PIn.PInt(dr[0].ToString());
> > > >                               }
> > > >                       }
> > > >                       catch(MySqlException e){
> > > >                               MessageBox.Show("Error:
> > > > "+e.Message+","+cmd.CommandText);
> > > >                       }
> > > >                       //catch{
> > > >                       //      MessageBox.Show("Error: "+);
> > > >                       //}
> > > >                       finally{
> > > >                               con.Close();
> > > >                       }
> > > >                       return rowsChanged;
> > > >               }
> > > >
> > > > I know it's C#, but you should be able to follow it.  Basically, the
> > > > second function does all the work, but is overloaded in the first
> > > > function.  So, throughout my code, I can either call
> > > > DataConnection.NonQ("some string"), or I can call
> > > > DataConnection.NonQ("some string",true).  Then
> DataConnection.InsertID
> > > > will contain the last increment id.  I'm sure my function above
> could be
> > > > a little more elegant, but it get's the job done.
> > > >
> > > >
> > > > Jordan Sparks
> > > >
> > > > -----Original Message-----
> > > > From: Ville Mattila [mailto:ville@stripped]
> > > > Sent: Wednesday, November 17, 2004 5:06 AM
> > > > To: dotnet@stripped
> > > > Subject: Last insert autoincrement id value with VB.NET
> > > >
> > > >
> > > > Hello,
> > > >
> > > > I was wondering if there is a function on Connector/.NET to receive
> > > > easily the value of the auto increment id from the latest inserted
> row.
> > > > Or is the only possibility to execute another query (SELECT
> > > > LAST_INSERT_ID()) ?
> > > >
> > > > Thanks,
> > > > Ville
> > > >
> > > > --
> > > > MySQL on .NET Mailing List
> > > > For list archives: http://lists.mysql.com/dotnet
> > > > To unsubscribe:
> > > > http://lists.mysql.com/dotnet?unsub=1
> > > >
> > > >
> > > >
> > > > --
> > > > MySQL on .NET Mailing List
> > > > For list archives: http://lists.mysql.com/dotnet
> > > > To unsubscribe:
> > > > http://lists.mysql.com/dotnet?unsub=1
> > > >
> > > >
> > > > --
> > > > MySQL on .NET Mailing List
> > > > For list archives: http://lists.mysql.com/dotnet
> > > > To unsubscribe:
> http://lists.mysql.com/dotnet?unsub=1
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > MySQL on .NET Mailing List
> > > > For list archives: http://lists.mysql.com/dotnet
> > > > To unsubscribe:
> http://lists.mysql.com/dotnet?unsub=1
> > >
> > >
> > >
> > >
> > > --
> > > MySQL on .NET Mailing List
> > > For list archives: http://lists.mysql.com/dotnet
> > > To unsubscribe:
> http://lists.mysql.com/dotnet?unsub=1
> > >
> > >
> >
> > --
> > Get Firefox Browser! Reclaim the web. http://getfirefox.com/
> >
> 
> 
> --
> Get Firefox Browser! Reclaim the web. http://getfirefox.com/

Thread
Last insert autoincrement id value with VB.NETVille Mattila17 Nov
  • RE: Last insert autoincrement id value with VB.NETBarry Zubel17 Nov
  • RE: Last insert autoincrement id value with VB.NETJordan Sparks17 Nov
    • InstallerJoshua Mouch17 Nov
RE: InstallerLance Johnson17 Nov
  • RE: InstallerReggie Burnett17 Nov
    • Re: InstallerLuke Venediger18 Nov
      • Re: InstallerLuke Venediger18 Nov
        • RE: InstallerReggie Burnett18 Nov
      • RE: InstallerJames Moore18 Nov