Ah, you need the DataDirect drivers that come with CF Enterprise for full Oracle functionality over JDBC. As for ODBC, sorry I can't help on that one.
On 6/7/06, Jennifer Dodson <[EMAIL PROTECTED]> wrote: > We're using CF MX 7 with the jdbc driver from Oracle. When we tried to use > it we couldn't get the resultsets back in the curser output parameters. We > found several posts online stating the same problem. All of them said to > use the ODBC Socket connection to the Oracle ODBC driver. It works great > except for the problem with the varchar output types. > > I don't know what you mean when you ask about the updater version, but if > you tell me what it is I'd be glad to find out. > > -----Original Message----- > From: Tom Chiverton [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 07, 2006 2:59 AM > To: CF-Talk > Subject: Re: Problems with Oracle Stored Procs and Varchar2 output > parameters > > On Tuesday 06 June 2006 16:16, Jennifer Dodson wrote: > > We're using the ODBC Socket connection because the JDBC connection > > wouldn't let us get result sets back from Oracle. > > It won't ? Which version of CF ? What updater version ? > > -- > Tom Chiverton > > **************************************************** > > This email is sent for and on behalf of Halliwells LLP. > > Halliwells LLP is a limited liability partnership registered in England and > Wales under registered number OC307980 whose registered office address is at > St James's Court Brown Street Manchester M2 2JF. A list of members is > available for inspection at the registered office. Any reference to a > partner in relation to Halliwells LLP means a member of Halliwells LLP. > Regulated by the Law Society. > > CONFIDENTIALITY > > This email is intended only for the use of the addressee named above and may > be confidential or legally privileged. If you are not the addressee you > must not read it and must not use any information contained in nor copy it > nor inform any person other than Halliwells LLP or the addressee of its > existence or contents. If you have received this email in error please > delete it and notify Halliwells LLP IT Department on 0870 365 8008. > > For more information about Halliwells LLP visit www.halliwells.com. > > We are pleased to announce that Halliwells LLP has been voted AIM Lawyer of > the Year at the 2005 Growth Company Awards > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242757 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54