Greetings all,

I'm unsuccessfully trying to create a linked server from SQL Server
2005 to Oracle 9i using OraOLEDB.Oracle.  Here's the lovely error
message that I get:

OLE DB provider "OraOLEDB.Oracle" for linked server "test" returned
message "ORA-12504: TNS:listener was not given the SERVICE_NAME in
CONNECT_DATA".

I am able to connect via SQL*PLUS, no problem.

In the Linked Server dialog box I have these entries:

Provider:  Oracle Provider for OLE DB
Product Name:  Oracle
Data Source: MILAB.WINDSORLOCKS.AHLSTROM.COM
Provider String:  "  "

Here's the TNSNAMES entry:

MILAB.WINDSORLOCKS.AHLSTROM.COM =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(HOST =
10.1.0.237)(PORT = 1522))
   )
   (CONNECT_DATA =
     (SID = milab)
   )
 )

Here's the SQLNET entry:

NAMES.DEFAULT_DOMAIN = adagnet.net
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)

HELP is greatly appreciated.

Thanks,

BK