Creating an ODBC linked server in SQL2005

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • KEMoore
    New Member
    • Jan 2008
    • 6
    #1

    Creating an ODBC linked server in SQL2005

    I am trying to read data located on an ODBC box.
    I have multiple queries built in SQL2005. Now I just need to be able to access this data from the ODBC server in the SQL2005.
    I have tried to create a linked sever and failed miserably.
    I have an ODBC connection set up on my machine with the following settings:
    Data Source Name: MSXXXP1
    Description: Client data source
    Server Name: tcp:XXX.XXX.XXX .XXX.XXXX
    ServerDSN: MSXXXP1


    Any help is greatly appreciated.
    Tags: None
    • ck9663
      Recognized Expert Specialist
      • Jun 2007
      • 2878
      #2
      Originally posted by KEMoore
      I am trying to read data located on an ODBC box.
      I have multiple queries built in SQL2005. Now I just need to be able to access this data from the ODBC server in the SQL2005.
      I have tried to create a linked sever and failed miserably.
      I have an ODBC connection set up on my machine with the following settings:
      Data Source Name: MSXXXP1
      Description: Client data source
      Server Name: tcp:XXX.XXX.XXX .XXX.XXXX
      ServerDSN: MSXXXP1


      Any help is greatly appreciated.
      From your ODBC server, can you access your SQL Server? Post what have you done so far.

      -- CK

        Comment

        • KEMoore
          New Member
          • Jan 2008
          • 6
          #3
          Originally posted by ck9663
          From your ODBC server, can you access your SQL Server? Post what have you done so far.

          -- CK
          Thank you for the response.
          The ODBC sever is tricky. It's a Linux box and I have not been able to connect it to SQL yet. Thats what I would like to do, is create a linked server between the two. The only way that I've found I'm able to pull data out of the ODBC is using SQL 2000 DTS export.

            Comment

            • sujitkar
              New Member
              • Mar 2009
              • 7
              #4
              Linked Server for ODBC data source

              Hi friends,
              I am using SQL Server 2005.

              I have an MS-Access database which is protected by MDW file. Through shortcut (specifying the workgroup) only, I can open that database file(MDB). Now I have created an ODBC to that database. I have checked the ODBC in excel 2007. it works nicely there. But when I am trying to use it in the Linked Server in SQL Server, it doesnot work. Actually I dont know whether it works or not. when I am trying to fetch the record using <LINKED_SERVER_ NAME>...<TABLE_ NAME>, it gives the following error message-

              "An invalid schema or catalog was specified for the provider MSDASQL for Linked Server <LINKED_SERVER_ NAME>

                Comment

                Previous template Next
                Working...