×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Is it possible to work with oracle sqlserver with adp?

Is it possible to work with oracle sqlserver with adp?

Is it possible to work with oracle sqlserver with adp?

(OP)
I am trying to set up a project, but do not wish to use the microsoft sql feature. Instead I want to connect to an oracle db with odbc. Is that possible in access database prosject?

RE: Is it possible to work with oracle sqlserver with adp?

ADP's were made to work with sql-server or msde. If you want to connect to oracle use an mdb or use linked servers in sql-server.

Christiaan Baes
Belgium
"What a wonderfull world" - Louis armstrong

RE: Is it possible to work with oracle sqlserver with adp?

(OP)
ok, but how do I define a connection to oracle with mdb? I do need that to execute a query directly to an oracle table? I know how to import tables and data but I dont know how to update tables etc in oracle with an access interface. Thanks

RE: Is it possible to work with oracle sqlserver with adp?

you need to install the oracle client tools then setup a system dns (i suppose you know how to that?)
then in access go to link tables and link the tables to a odbc-source aka the one you defined in your system dns.

so in link tables choose odbc-sources instead of *.mdb
When you click ok it can take a few minutes before you get anything depends on the speed of conection and how many tables (queries you have in oracle)

Christiaan Baes
Belgium
"What a wonderfull world" - Louis armstrong

RE: Is it possible to work with oracle sqlserver with adp?

(OP)
Thanks, that worked! Ok, one more thing.. how do I call a procedure or another event that I have stored in oracle from access? For example I want to do all my querys in pl/sql but how do I call them to see the result in a form made in access? Thank you so much for your help. :)

RE: Is it possible to work with oracle sqlserver with adp?

im sorry but i cant help you anymore. I use sql-server and linked servers and copy my data from oracle to sql-server via dts. I dont update the oracle database.

Christiaan Baes
Belgium
"What a wonderfull world" - Louis armstrong

RE: Is it possible to work with oracle sqlserver with adp?

Read up on pass-through query. You can make a pass-through query the row source of a Form.

RE: Is it possible to work with oracle sqlserver with adp?

Perhaps this link would be helpful.

Examples of returning result sets from Oracle
Stored Procedures using various languages, including VB,
odbc, java, etc.

http://osi.oracle.com/~tkyte/ResultSets/index.html

RE: Is it possible to work with oracle sqlserver with adp?

(OP)
Thank you! you have all been very helpful! I love this forum! :)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close