ODBC vs JDBC sql syntax differences

2004-08-31 Thread Samuel R. Neff
Are there differences in SQL/functions when moving from an ODBC datasource to a JDBC datasource? We're hosting an application for another contractor and their app is the only one using ODBC (all apps use Oracle).We'd like to remove the ODBC services (well, we're setting up a brand new box and

Re: ODBC vs JDBC sql syntax differences

2004-08-31 Thread Jochem van Dieten
Samuel R. Neff wrote: Are there differences in SQL/functions when moving from an ODBC datasource to a JDBC datasource? I know from theory there can be differences, but I have never encountered them. But ODBC and JDBC are not bug-compatible of course :) Jochem [Todays Threads] [This

Re: ODBC vs JDBC sql syntax differences

2004-08-31 Thread S . Isaac Dealey
Are there differences in SQL/functions when moving from an ODBC datasource to a JDBC datasource? We're hosting an application for another contractor and their app is the only one using ODBC (all apps use Oracle).We'd like to remove the ODBC services (well, we're setting up a brand new box

Re: ODBC vs JDBC sql syntax differences

2004-08-31 Thread Dave Carabetta
On Tue, 31 Aug 2004 17:00:34 -0400, Samuel R. Neff [EMAIL PROTECTED] wrote: Are there differences in SQL/functions when moving from an ODBC datasource to a JDBC datasource? We're hosting an application for another contractor and their app is the only one using ODBC (all apps use Oracle).We'd

Re: ODBC vs JDBC sql syntax differences

2004-08-31 Thread S . Isaac Dealey
And Isaac, I won't damn you. ;) Mighty kind of you Dave. :) Although ... I'm not sure about Oracle, but I know that with SQL Server you can (maybe not with all JDBC drivers, but I'm pretty sure I have with at least one) use more than one sql statement in a single cfquery without the semicolons.

Re: ODBC vs JDBC sql syntax differences

2004-08-31 Thread Dave Carabetta
On Tue, 31 Aug 2004 20:49:55 -0400, S. Isaac Dealey [EMAIL PROTECTED] wrote: And Isaac, I won't damn you. ;) Mighty kind of you Dave. :) Although ... I'm not sure about Oracle, but I know that with SQL Server you can (maybe not with all JDBC drivers, but I'm pretty sure I have with at