Re: Oracle/ODBC

Jim Lewallen wrote:
>
> 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

Hi,

ACCESS makes errors creating ORACLE-tables. Best way is to create tables with SQL+ and then popultae them with ACCESS. To get tables with write permission via ODBC you have to add a primary key!!!!!

-- 
M.Greß    :-)