How a server oracle can read mdb(access) database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raimo - 30 Apr 2008 11:49 GMT

Hi. I have a server "A" with oracle 10g express (free) and a server
"B" with an Access database.
I need that an application that uses oracle server can reads tables on
"B". How can i do this?
Can do i make a Local View on "A" of "B"?
thanks

Reply to this Message

C. (http://symcbean.blogspot.com/) - 30 Apr 2008 13:28 GMT

> Hi. I have a server "A" with oracle 10g express (free) and a server
> "B" with an Access database.
> I need that an application that uses oracle server can reads tables on
> "B". How can i do this?
> Can do i make a Local View on "A" of "B"?
> thanks

You can attach odbc tables in Access, but performance sucks big time
when Access tries to resolve queries on remote tables.

Keep all your data in Oracle and use passthrough queries so that
Oracle does the clever stuff. (Or keep everything in Access - but
concurrent access sucks).

C.

Reply to this Message

Molok - 30 Apr 2008 14:27 GMT

> > Hi. I have a server "A" with oracle 10g express (free) and a server
> > "B" with an Access database.
[quoted text clipped - 5 lines]
> You can attach odbc tables in Access, but performance sucks big time
> when Access tries to resolve queries on remote tables.

I'll 've to do only a few of interrogation of "select" two-three time
at day, so performance are not a problem.

> Keep all your data in Oracle and use passthrough queries so that
> Oracle does the clever stuff. (Or keep everything in Access - but
> concurrent access sucks).

Mhm. How i can see the table in the .mdb access file on the
workstation "B" from the Oracle server in the workstation "A"?
What type of solution you suggest? Odbc, Ado...

Reply to this Message

yossarian - 30 Apr 2008 14:37 GMT

> Mhm. How i can see the table in the .mdb access file on the
> workstation "B" from the Oracle server in the workstation "A"?
> What type of solution you suggest? Odbc, Ado...

You did not specify your platform, so let's assume Windows. You have to
use the following technologies:

* Windows shared folders
* ODBC
* Oracle Heterogeneous Connectivity

HTH

Y.

Reply to this Message

Molok - 30 Apr 2008 15:32 GMT

> > Mhm. How i can see the table in the .mdb access file on the
> > workstation "B" from the Oracle server in the workstation "A"?
> > What type of solution you suggest? Odbc, Ado...
>
> You did not specify your platform, so let's assume Windows. You have to
> use the following technologies:

eheh...i hear this as "you seem to be a bit confused..so i'm sure you
have windows.." ;D
Ok: windows 2003 server+oracle that want see a table in a windows xp
access database.

> * Windows shared folders

mhm..i have to "share" the database?

> * ODBC

This is necessary on the "ms-access" machine to point at the db with a
dsn,it's right?

> * Oracle Heterogeneous Connectivity

i'm seeng a guide on this thing. i presume that my oracle versione has
the tools pre-installed.

thanks much!

> HTH
>
> Y.

Reply to this Message

yossarian - 30 Apr 2008 15:55 GMT

>> * Windows shared folders
> mhm..i have to "share" the database?

Since Access is an embedded DB, not a client/server one, you must find a
way to open the MDB file directly from the Oracle server. Windows shared
folders come to mind.

>> * ODBC
> This is necessary on the "ms-access" machine to point at the db with a
> dsn,it's right?

No, ODBC must be present on the Oracle server because Heterogeneous
Connectivity make calls to the ODBC stack.

>> * Oracle Heterogeneous Connectivity
> i'm seeng a guide on this thing. i presume that my oracle versione has
> the tools pre-installed.

No tools, just the Heterogeneous Connectivity libraries. You have to
modify a bunch of configuration files and bounce the listener IIRC.

Kind regards, Y.

Reply to this Message