aspose file tools
The moose likes JDBC and the fly likes Connecting to MS Access using Oracle stored procedures and JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Connecting to MS Access using Oracle stored procedures and JDBC" Watch "Connecting to MS Access using Oracle stored procedures and JDBC" New topic
Author

Connecting to MS Access using Oracle stored procedures and JDBC

M VS
Greenhorn

Joined: Nov 16, 2004
Posts: 1
Hi All,

How to access MS Access Database from Oracle Stored Procedure.

With Regards,
mvsp777
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Simple answer is: you can't. What I'd do, if you are stuck using the poor excuse for a database Access is, is create the model currently held in Access as a schema in Oracle, then use the linked table manager in Access to link to it. Now you can access your data with any Oracle feature, but still have an Access front end to it.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 56204
    
  13

"M VS",

We're pleased to have you here with us on the Ranch, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
bear
Forum Bartender


[Smart Questions] [JSP FAQ] [Books by Bear] [Bear's FrontMan] [About Bear]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connecting to MS Access using Oracle stored procedures and JDBC
 
Similar Threads
How Can I Use Type 4 Driver for MS-Access and Oracle
Stored Procedures & MS-Access
database in netbeans
I need help with "primary and foreign key" in my data migration code.... Please help.
populate data from csv into oracle