Solved

communicate odbcs driver

Posted on 2011-02-14
9
730 Views
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.
0
Comment
Question by:hussainkhan22
  • 4
  • 3
9 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
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:
http://download.oracle.com/docs/cd/E11882_01/server.112/e17120/ds_concepts001.htm
0
 

Author Comment

by:hussainkhan22
Comment Utility
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.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
>>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.
0
 

Author Comment

by:hussainkhan22
Comment Utility
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.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 76

Expert Comment

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

http://www.experts-exchange.com/Database/Oracle/Q_26819884.html

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

Author Comment

by:hussainkhan22
Comment Utility
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
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
Comment Utility
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.
0
 
LVL 61

Expert Comment

by:gheist
Comment Utility
Informix ODBC is a commercial product. You need to buy it.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

This article describes some very basic things about SQL Server filegroups.
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

763 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now