Database link between MSSQL and DB2

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Blingo
    New Member
    • Oct 2013
    • 2
    #1

    Database link between MSSQL and DB2

    Which options do i have to create a database link between MSSQL and DB2 to use sql-functions like a view...
    Tags: None
    • ck9663
      Recognized Expert Specialist
      • Jun 2007
      • 2878
      #2
      Are you connecting from DB2 to SQL Server or the other way around?

      ~~ CK

        Comment

        • Blingo
          New Member
          • Oct 2013
          • 2
          #3
          I now used the Microsoft OLE DB Provider for DB2.
          When i run the Connection test everything is quite good but when i want to see the tables i get this error:

          Cannot fetch a row from OLE DB provider "SQL Server" for linked server "(null)". (Microsoft SQl Server, Error 7330)

          can someone help me how to solve this problem?

            Comment

            Previous template Next
            Working...