March 18, 2010 at 9:27 am
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
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