Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: case sensitive object names via ODBC

Re: case sensitive object names via ODBC

From: <fitzjarrell_at_cox.net>
Date: Sat, 08 Sep 2007 13:49:23 -0700
Message-ID: <1189284563.382274.120070@57g2000hsv.googlegroups.com>


On Sep 7, 4:50 pm, Mark Lemoine <mark.a.lemo..._at_gmail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

Yet ANOTHER guess is it isn't the ODBC driver causing your problems, it's VB4. I use the Oracle ODBC/OLEDB drivers and experience no such problems, even when using Abscess as a front end (not my choosing, believe me).

David Fitzjarrell Received on Sat Sep 08 2007 - 15:49:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US