Re: Database Links - ODBC driver

Hi Tony

It is indeed possible to connect using the scenario you mention. Personally, I've got a connection with this method using Linux and a colleague has done so using another Unix platform. Provided you have the necessary Heterogeneous Services installed on your Oracle Client/Server you can connect using ODBC to your SQL Server database.

We provide a TDS driver for connecting to your SQLServer database and this simply gets mapped into your HS setup. A trial version can be downloaded from www.openlinksw.com or www.openlinksw.co.uk

We do have branches of BT, recent acquisitions from BT Ignite spring to mind, who use our Drivers.

HTH
Emmon Simbo
OpenLink Software

"Tony Baker" <tony.ag.baker_at_bt.com> wrote in message news:<b1o1kk$4np$1_at_pheidippides.axion.bt.co.uk>...
> I want to create a database link from Oracle 9.2.0 to Microsoft SQL Server.
> I know this can and has been done on when Oracle is installed on an NT box.
>
> Has anyone been able to do where Oracle runs on a Sun Solaris or any Unix
> environment?
>
> Searching through metalink it looks as though a third party ODBC driver is
> needed.
> http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
> ase_id=NOT&p_id=213928.1
>
> The following companies are a sample of companies that provide ODBC drivers
> for Oracle on UNIX platforms: - InterSolv/Merant ( http://www.merant.com ) -
> OpenLink ( http://www.openlinksw.com ) - EasySoft (http://www.easysoft.com).
> Does anyone know if BT has a licence agreement with any of these or any
> other companies for ODBC drivers for Unix platform?
Received on Wed Feb 05 2003 - 09:48:46 CST