J For simplicity I would not fear MSDE, It is a one click install You will face more difficulty with 2 versions
N ----- Original Message ----- From: "vss" <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Thursday, October 30, 2003 11:34 AM Subject: RE: [DUG]: Calrification - if anyone can > Thats an interesting document. The "concurrent batch workloads" is well > defined too as I think last time I raised the MSDE issue it was not the > clear. > > Hmm...well, it looks like I will just have to do a thin client and be > done with it. > > Jeremy > > -----Original Message----- > From: "Leigh Wanstead" <[EMAIL PROTECTED]> > To: Multiple recipients of list delphi <[EMAIL PROTECTED]> > Date: Thu, 30 Oct 2003 11:08:57 +1300 > Subject: RE: [DUG]: Calrification - if anyone can > > > Here is a link you mightbe interested. > > > > http://sqlserveradvisor.com/doc/09585 > > > > Regards > > Leigh > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Behalf Of vss > > Sent: Thursday, October 30, 2003 11:02 AM > > To: Multiple recipients of list delphi > > Subject: RE: [DUG]: Calrification - if anyone can > > > > > > yeah I use Setup Factory which hs a template you can download to do the > > MSDE install. I have already played with that. > > > > The figure of 100 connections was not a LITERAL 100 connections, it was > > just a figure. In most cases there will only be 10-15 connections. > > > > Jeremy > > > > -----Original Message----- > > From: "Leigh Wanstead" <[EMAIL PROTECTED]> > > To: Multiple recipients of list delphi <[EMAIL PROTECTED]> > > Date: Thu, 30 Oct 2003 10:49:02 +1300 > > Subject: RE: [DUG]: Calrification - if anyone can > > > > > Hi Jeremy, > > > > > > To install MSDE is quite easy, Microsoft got a standard installation > > in > > > MSDN > > > cds. All you need to do is just simply call the setup with some > > command > > > line > > > parameters. I use wise installer to write script to call that setup. > > > > > > But MSDE only allow limited concurrent connections, not the figure > > 100 > > > you > > > want. > > > > > > Technically speaking if you use my last suggestion, MSDE/MS SQL > > server > > > will > > > only treat your middle tier server application as one single > > > connection. But > > > according to MS license, that solution is multiplexing connection. So > > I > > > suggestion you to use Ms Access. As Access doesn't have these sorts > > of > > > license. > > > > > > Regards > > > Leigh > > > > > > > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] > > > Behalf Of vss > > > Sent: Thursday, October 30, 2003 10:35 AM > > > To: Multiple recipients of list delphi > > > Subject: RE: [DUG]: Calrification - if anyone can > > > > > > > > > Well, my MAIN fear for using MSDE is basically the setup. > > > I am not the person who will be setting it up, and it might be a non > > > techincal person doing the installation. > > > This then introduces a lot of issues that make me , well, > > > uncomfortable, > > > if not scared ;-) > > > My inital thought was MSDE was over kill, as the product will be used > > > by > > > Joe blow who uses it on ONE PC to corporates who have a client util > > on > > > many machines. > > > I am TRYING to avoid 2 diff versions, but I guess just thinking about > > > it, > > > if I use straight ADO, and not Titan Access 2000, I can just use a > > > different connection string, although I am not sure what effect this > > > would have on things like querys. > > > > > > How do those of you who use MSDE get on when it comes to > > installations? > > > > > > Jeremy > > > > > > -----Original Message----- > > > From: "Leigh Wanstead" <[EMAIL PROTECTED]> > > > To: Multiple recipients of list delphi <[EMAIL PROTECTED]> > > > Date: Thu, 30 Oct 2003 10:19:11 +1300 > > > Subject: RE: [DUG]: Calrification - if anyone can > > > > > > > Hi Jeremy, > > > > > > > > My understanding is Access is flat file DB, and is different from > > SQL > > > > server. It will face lock problem. > > > > > > > > Regards > > > > Leigh > > > > > > > > -----Original Message----- > > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] > > > > Behalf Of vss > > > > Sent: Thursday, October 30, 2003 9:30 AM > > > > To: Multiple recipients of list delphi > > > > Subject: [DUG]: Calrification - if anyone can > > > > > > > > > > > > For a client utility I have written for another one of my apps. I > > am > > > > using ADO to connect to an Access DB. Normally I use Titan Access > > > 2000 > > > > controls, but I needed to use ADO because it has the "Sort" > > property > > > > where you tell it to sort the data by a field name. > > > > This is fine, but what I have confused myself about now is, the > > user > > > > will > > > > have the client util running most of the time. > > > > I am concious of the fact that the ado needs a connection to the > > > Access > > > > DB, and this potentually is connected all the time, but since teh > > > app. > > > > is > > > > MDI, when a form is opened, it will then create a connection to the > > > db, > > > > and close it when the form is closed. > > > > BUT if the form is NOT closed, the connection still exists. > > > > > > > > What I would like if any on can, is confirmation of the fact that > > if > > > > say > > > > 100 people have a connection to the access db, but its not actually > > > in > > > > use, its still ok. Obviously if 100 people are hitting the DB then > > > > there > > > > is a problem. > > > > > > > > Or to put it another way, a 100 connections is fine, but 100 > > > > connections > > > > being used at the same time is a problem. > > > > > > > > I hope people understand what I am meaning. > > > > > > > > Jeremy > > > > > > > > > > > > > ----------------------------------------------------------------------- > > > > ---- > > > > New Zealand Delphi Users group - Delphi List - > > > [EMAIL PROTECTED] > > > > Website: http://www.delphi.org.nz > > > > To UnSub, send email to: [EMAIL PROTECTED] > > > > with body of "unsubscribe delphi" > > > > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > > > > > > > > > > > > > > > > ----------------------------------------------------------------------- > > > > ---- > > > > New Zealand Delphi Users group - Delphi List - > > > [EMAIL PROTECTED] > > > > Website: http://www.delphi.org.nz > > > > To UnSub, send email to: [EMAIL PROTECTED] > > > > with body of "unsubscribe delphi" > > > > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > > > > > > > ----------------------------------------------------------------------- > > > ---- > > > New Zealand Delphi Users group - Delphi List - > > [EMAIL PROTECTED] > > > Website: http://www.delphi.org.nz > > > To UnSub, send email to: [EMAIL PROTECTED] > > > with body of "unsubscribe delphi" > > > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > > > > > > > > > > ----------------------------------------------------------------------- > > > ---- > > > New Zealand Delphi Users group - Delphi List - > > [EMAIL PROTECTED] > > > Website: http://www.delphi.org.nz > > > To UnSub, send email to: [EMAIL PROTECTED] > > > with body of "unsubscribe delphi" > > > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > > > ----------------------------------------------------------------------- > > ---- > > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > > Website: http://www.delphi.org.nz > > To UnSub, send email to: [EMAIL PROTECTED] > > with body of "unsubscribe delphi" > > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > > > > > ----------------------------------------------------------------------- > > ---- > > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > > Website: http://www.delphi.org.nz > > To UnSub, send email to: [EMAIL PROTECTED] > > with body of "unsubscribe delphi" > > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > -------------------------------------------------------------------------- - > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > > --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
