Solved

communicate odbcs driver

Posted on 2011-02-14
9
732 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)
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:
http://download.oracle.com/docs/cd/E11882_01/server.112/e17120/ds_concepts001.htm
0
 

Author Comment

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

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.
0
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.

 

Author Comment

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

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34898958
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
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
0
 
LVL 76

Accepted Solution

by:
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.
0
 
LVL 62

Expert Comment

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

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Latency in .net app using DB in .net 21 61
Steps to produce a data strategy 5 49
1 FROM DUAL wont work with additional columns ?? 4 36
create a nested synonym 4 25
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

786 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