Try to contact the "Mainframe & Integration Technologies" group at Oracle and see what path that takes you. Also, have you tried to see if you can accomplish your goal by shooting the info from SQL server to a table in Oracle, then running a query against that table within Oracle? Did that make sense?
I picked the wrong week to stop sniffing glue! Regards, Satar --- Christopher Spence <[EMAIL PROTECTED]> wrote: > It is for something which won't have a huge budget > as the data is moving > over to Oracle eventually, but for now we want > access to it. I was thinking > about just building a java/perl replication engine > for now. It isn't a lot > of data. But if there was something pre-packaged it > would be nicer. > > I think the transparent gateway was dropped, either > way it is so expensive > and out of the range for such a small project. > > "Do not criticize someone until you walked a mile in > their shoes, that way > when you criticize them, you are a mile a way and > have their shoes." > > Christopher R. Spence > Oracle DBA > Phone: (978) 322-5744 > Fax: (707) 885-2275 > > Fuelspot > 73 Princeton Street > North, Chelmsford 01863 > > > > -----Original Message----- > Sent: Tuesday, October 02, 2001 4:55 PM > To: Multiple recipients of list ORACLE-L > > Hi Christopher, > > It can be done, Usually from third party software > companies. For example, Check out: > http://www.datamirror.com/products/tserver/ > > Back in the day (1996), Oracle had a "Mainframe & > Integration Technologies" group that handled such > problems. You might want to contact Oracle and see > if > such a group still exists and if they can provide > you > with a solution. > > Regards, > Satar > > > --- Christopher Spence <[EMAIL PROTECTED]> wrote: > > I know there is a way in SQL server to query > oracle > > tables, is there a way > > to do the reverse? > > > > I am looking at trying to create access from an > > Oracle DB to SQL Server data > > until we convert the SQL server database. > > > > Anyone have any ideas on this, I searched technet > > (ms/oracle) and metalink, > > as well as some search engines without luck. > > > > > > "Do not criticize someone until you walked a mile > in > > their shoes, that way > > when you criticize them, you are a mile a way and > > have their shoes." > > > > Christopher R. Spence > > Oracle DBA > > Phone: (978) 322-5744 > > Fax: (707) 885-2275 > > > > Fuelspot > > 73 Princeton Street > > North, Chelmsford 01863 > > > > > > > > > > __________________________________________________ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
