SQL Server Performance

Linked Server

Discussion in 'SQL Server DTS-Related Questions' started by Reddy, Aug 10, 2005.

  1. Reddy New Member

    I have a linked server with product name as Oracle(OLE DB data source), when trying to import data from that server I am unable to connect from DTS to the source database. I am using "MS OLEDB provider for Oracle" while connecting. Am I in the right track? is there anything I am missing.

    Thanks!
    "He laughs best who laughs last"

  2. Reddy New Member

    Any help?

    Thanks!
    "He laughs best who laughs last"

  3. DBA_Newbie New Member

    Hi,

    It shouldnt be a problem. I have done this before and never faced any issues. I hope you have the required entries in your tnsnames.ora file. Please try connecting from the command prompt to your oracle database and confirm the connection. Alternatively you can also use tnsping to check the same.

    Hope this helps.
  4. satya Moderator

    http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0,295199,sid63_gci980063,00.html

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. Reddy New Member

    Hi
    I am unable to connect to Oracle DB through DTS, not sure whats the problem.Can any one pls brief me how I have to import data from Oracle to sql server throug DTS. I am creating a DSN and trying to do this but not sure where I am wrong.However my Linked server is working fine.
    How does a linked server and DSN relate in migrating such things.

    Thanks!
    "He laughs best who laughs last"

  6. satya Moderator

    Check the link referred above that gives you clear explanation.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  7. FrankKalis Moderator

Share This Page