Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


communicate odbcs driver

Posted on 2011-02-14
Medium Priority
Last Modified: 2013-12-24
How do we communicate with oracle and informix using odbc driver. Can you please tell me what steps I need to do. I really appreciate your help. Thanks in advance for your help and time.
Question by:hussainkhan22
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34889539
Do you want to see Oracle data in Informix, Informix data in Oracle, or both?

You can connect Oracle to non-Oracle databases using heterogeneous services.

As always, I'll defer you to the online docs:

Author Comment

ID: 34889783
What exactly steps we need to do on oracle database and what steps we need to do on informix database. I have never worked on this topic, so please tell me in details steps.
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34889816
>>I have never worked on this topic, so please tell me in details steps.

Like many of your questions, I'm afraid we can't provide exact steps.  How you connect the database depend on what you need to do with that connections.  This depends on the specifics of the applications/programmers making this request.

Once they tell you the what/why and how this all needs to work, we can probably help you out.

Short of that I've provided a link on connection Oracle to non-Oracle databases.
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.


Author Comment

ID: 34898933
Customer wants me to  installed/configured ODBC on our new server so there can connect to this informix database. How do I go ahead please let me know.
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34898958
You have already asked and accepted an answer on how to install the ODBC driver for Oracle:

This question is:  How do we communicate with oracle and informix using odbc driver

Author Comment

ID: 34902487
But I didn't get the correct answer as I got details about it from customer now. So what shall I do now. I am sorry about that and try not to close the question when it is not solved. I really appreciate your help
LVL 77

Accepted Solution

slightwv (䄆 Netminder) earned 2000 total points
ID: 34906963
You will need to ask a new question on how to do the install.

Again, this question is:  How do we communicate with oracle and informix using odbc driver.  

The answer is: heterogeneous services and the link is posted in http:#a34889539.
LVL 62

Expert Comment

ID: 35015309
Informix ODBC is a commercial product. You need to buy it.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question