Re: Connect from Oracle 8i/Solaris to MS SQL Server

From: Dave <davidr21_at_hotmail.com>
Date: 12 Mar 2004 11:17:48 -0800
Message-ID: <8244b794.0403121117.169131fb@posting.google.com>

"Victor A. Vostricow" <wsw_at_lipetsk.ru> wrote in message news:<c2ru2l$1urn$1_at_pluton.lipetsk.ru>...

I was able to do this before, but I was running Oracle on Windows. Oracle should provide a gateway for SQL Server which should allow you to configure the connection without installing any 3rd party drivers (ODBC). Perhaps you will have better luck with this.

Dave

> Hello all!
> I need to have access from Oracle 8i on Solaris 2.7 to MS SQLServer
2000. Seems to be than right way is to set up Oracle Heterogenious services via ODBC. But all my attempts doesn't produce any positive result. So I want to know - are anybody here doing such thing successfully? That are you using (what products and versions)? For your information, I tried to use both iODBC and unixODBC with FreeTDS. Received on Fri Mar 12 2004 - 13:17:48 CST