communicate odbcs driver

Posted on 2011-02-14
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.
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!


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 500 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

628 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