Error adding database to ODBC Data Sources

[bataraguru]

Hi all,
I'm using CF 5 Server, today I wanted to add new dbase to my
datasource using CFAdmin but the server say there is an error. This is my first error adding dbase to ODBC datasource with error for CF Server for the past 2 years.

------------------------
Error Diagnostic Information

An error occurred while evaluating the expression:

OriginalDSN = Client.cOriginalDSN

Error near line 166, column 8.
--------------------------------------------------------------------------------

Error resolving parameter CLIENT.CORIGINALDSN

The client variable CORIGINALDSN does not exist. The cause of this error is very likely one of the following things:

The name of the client variable has been misspelled.
The client variable has not yet been created or has timed out.
To set default values for client variables you should use the CFPARAM tag (e.g. <CFPARAM NAME=&quot;Client.Color&quot; DEFAULT=&quot;Red&quot;>)

------

Is there something wrong with my server, do I need to re-install the software. Anybody can help me with this problem? Any suggestion appreciated, thanks in advanced.

cheers...

 

[ecobb]

Are you getting this error in the Administrator whenever you try to add the datasource, or are you getting this error whenever you try to run code using the datasource? If you're getting this in the Administrator, and CLIENT.CORIGINALDSN is the datasource name, drop the &quot;CLIENT.&quot; from the name.

Hope This Helps!

Ecobb

&quot;Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer.&quot; - Homer Simpson

 

[bataraguru]

Hi,
I've got this error when I add new database to the ODBC datasources in the ColdFusion Administrator not when I run a code involving a datasources. Now, I just can add new datasources from local server not remotely..
if there anyone have experience similar problem? thanks...