Oracle Linked Tables - Big problem

I have installed the Oracle 10g client on my pc, setup net manager
connection so I can connect to the database, and created the ODBC
entry.


When I link the tables, all I get is one letter for each table name (I
believe it is the first letter of the user name). I
get a long list of "c", "d", I don't get the actual table names.


If I use the Oracle net manager connection in Visual Studio .Net 2003
to view the tables, it works fine. This seems to be a problem only
with Access 97.


Anyone have any ideas?


Thanks.


Darryl

re: Oracle Linked Tables - Big problem

D.Bennett wrote:
[color=blue]
> When I link the tables, all I get is one letter for each table name (I
> believe it is the first letter of the user name). I
> get a long list of "c", "d", I don't get the actual table names.[/color]

Darryl, I've never run into this personally, but I use Oracle 8i.
however, on the tech support group I participate in for a computerized
maintenance management system, another participant in that group has
encountered some problems with 10g. His solution was to use the
Microsoft Oracle ODBC driver rather than the Oracle supplied one. I
personally would prefer to use the Oracle supplied driver, but this
fellow insists the MS one takes care of his problems.

Should be easy enough to quickly create a DSN and try it.

BTW, if that does help, could you post back? My organization is loking
to upgrade from 8i soon, and by the sounds of your difficulties and some
others I've heard (see above), I'm a bit worried about my Access front
ends and 10g.

Thanks in advance.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

re: Oracle Linked Tables - Big problem

Tim,

It worked! Here are the steps I took. I don't know if all are
relevent, but I'll list them anyway.

Installed MDAC 2.8...Still did not work.
Googled the error I was getting and went to the following web site:
http://www.orafaq.com/forum/t/37835/0/

Edited the registry as per instructions (also checked out microsoft
technet article Q264012.

Rebooted, setup ODBC entry and it worked.

The only problem I see with this is if you have multiple versions of
Oracle databases to access. I'm not sure if the 10g client can connect
to 9i, or 7.3 databases.

Anyway, good luck and hope this works for you.

Darryl.

re: Oracle Linked Tables - Big problem

Hi Darryl, the stuff you did here was for the Oracle driver?

D.Bennett wrote:
[color=blue]
> Tim,
>
> It worked! Here are the steps I took. I don't know if all are
> relevent, but I'll list them anyway.
>
> Installed MDAC 2.8...Still did not work.
> Googled the error I was getting and went to the following web site:
> http://www.orafaq.com/forum/t/37835/0/
>
> Edited the registry as per instructions (also checked out microsoft
> technet article Q264012.
>
> Rebooted, setup ODBC entry and it worked.
>
> The only problem I see with this is if you have multiple versions of
> Oracle databases to access. I'm not sure if the 10g client can connect
> to 9i, or 7.3 databases.
>
> Anyway, good luck and hope this works for you.
>
> Darryl.
>[/color]


--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

re: Oracle Linked Tables - Big problem

All of this is for using the Microsoft Oracle ODBC driver for the
connection.