FYI:
A federal employer in downtown KC has a contract position opening up. The
position is for 4-6 months.
If anyone is interested, contact Jennifer Dempsie, [EMAIL PROTECTED],
913-664-0104, 8101 College Blvd. Suite 230, Overland Park, KS 66210.
Ryan
---
Deliverables:
Contractor will be
THanks for the suggestions -
When we first started developing in CF, we used native drivers and had a lot of
problems with response time and server busy messages. The decision was made by a
consultant to use ODBC datasources - so we converted all the applications to use them.
It did seem to
Beth,
You might try using the Oracle driver in the cf admin instead of the odbc
socket to see if that solves it. That's what we use for ours. Otherwise,
our setup looks pretty much the same. Slight version differences but
nothing major. Is there a specific reason you are using ODBC?
-Origi
Jeff,
The Web server Oracle client is 9.2.0.1.0
The CF MX connection is an ODBC socket to a system DSN set up with Microsoft's
ODBC for Oracle running Windows 2003 server.
The Unix Database server is running 8.1.7.3.0
The Code.
SELECT decode(type_add,'WAG',monetary_amount
I am using Oracle just a little bit on MX updater 3. We aren't having any problems
with our ODBC connection and I haven't seen that error message recently if at all.
I just searched 2 lists of oracle error messages. One came up blank, the other found
two occurences of 's01' (nothing for '01s0
We use decode on ORACLE quite often and haven't had any problems since
moving to MX. Can you post an example query? What version of ORACLE?
Jeff
-Original Message-
From: Minor, Beth [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 3:52 PM
To: [EMAIL PROTECTED]
Cc: Hagemeyer,
We are currently using CF 5 and are in the process of upgrading to CF MX. We use
ORACLE databases and ODBC data sources. While testing with CF MX I am finding that
our cfqueries that use decode statements in the sql, error out with a SQLSTATE 01S01
message. Has anyone encountered this or hav