RE: Red Sky, Oracle 9i, WDDX and ODBC

2003-08-14 Thread Aidan Whitehall
> What about using the Oracle native drivers ? I tried that on the development machine, but then a different query on the home page threw an error (figured it wasn't a good sign). Plus, the production server is only Professional, not Enterprise (AFAIK, no native Oracle drivers for Professional).

RE: Red Sky, Oracle 9i, WDDX and ODBC

2003-08-14 Thread Aidan Whitehall
> This is a hunch, I remember it was a problem in cf5 w/spectra. In your select > statement put the wddx column at the end. More specifically put all blob/clob > fields at the end of your sql select statement. Just read this after I found a way around it, so unfortunately can't say if your suggest

RE: Red Sky, Oracle 9i, WDDX and ODBC

2003-08-14 Thread Mike Nimer
enterprise) they all treat clob/blob fields a little differently. Hth, nimer -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 10:07 AM To: CF-Talk Subject: RE: Red Sky, Oracle 9i, WDDX and ODBC > What about using the Oracle nat

Re: Red Sky, Oracle 9i, WDDX and ODBC

2003-08-14 Thread Thomas Chiverton
On Wednesday 13 Aug 2003 13:11 pm, Aidan Whitehall wrote: > this error when querying an Oracle 9i database via ODBC: What about using the Oracle native drivers ? -- Tom Chiverton (sorry 'bout sig.) Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited

Re: Red Sky, Oracle 9i, WDDX and ODBC

2003-08-14 Thread Thomas Chiverton
Oh, OK, it's just we're using the J2EE version here against 9i with no problems. -- Tom Chiverton (sorry 'bout sig.) Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900

Red Sky, Oracle 9i, WDDX and ODBC

2003-08-14 Thread Aidan Whitehall
I installed 6.1 on an XP Professional development machine and it's throwing this error when querying an Oracle 9i database via ODBC: [Macromedia][SequeLink JDBC Driver]Network problem, session aborted due to internal error in remote procedure call, connection closed. There are no problems with