October 24, 2003 at 5:57 am
Is there a way to create a Linked Server to Oracle without utilizing SQLNet? I was hoping there would be a way similar to one can create a Linked Server to another SQL Server using ODBC specifying provider_string. Example: sp_addlinkedserver 'SQLPubs', ' ', 'MSDASQL', NULL, NULL,'Driver={SQL Server};Database=pubs;Server=SalesSvr;UID=sa;PWD=sapassword;'
In other words, imbed the call to Oracle without using SQLNet.
October 24, 2003 at 7:02 am
Hi,
I have to load the SQLNet Oracle client on the Server. There is no other way.
If it aint broke don't fix it!
Andy.
October 27, 2003 at 3:06 am
If I remember my Oracle right (and it's been a year or two!), even when you use ODBC to connect to Oracle, it just sits as an extra layer on top of SQLNet, so you still need the SQLNet client installed.
It's just what we asked for but not what we want! (The Customer's Creed)
Dave Leathem.
It's just what we asked for but not what we want! (The Customer's Creed)
October 27, 2003 at 7:14 am
SQL*Net or Net8 provides the basic libraries enabling applications (whatsoever) to access oracle databases on da data stream level.
* You won't be able to talk to Oracle without those libraries *
same with SQL server, normally some app just provides the lib needed by default (NTWDBLIB.DLL).
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply