Re: Help for ODBC->ORACLE
Date: 1996/06/21
Message-ID: <4qem8u$30p_at_news.halcyon.com>#1/1
In article <31C99180.316D_at_snc.com>, "Johnnie L. Pitts" <johnnie.l.pitts_at_snc.com> says:
>
>I'm trying to connect to an Oracle database(Release 7.1, (Windows NT)
>using a Visual Basic front-end and ODBC. When I try to access tables
>from within my program, using my (DBA)id/password, I get the following
>message:
>
>"Couldn't execute query;couldn't find linked table.[ORACLE][ODBC Oracle
>Driver][ORACLE OCI] ORA-00942:table or view does not exist. [#942]"
>
>However, if I connect as SYS, I can get access to the desired tables. Is
>some system table being accessed that requires a special priviledge be
>granted?
>I'm relativly new to this environment and would appreciate any help
>anyone can give.
Jonnie,
If you're having difficulty installing and configuring,your ODBC driver, you might check out SimbaExpress, a server-hosted ODBC solution. SimbaExpress eliminates SQL*net from the desktop, and the Oracle ODBC driver we provide (our own) only has to be installed on your NT server. The client component (Win 3.x, 95, NT) is installed very quickly.
Randy Received on Fri Jun 21 1996 - 00:00:00 CEST