Re: ODBC-Access-Problems
Date: Sat, 29 Nov 2003 20:05:38 +0100
Message-ID: <bqaqm6$s23$1_at_nets3.rz.RWTH-Aachen.DE>
Well, enabling ODBC-Tracing didn't give any clue to me. The shown statements are obviously without quote in mixedcase like "select name from MyUser.Customer". Exactly the same on all machines. The tables at the server are of course completly uppercase.
When using the string "select name from 'MyUser'.'Customer'" I'll get at all machines the same error, called table not found. Using "select NAME from MYUSER.CUSTOMER" all machines work fine, but I can't change the strings in the app. So according to the manual, the string "select name from MyUser.Customer" should also work but gives an empty result set on the Win2K machine and on a WinXP machine but works fine on another Win 2K and a WinNT. I checked all settings I found without finding a different...
Any further ideas ?
"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> schrieb im Newsbeitrag
news:be0hsvs8ukhllg6d44crtfbnom7nb9l6gh_at_4ax.com...
> On 29 Nov 2003 01:51:32 -0800, Ralph.Backes_at_web.de (Ralph) wrote:
>
> >Has anybody any idea which property causes this behavior and how to
> >solve
> >it?
>
>
> The obvious way to solve it is to enable ODBC tracing, maybe sqlnet
> tracing, and Oracle tracing.
> You could also set up an event for ora-942 at the serverside.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Sat Nov 29 2003 - 20:05:38 CET