Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ODBC with oracle hint problem & problem with queries

Re: ODBC with oracle hint problem & problem with queries

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 05 Sep 2004 15:46:23 -0700
Message-ID: <1094424444.617578@yasure>


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)
Received on Sun Sep 05 2004 - 17:46:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US