Any reason why you couldn't use a factory service to make a standard db connection via code and then remove it via code when you are finished with it?
You won't have to manually go into the administrator to do any of this. You should be able to do it all with code on the fly, or am I missing something? Regards Darren Tracey Systems Analyst HR Systems and FastTrack, Web and Integration Services p: + 61 7 3232 4091 (x64091) f: + 61 7 3232 4744 e: [EMAIL PROTECTED] l: Lvl 3, 388 Queen St Brisbane QLD 4000 m: Suncorp IPC IT048, GPO Box 1453, Brisbane QLD 4000 > -----Original Message----- > From: Steve Onnis > Sent: Tuesday, 25 January 2005 3:08 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Dynamic DB connections > > Well that's great for FuseTalk > > I don't want to. I want it to be a complete installation process without > having to go into the administrator to do it. This is the > only part of the installation process that I cant do, unless as I said, I > create a datasource using script and creating it using a > connection string and use that. > > Steve > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Scott > Thornton > Sent: Tuesday, January 25, 2005 4:04 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Dynamic DB connections > > Hmmm, > > Even fusetalk makes you set up an ODBC datasource....... > > >>> [EMAIL PROTECTED] 25/01/2005 3:54:44 pm >>> > No no > I wasn't to connect to a database server in a similar fashion to the > old connectionstring method. > > Basically its for an install process where you specify the database IP, > the SA username and password and it will connect to the > database server to create a database and the database tables. > > Using a datasource, you need to have the connection there already. I am > not wanting that. I want to connect to the database server > without a datasource setup in the CFADMIN > > Steve > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Andrew > Scott > Sent: Tuesday, January 25, 2005 3:56 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Dynamic DB connections > > > Steve, > > There is a way, I have created a set of tools that will allow you to > do > this. Unfortunetly I am not at the office and don't have these tags > with me, > but the tags Create, Delete and Verify a datasource connection for use > in > Coldfusion. > > Is that what your looking for:-) > > Regards > Andrtew Scott > Technical Officer > NuSphere Pty. Ltd. > www.nusphere.com.au > > > ----- Original Message ----- > From: "Steve Onnis" <[EMAIL PROTECTED]> > To: "CFAussie Mailing List" <[email protected]> > Sent: Tuesday, January 25, 2005 2:37 PM > Subject: [cfaussie] Dynamic DB connections > > > > Ello ello ello > > > > Is there any way at all to create a dynamic connection to a database? > I > know you can't use the connection string attribute now so > > was wondering if anyone knows of another way. > > > > I guess you could create a datasource on the fly using the > connection > string but there must be an easier way > > > > Steve > > > > > > --- > > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ ----------------------------------------------------------------------------------- This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities ("Suncorp"). Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
