Re: ODBC with oracle hint problem & problem with queries

Eitan wrote:

> Hello,
>
> I have two problems, with ODBC driver, as follows :
>
> 1)
> I am developping in VB 6.0
> In the server (which ODBC & Oracle on it),
> I run a sql query with hints (like :Select /*+index .... /*)
> For a reason I don't know why, with ODBC the sql hung, but when I run in
> sql-plus : the query is ok, and run fast.
>
> What may be the reason of the above ?
> 2)
> For a reason I don't know, for select statement like this :
> select 'ABC' from dual.
>
> When running from sql-plus I got :
> 'ABC'
> (without spaces).
>
> And when running from VB, using ODBC, I got :
> 'ABC ' , with spaces (it is not a fixed length).
>
> Why ?
>
> Thanks :)

Version of Oracle?
Manufacturer and version of ODBC driver?

Why would you think these unimportant?

Either way likely an incompatible ODBC driver: User the Oracle driver for the version of your database.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)