That is exactly what I needed. Thanks - Tom Schreck 817-252-4900 [EMAIL PROTECTED] I have not failed. I've found 10,000 ways that won't work. - Thomas Edison -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Collins Sent: Monday, May 24, 2004 9:31 AM To: [EMAIL PROTECTED] Subject: RE: [CFCDev] CF DSN
Tom, Check out the componentinvoker at bpurcell.org. It will demonstrate how to retrieve and set new dsn's via the admin CFCs. You will need to authenticate first before calling admin methods but it should be all you need. http://www.bpurcell.org/blog/index.cfm?mode=entry&entry=947 Thanks, Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Schreck, Thomas (PPC) Sent: Monday, May 24, 2004 10:17 AM To: [EMAIL PROTECTED] Subject: RE: [CFCDev] CF DSN I'm creating a UI for generating a site and need to programmatically create DSNs. I will do a search. Thanks for giving me a direction. Tom -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Ross Sent: Monday, May 24, 2004 7:41 AM To: [EMAIL PROTECTED] Subject: Re: [CFCDev] CF DSN do actually need to set up a dsn (for other apps/cfml code to use), or do you just need to dynamically connect to a db server? If it's the latter, you can (with some limitations) use Java and the macromedia JDBC driver to perform database operations (instead of CFQuery). I've seen code examples of tapping into the CF runtime's datasource service and adding DSNs programmatically... have you search the web? -dave >>> [EMAIL PROTECTED] 5/24/2004 8:35:39 AM >>> Has anyone programmatically created a DSN for a SQL Server database for CFMX 6.1? Any advice would be appreciated. Thanks - Tom Schreck 817-252-4900 [EMAIL PROTECTED] I have not failed. I've found 10,000 ways that won't work. - Thomas Edison ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
