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.