473,321 Members | 1,748 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

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

Nov 13 '05 #1
4 3717
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
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
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
All of this is for using the Microsoft Oracle ODBC driver for the
connection.

Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Jevon | last post by:
I have used Linked Servers to hook up to an Oracle 9i database in SQL Server 2000. I can see all the Tables and Views when I look in the linked server section. I can also run the following SQL...
1
by: robin via SQLMonster.com | last post by:
I've tried several different way to execute a oracle stored procedure from a DTS package but to no avail. I have a Linked Server setup which does bring back Oracle tables from the server when I...
3
by: Jon Ole Hedne | last post by:
My Access 2002-application need to work with tables from both Oracle and Access. To solve this, I want to run some querys on three views in Oracle and import the results into temporary...
2
by: Ted Theodoropoulos | last post by:
i have some linked tables to an oracle view in A2K using the ms oracle ODBC driver. i'm having a weird issue. the data in the tables seems to repeat. for example, if i run a query in a native...
8
by: Alfonso Esteban Gonzalez Sencion | last post by:
I am trying to use Access as a front end for extracting information from an Oracle database. I started using linked tables but I am getting a very curious behaviour. When I consult the linked...
9
by: AnandaSim | last post by:
Hi All, I've had Access 97, 2000 connections to the corporate Oracle database for a few years now - but seldom use it. When I did use it years ago, performance was not fast but the features were...
2
by: egoldthwait | last post by:
I need to convert a 17mb access 2000 db to Oracle and house it in a Citrix farm. The issue: we have never converted an Access Db to Oracle but can probably use Oracle's Workbench to assist with...
3
by: Chris | last post by:
I need to link some data from SQL Server 2005 with Oracle 10 data. One way is to link Oracle server to SQL Server and use ROWSOURCE for retrieving data. What other ways for joing data from...
5
by: jonceramic | last post by:
Hi All, I started developing in Access, and people took notice and so we're starting to migrate into our corporate's bigger Oracle system. I'll still be using my developed Access front ends,...
1
by: lochmant | last post by:
I have a series of about 10 test databases with about 34 linked table each. I need to create an Access 2003 database front end for each of these. I am currently trying to write a script that will...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.