On 9/30/05, Matt Osbun <[EMAIL PROTECTED]> wrote: > As for the first, Coldfusion 7 Standard. Sorry I didn't mention that > initially. > > As for the second... Mostly because of this: > "java.sql.SQLException: Use of Macromedia JDBC Drivers is restricted. > Drivers can only be used with Macromedia server products. Please check > that your license supports the requested driver. > The root cause was that: java.sql.SQLException: Use of Macromedia JDBC > Drivers is restricted. Drivers can only be used with Macromedia server > products. Please check that your license supports the requested driver." > > Which never seemed a problem before, as the Thin was good enough. The > vast majority of our CF querying is done with SQL Server. >
Ah, Standard Edition. That makes sense, as Oracle access is only allowed with Enterprise Edition. Regarding your actual issue, nothing jumps out based on what you've posted, though I've only ever used the bundled drivers with Oracle so I don't know for sure what is and is not supported with third-party drivers. However, did you try your code using an OUT param instead of using cfprocresult? <cfprocparam cfsqltype="CF_SQL_REFCURSOR" type="out" value="foo" /> I really don't know if that will do anything (sorry), but it's worth a shot. Regards, Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219791 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
