ODBC with oracle hint problem & problem with queries

From: Eitan <no_spam_please_at_nospam.com>
Date: Sun, 5 Sep 2004 23:07:52 +0200
Message-ID: <413b715b$1@news.012.net.il>

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 :) Received on Sun Sep 05 2004 - 16:07:52 CDT