Re: Connecting to SQL Server from Oracle
From: Nilo Segura <nilosegura_at_gmail.com>
Date: Sun, 11 Dec 2022 09:32:05 +0100
Message-Id: <9CB3B325-D5B3-4C15-9647-40A3E4474058_at_gmail.com>
> --
> Best regards/Venlig hilsen
>
> Peter Gram
> Sæbyholmsvej 18 DK-2500 Valby
>
> Mobile: (+45) 5374 7107
> Email: peter.m.gram_at_gmail.com
>
Date: Sun, 11 Dec 2022 09:32:05 +0100
Message-Id: <9CB3B325-D5B3-4C15-9647-40A3E4474058_at_gmail.com>
I have a vague memory from a reply in this list about loading an sql server jdbc driver in the oracle JVM in the DB…
Broadcasting from an undisclosed location....
> On 11 Dec 2022, at 05:48, Peter Gram <peter.m.gram_at_gmail.com> wrote:
>
>
> Hi
>
> Oracle heterogeneous odbc to Ms SQL server is free with a Oracle database license. The odbc is not as advanced as the gateway but works fine.
> Have a look in the Oracle database license guide.
>
> Gram/
>
>> On Sun, 11 Dec 2022 at 05.27, Hameed, Amir <amir.hameed_at_sleepnumber.com> wrote: >> Hi, >> >> Is there a way to establish a connection from Oracle to SQL Server without using the Oracle Gateway? We have a requirement to pull data from SQL Server and into Oracle only once a month and we don’t want to spend money on licensing Oracle Gateway. The OS platform is for Oracle Solaris. >> >> >> >> Thank you, >> >> Amir >> >> >>
> --
> Best regards/Venlig hilsen
>
> Peter Gram
> Sæbyholmsvej 18 DK-2500 Valby
>
> Mobile: (+45) 5374 7107
> Email: peter.m.gram_at_gmail.com
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Dec 11 2022 - 09:32:05 CET