Linked server to DB2 won't show catalogs

• SQLHeap

  Hall of Fame

  Points: 3572

  More actions

  October 1, 2013 at 12:02 pm

  #283343

  I have created the ODBC connection within the IBM Configuration Assistant, then created the linked server to the DB2 database. The connection tests successfully, but I can't see the catalog for the DB2 database. Any ideas?

  There is an exception to every rule, except this one...

• Super Cat

  SSCertifiable

  Points: 7332

  More actions

  October 3, 2013 at 3:56 am

  #1655481

  Does the account that is making the connection have access to the dbs on the remote server?