Not sure what you are trying to do. Might you be better off passing
datasets between the two systems with ADO.net?


Kindest Regards
Michael Sexton
Database Administrator
AIR - Worldwide
+1-617-954-1820
[Email address protected]
131 Dartmouth Street
Boston, MA 02116
-----Original Message-----
From: Reedus Design SL - Jason Reed
[mailto:oracledba-ezmlmshield-x22129671.[Email address protected]
Sent: Thursday, September 08, 2005 9:30 AM
To: LazyDBA Discussion
Subject: Oracle database connection to sql server

I am trying to get Oracle 9i to talk to Sql Server (which is on another
office) without much success.



I have tried following the many tutorials on heterogeneous Services ODBC
agent. but they seem geared for oracle speaking to Sql server on the
same
machine.



Any bright sparks that can point me in the right direction??



I am more of a developer than a dba so please make it easy to follow..



Thanks in advance.

Jason





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page