Re: Oracle/ODBC

When you created your table in Access, did the name contain lowercase letters?

If so, Oracle won't "see" the table unless you put the table name in quotes (single quotes, I think). It will list it in the USER_TABLES view, but you won't be able to execute SQL statements against it.

Likewise, if any of your field names contain lowercase letters, oracle will return an "invalid column name" error unless you put the column names in quotes.

Your best bet is to simply name all tables & fields with uppercase letters in Access, and then do the export to Oracle.

Annoying, huh? Such is the nature of the Access-->ODBC-->Oracle link.

Good luck.

-John

>
> mlaudon_at_mail.canfor.ca wrote in article <869164013.26385_at_dejanews.com>...
> > 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