RE: Adding remote datasource dynamically

2004-01-05 Thread Christine Lawson
Support -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, January 04, 2004 5:26 AM To: CF-Talk Subject: Re: Adding remote datasource dynamically Chunshen (Don) Li wrote: Oops, Java was not a friend of mine :) Same result same err msg after using javaCast

Re: Adding remote datasource dynamically

2004-01-04 Thread Jochem van Dieten
Chunshen (Don) Li wrote: Oops, Java was not a friend of mine :) Same result same err msg after using javaCast string function. I just got an email from Rafael Quinones confirming that JavaCast() should work: cfset DBpassword=mypassword cfscript factory = CreateObject(java,

Re: Adding remote datasource dynamically

2003-12-18 Thread Jochem van Dieten
Chunshen (Don) Li wrote: Jochem, are you dropping the ball? I don't use datasource passwords stored in CF, so I can't help you. Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje [Todays Threads] [This Message] [Subscription] [Fast

Re: Adding remote datasource dynamically

2003-12-17 Thread Thomas Chiverton
On Tuesday 16 Dec 2003 21:16 pm, Chunshen (Don) Li wrote: What's your email address?I'm on CFMX 6.0.Thanks. From: Andrew Scott [EMAIL PROTECTED] If anyone is interested I am about to release a suite of tools, its been Um ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749

RE: Adding remote datasource dynamically

2003-12-16 Thread Andrew Scott
If anyone is interested I am about to release a suite of tools, its been in the making for the last 2 months but its finally almost ready to release. If you have ever wanted to create, verify, delete a datasource within a coldfusion application then this Coldfusion component will be for you.

Re: Adding remote datasource dynamically

2003-12-15 Thread Jochem van Dieten
Chunshen (Don) Li wrote: I've realized without MM inside knowledge one can't accomplish the task. Have you done anything similar? I have done it without the passwords. What is the error message? Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje

Re: Adding remote datasource dynamically

2003-12-15 Thread Jochem van Dieten
CFOBJECT ACTION="" TYPE=JAVA CLASS=coldfusion.server.ServiceFactory NAME=factory cfscript ds_service = factory.DataSourceService; ds = StructNew(); ds.CLASS = macromedia.jdbc.MacromediaDriver; ds.DRIVER = MSSQLServer; ds.NAME = FORM.dsName; ds.DATABASE = FORM.dbName; ds.HOST = FORM.serverName;

Re: Adding remote datasource dynamically

2003-12-15 Thread Jochem van Dieten
Chunshen (Don) Li wrote: 'An exception occurred during method selection process for Method encryptPasword The cause of this exception was that either there are no methods with the the specified method name and argument types, or the method encryptPasword is overloaded with arguments types that

Re: Adding remote datasource dynamically

2003-12-12 Thread Jochem van Dieten
Chunshen (Don) Li wrote: Jochem, pls keep the ball rolling, thanks. I don't use passwords in datasource definitions so I didn't test it. Some people have reported that it worked, but I never bothered to find out the exact syntax and I don't keep IRC logs long enough to find out who reported

Re: Adding remote datasource dynamically

2003-12-11 Thread Thomas Chiverton
On Thursday 11 Dec 2003 14:11 pm, Chunshen (Don) Li wrote: there's some XML file for that laying around under CFMX installation, run a quick search yielded nothing.Refresh my memory, thanks. neo-query.xml Least that's what cd /opt/bea/user_projects/lv_platform/ceo_platform/WEB-INF/cfusion find

RE: Adding remote datasource dynamically

2003-12-11 Thread Sandy Clark
CFMX does not support dynamic dsn's.That functionality is only available in CF5. _ From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 9:11 AM To: CF-Talk Subject: Adding remote datasource dynamically Hi, My CF environment is CF6.0 For Windows (Prof.

Re: Adding remote datasource dynamically

2003-12-11 Thread Thomas Chiverton
On Thursday 11 Dec 2003 14:25 pm, Chunshen (Don) Li wrote: Thomas, you also seem to be an old man :), how could the Unix 'grep' command would be applicable to a normal Window's env? cygwin -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED]

RE: Adding remote datasource dynamically

2003-12-11 Thread Dave Watts
Thomas, you also seem to be an old man :), how could the Unix 'grep' command would be applicable to a normal Window's env? I think that he's just saying that on his Unix system, the file that he found is neo-query.xml. If you want to use grep on your Windows machine, though, I'd recommend

RE: Adding remote datasource dynamically

2003-12-11 Thread Mike Townend
if you are running MX 6.1 then there are some CFC's which should help with this. -Original Message- From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 14:36 To: CF-Talk Subject: Re:Adding remote datasource dynamically Hmm, I would beg to differ.I assumed

RE: Adding remote datasource dynamically

2003-12-11 Thread Dave Watts
CFMX does not support dynamic dsn's.That functionality is only available in CF5. Hmm, I would beg to differ.I assumed that the datasource data of a given CFMX installation is stored as an XML file and the CFMX engine and/or the CFMX Admin tool would look for it.So, if this assumption

RE: Adding remote datasource dynamically

2003-12-11 Thread Josh Remus
remote datasource dynamically Thomas, you also seem to be an old man :), how could the Unix 'grep' command would be applicable to a normal Window's env? I think that he's just saying that on his Unix system, the file that he found is neo-query.xml. If you want to use grep on your Windows machine

RE: Adding remote datasource dynamically

2003-12-11 Thread Samuel Neff
Seems to be a little confusion of terms. Sandy is definitely correct that CFMX does not support dynamic data sources in the most common use of the term as people use dynamic data source to refer to the ability to connect to a database without creating a coldfusion datasource to it.The ability to

Re: Adding remote datasource dynamically

2003-12-11 Thread Jochem van Dieten
Chunshen (Don) Li wrote: Question on coldfusion.server.ServiceFactory CLASS, it seems to have a method called getDataSourceService(), in the instances of MS SQL 7 and above, I would think it also has a method called AddDataSourceService() something You just create a structure with the right

Re: Adding remote datasource dynamically

2003-12-11 Thread Jochem van Dieten
Chunshen (Don) Li wrote: Thanks.Getting close, but password encryption step failed, I tried to encrypt it during pwd insertion also failed, any idea what's going on? StructUpdate(ds, password,#factory.DataSourceService.encryptPasword()#); Shouldn't you insert the password somewhere: