By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,681 Members | 1,854 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,681 IT Pros & Developers. It's quick & easy.

Oracle Linked Tables - Big problem

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
D.Bennett wrote:
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.


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
Nov 13 '05 #2

P: n/a
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.

Nov 13 '05 #3

P: n/a
Hi Darryl, the stuff you did here was for the Oracle driver?

D.Bennett wrote:
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.

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

P: n/a
All of this is for using the Microsoft Oracle ODBC driver for the
connection.

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.