Post reply

Linked Server to Ctree

  • March 18, 2010 at 9:27 am

    #230978

    I am trying to add a Ctree database to SQL 2005. I have the odbc dsn set up and it works with Access.

    SQL Server allows me to set up the link, but when I try to open it, I get "Cannot obtain the schema rowset "DBSCHEMA_CATALOGS" for OLE DB provider "SQL Server" for linked server "(null)". The provider supports the interface, but returns a failure code when it is used. Error: 7311"

    When I test the connection, it returns successfully. I belive the problem is with the Catalog parameter, but I don't know what that would be for a Ctree database.

    Has anyone successfully linked a Ctree database? and if so, how?

  • March 30, 2010 at 2:50 pm

    #1142717

    Don't think the Oracle section of the forum is the right place for this question.

    I would consider opening a ticket with FairCom.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply