Re: Problems with Access 97, ODBC 32 and Oracle 8

I had this same problem. It is an Oracle ODBC driver problem. It has to do with the underscore in the owner name -- you can't use them. If you would like more details, email me directly (We has an owner name with 2 underscores and had to change it to none.)

Gail :)

Rob Stevens wrote:

> Hi folks,
>
> I seem to have come across a problem when linking to a table held on
> Oracle 8 (Solaris) from Access 97 (SP1) running on NT (SP3).
>
> You should be able to simply set up the ODBC data source, and go to
> link table, select the required one, and (subject to permissions of
> the Oracle account used) get access to the table.
>
> This only works for some. :(
>
> After much messing around making sure permissions were not a problem
> (I gave everything to the account without any effect) the only reason
> I could come up with was the schema name and the tablespace name not
> being the same.
>
> For example:
>
> User: REGISTRY
> Tablespace Name: REGISTRY
> Schema Name: REGISTRY
>
> Works fine - whilst:
>
> User: ASPL_MANAGER
> Tablespace Name: ASPL
> Schema Name: ASPL_MANAGER
>
> Does not. It gets as far as actually selecting the table from the
> list, then says it cannot find the table, just like a permission
> violation would display. (error 3011)
>
> This happens for several other similarly named
> users/tablespaces/schemas. But when I create:
>
> User:TEST
> Tablespace Name:TEST
> Schema Name:TEST
>
> It works perfectly
>
> All I can think of is that either the ODBC driver needs updating (I
> can tell you which one it is on request), or that Access is trying to
> get at the tablespace using the wrong naming: i.e aspl_manager.<table>
> instead of aspl.<table> (Using the pervious example)
>
> Does anyone have any ideas ?
>
> -Rob Stevens-
> System Manager
> DERA Farnborough
Received on Fri Oct 16 1998 - 00:00:00 CDT