Re: case sensitive object names via ODBC

On Sep 7, 3:36 pm, Mark Lemoine <mark.a.lemo..._at_gmail.com> wrote:
> I've been assigned to support a legacy app that we have that's coded
> in VB4 (16bit) that connects to an Oracle db via ODBC. Everything is
> fine in the production environment, my problem is in the test db
> environment that I'm trying to setup.
>
> I got a script from the dba from the production db to create the
> tables, etc. I run that script on my test db and that''s fine. But,
> when I try to perform a select from my code:
>
> Select * from Translation
>
> I get an error back something like "query or table not found" (sorry,
> I didn't write down the exact msg). When I change the query to:
>
> Select * from TRANSLATION
>
> It works fine. This is connecting thru an ODBC dsn using DAO (hey - I
> did say that it's legacy!). The table names in the script are not
> quoted (so they should be case-insensitive).
>
> If I run SQL*Plus, then the table name is not case sensitive (that is,
> Translation or TRANSLATION works), so this is something just with my
> ODBC setup, I conclude.
>
> Can anyone help? What's wrong with what I'm trying to do?
>
> Thanks
> Mark

One guess is that it may be how the ODBC/DAO piece 'transliterates' the script. You'll know that by querying V$SQLTEXT and looking for your queries; you may well find the table names wrapped in quotes even though they aren't in the source script.

Just a thought.

David Fitzjarrell Received on Fri Sep 07 2007 - 15:43:55 CDT