Results 1 to 5 of 5

Thread: linked server-fetching the table

  1. #1
    Join Date
    Feb 2009
    Posts
    9

    linked server-fetching the table

    Hi ,
    I created the linked server through GUI in sql server 2005 as
    Linked server-> TEST_LNK
    SErver type-> Other data source
    Provider-> Oracle Provider for OLE DB
    Product Name -> Oracle
    Datasource -> PASDW/oracle Express Edition
    Provider string ->Microsoft OLE DB

    And Security Tab
    details are given for local login/ Remoteruser/pwd and the be madeusing the
    login's current security context

    and the SErver options tab
    the first 5 are set to true and last 2 are set to 0.

    And When I tried to EXEC the same as follows, I am getting the Error


    select * from openquery (TEST_LNK,'select * from [ASUP_HDD].[dbo].[t_scsi_cmd_checkCondition]')

    ERR:


    OLE DB provider "MSDAORA" for linked server "TEST_LNK" returned message "ORA-12154: TNS:could not resolve the connect identifier specified
    ".
    Msg 7303, Level 16, State 1, Line 1
    Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "TEST_LNK".

    Waiting for the reply as I am new to sql server.I need to check out the table which is oracle db through the linked server,whetehr it's posible?
    And whether i need to give any username/pwd to map the orcle db?
    Please le tme know...

    Thanks and REgards,
    Sowmya

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Tried this?

    select * from openquery (TEST_LNK,'select * from [t_scsi_cmd_checkCondition]')

  3. #3
    Join Date
    Feb 2009
    Posts
    9

    Re

    Hi,
    When I tried , I got the Err as

    OLE DB provider "MSDAORA" for linked server "TEST_LNK_SRV" returned message "ORA-01004: default username feature not supported; logon denied
    ".
    Msg 7399, Level 16, State 1, Line 1
    The OLE DB provider "MSDAORA" for linked server "TEST_LNK_SRV" reported an error. Authentication failed.
    Msg 7303, Level 16, State 1, Line 1
    Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "TEST_LNK_SRV".


    Actually, I don't understand the prob.
    I am not able to fetch the oracle tables through the created linked server, which i Need.....
    It would be of very great help if you can provide some suggestion for the same.

    Thanks,
    Sowmya

  4. #4
    Join Date
    Feb 2009
    Posts
    9
    I created a new linked server name TEST_LNK_SRV,
    That why I changed the query as
    select * from openquery (TEST_LNK_SRV,'select * from [t_scsi_cmd_checkCondition]') .....
    which gave me the error as stated above...
    Thnks,
    Sowmya

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    What's linked server name? You use different name in your query?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •