Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!t-online.de!news.tele.dk!not-for-mail From: "Steen Persson" Newsgroups: comp.databases.oracle.server References: <4226ce73$0$257$edfadb0f@dread12.news.tele.dk> <4226fa1a$0$209$edfadb0f@dread12.news.tele.dk> <4227175b$0$212$edfadb0f@dread12.news.tele.dk> Subject: Re: Oracle Client Tools Date: Thu, 3 Mar 2005 16:21:15 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1437 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Lines: 41 Message-ID: <42272b71$0$243$edfadb0f@dread12.news.tele.dk> Organization: TDC Totalloesninger NNTP-Posting-Host: 213.173.238.82 X-Trace: 1109863281 dread12.news.tele.dk 243 213.173.238.82:21070 X-Complaints-To: abuse@post.tele.dk Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:237365 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...)