Re: Oracle Client Tools

Hi Frank

I'm now about to download the full client, and then I'll take it from there. I might be able to use the ODBC driver, but I just don't know how to set it up. The descriptions I've found, tells me to install the Oracle Client tools and SQL*Net and then from the Oracle tools setup an SQL*NEt Alias for my Oracle server/database. Then I can set up a linked server in Ms SQL using the alias specified.
There might be other ways of doing it, but I simply can't find it anywhere.

Regards
Steen

Frank van Bortel wrote:
> Steen Persson wrote:
>> Hi Frank
>>
>> I think I'm still missing some client components. I have to admit
>> that I know next to nothing about Oracle and their terms, but as I
>> understand, I need to install an Oracle Client on my MS SQL Server
>> and then add a 'SQL*Net alias for Oracle database'. By installing
>> the files you directed me to, it only seems to install an ODBC
>> driver and that's it. Actually I could only install from the ODBC
>> downloaded files - the 33 Mb file didn't contain any file(s) that
>> could be executed (..or maybe I'm missing something).
>> I'm sorry if I sound dumb, but I'm really confused about what files
>> to get - and where to get them from.
>>
>> /Steen
>>
>
> My bad - I assumed you would need/use an ODBC driver...
> If you want the SQL*Net network stack (the SQL*Net alias
> stuff comes with that), you would need the full package.
>
> But then what? SQL Server supports SQL*Net now?
>
> (BTW, tried to configure the Instant Client ODBC,
> no dice...)
Received on Thu Mar 03 2005 - 09:21:15 CST