Re: Accessing heterogenous data from Oracle/AIX

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 28 Sep 2005 07:24:09 -0700
Message-ID: <1127917449.717680.215430@z14g2000cwz.googlegroups.com>

I sort of doubt that any vendor has written an AIX ODBC module to connect to TDS. I do not ever remember hearing about the TDS database product before your post.

Here are some ideas

1- write your own ODBC driver
2- if the TDS db is small upload the data to Oracle
3- write socket programs that talk to each other, one to run on each

platform, and interface it to Oracle using the external procedure feature
4- if TDS supports java then you should be able to write a java program that runs on AIX that can access both databases

HTH -- Mark D Powell -- Received on Wed Sep 28 2005 - 09:24:09 CDT