Re: Oracle/ODBC

From: N Prabhakar <n_prabhakar_at_post1.com>
Date: 1997/07/31
Message-ID: <01bc9d70$a4debcd0$725118d2@sin00119>#1/1

Hello there,

Try accessing the table by prefixing the owner. For example if the table name is emp and it is created under scott, try accessing as

scott.emp

Good Luck

N.Prabhakar

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
>
Received on Thu Jul 31 1997 - 00:00:00 CDT