Sexton,
We had to do the same thing and we couldn't get HS to work on our Solaris server using HS/ODBC since it's only for linking to DB's like MySQL or mSQL not MSSQL since there is a gateway client. We ended up installing Oracle on a separate Windows server using Transparent Gateway for MSSQL. We then created the DB Link to the MS SQL Server and from there created a DB link from the Solaris box to the Oracle Windows server. Since we used Oracle 10g, it was bear getting the syntax just right in the tnsnames.ora and listener.ora files and we also used a mix of documents to get the end result but it's now working slick. You would think it would be a piece of cake...and if anyone knows a better way please let us know..
-----Original Message-----
From: Sexton Michael
[mailto:oracledba-ezmlmshield-x67351412.[Email address protected]
Sent: Thursday, September 08, 2005 10:43 AM
To: LazyDBA Discussion
Subject: RE: Oracle database connection to sql server
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
--------
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