Re: case sensitive object names via ODBC

On Sep 7, 4:43 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

Yup, that's it. When I look at V$SQLTEXT, I can see quotes around my table reference, ie 'Translation'.

I'm using the Oracle v9 odbc driver. I don't see any options on the dsn setup to control this behavior.

Any ideas on how I turn this off? Or a different odbc driver to use (at this stage of the app's life, converting from odbc to something else isn't an option)? (I am checking to see what's configured on the working-fine-in-production workstations).

Thanks!
Mark Received on Fri Sep 07 2007 - 16:50:30 CDT