>>I actually thought of using Intraweb because along with the TMS Intraweb >>controls wich we brought ages ago, we could do a lot of stuff quickly, >>BUT the problem IS, I would need a stand-alone app. and the version of >>Intraweb that comes with Delphi will only run on 127.0.0.1 and therefore >>I suspect I will not beable to access it from another machine....or am I >>wrong there?
Because they want you to pay more money, so you can connect to other machine. Just get a copy of Indy, which should contain a proxy component, you can use that proxy component to do whatever you like. It is not that hard anyway. Regards Leigh -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of vss Sent: Thursday, October 30, 2003 1:11 PM To: Multiple recipients of list delphi Subject: Re: [DUG]: Calrification - if anyone can Well after seeing all the info people have written etc. and thn thinking about it some more, I think that the solution for me, at this stage, is to basically to have the client util run in the System Tray. The user will click on the item they want, which will open the form, and then a connection to the database. Hey user will do what they need to, then because it wil in their face, they will close the form, and the DB Connection will close. I think this is the solution for now, as the user actually wont be in the form for all that long. they might just do an Account lookup or edit some data, and thats it. I actually thought of using Intraweb because along with the TMS Intraweb controls wich we brought ages ago, we could do a lot of stuff quickly, BUT the problem IS, I would need a stand-alone app. and the version of Intraweb that comes with Delphi will only run on 127.0.0.1 and therefore I suspect I will not beable to access it from another machine....or am I wrong there? Jeremy -----Original Message----- From: "Neven MacEwan" <[EMAIL PROTECTED]> To: Multiple recipients of list delphi <[EMAIL PROTECTED]> Date: Thu, 30 Oct 2003 12:39:54 +1300 Subject: Re: [DUG]: Calrification - if anyone can > 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/ --------------------------------------------------------------------------- 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/
