Re: strange problem when selecting from database

It seems that ODBC was the same version before and after restarting the computer (no new version was installed). (Maybe there was a new version, but it wasn't active somehow, till the reboot, for reason I don't know).
Besides, how can I do : Enabling tracing in the ODBC admin applet ? And what should I pay attention to in the tracing phase ?

Thanks :)

"Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:vicvi0ltqtrurqcpclj5pd941q7f2b65pe_at_4ax.com...
> On Fri, 27 Aug 2004 23:10:39 +0200, "Eitan"
> <no_spam_please_at_nospam.com> wrote:
>
> >Hello,
> >
> >I am using V.B. with Oracle 9i (on the server side).
> >(on the client side there is oracle 8i).
> >I did rebooot the server computer, and also the database.
> >
> >Before restrarting the computer, I did the following :
> >select 'ABC' from dual
> >The result was : 'ABC'.
> >After restrarting the computer (server), I did the same :
> >select 'ABC' from dual
> >The result was : 'ABC ' (with spaces - no. length of the whole
> >string was 32 bytes once, but it was not a fixed length after).
> >
> >I have checked this out on the client and also on the server computer,
but
> >the problem exists on both computers.
> >When I run the sql query from sql-plus (with no ODBC) the sql result was
the
> >same as before rebooting (without spaces).
> >
> >I don't understand why this, but since this was a strange behaviour both
on
> >client and server, with no other new program installed on it after
> >rebooting, it can be maybe on the ODBC server side.
> >
> >What should I check out, and how can I fix that problem ?
> >
> >Thanks :)
> >
> >
> so the problem is your odbc driver, maybe due to a pending upgrade.
> Enabling tracing in the ODBC admin applet and see what happens.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Sat Aug 28 2004 - 10:50:00 CDT