Re: Oracle/ODBC

From: Jim Lewallen <jameslew_at_blarg.net>
Date: 1997/07/19
Message-ID: <5qqngn$rbj$1@guysmiley.blarg.net>#1/1

In article <869164013.26385_at_dejanews.com>, mlaudon_at_mail.canfor.ca wrote:
>I have exported to Oracle a database table I created in Access97 through
>ODBC. I can access that data no problem through Access, however, when I
>try and access it from other applications, I get an Oracle error message
>stating that the table or view does not exist. I even get that message
>when using the Oracle 32 bit ODBC test, even though the table shows up in
>the list of user tables. Any ideas?
>
>mlaudon_at_mail.canfor.ca
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

Just a guess, but I know that Access usually uses case-sensitive names. Does the table show up in mixed case through ODBC Test?

The way to get Oracle to recognize a mixed case name is to put quotes around it. Something like:

SELECT * FROM "MyTable"

If you did

SELECT * FROM MyTable

it would fail.

Good luck!

--jim Received on Sat Jul 19 1997 - 00:00:00 CDT