Beth, Thanks for the quick response. I'm digging a little deeper into this, and I think it my have to do with the schema names. In dev I pass the username (which is also the schema name) and password in my reactor.xml <config /> and it works. In prod even if I pass the <username>,<password> vars I think it still is defaulting to the user(and schema) name being used in the cfadmin because it is using the ODBC drivers. I'm going to try creating a new data source using the schema name my app uses. I'll let the list know how it works, in case someone else ever has this problem.
Thanks Again!! Nick Maloney -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Beth Bowden Sent: Friday, April 27, 2007 3:51 PM To: [email protected] Subject: Re: [Reactor for CF] odbc driver Nick, The code for Oracle doesn't differentiate between drivers. Is there any way you can capture the sql statement causing the problem? Beth On 4/27/07, Maloney, Nicholas <[EMAIL PROTECTED]> wrote: > > > > > I've been developing an application using Reactor and am now trying to put > it in production. Unfortunately our dev and prod boxes utilize different > oracle drives. On dev we have the native oracle driver for the cf data > source and everything works fine. On prod we use an ODBC connection (because > of clustering) and the app returns the following: > > > > Detail [DataDirect][SequeLink JDBC Driver]null > > Error Code: HY000 > > Message: Error Executing database query. > > > > My current config resembles the following... > > > > <config> > > <project value="wms" /> > > <dsn value="ora_webp" /> > > <type value="oracle" /> > > <mapping value="/admin/secure/wms/model" /> > > <mode value="production" /> > > </config> > > > > I've been "googling" desperately for a solution, with no success. > > > > Thanks! > > > > Nick Maloney > > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- > Reactor for ColdFusion Mailing List > [EMAIL PROTECTED] > Archives at: > http://www.mail-archive.com/reactor%40doughughes.net/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
