Linkserevr Sqlserver 2005 with Ingres ODBC Dsn

  • Hi All,

    In my server machine I have SQL-Server 2000 and SQL-Server 2005.

    I created Linkserever for Ingres database its connecting but not connecting to SQL Server 2005 Linked Server. Please help if any one crossed this issue. below the error message

    "THE OLE DB PROVIDER SQL SERVER FOR LINKED SERVER NULL REPORTED AN ERROR. ONE OR MORE ARGUMENTS WERE REPORTED INVALID BY THE PROVIDER.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"

    rajarajan.g@gmail.com

    Thanks

    Rajan

  • Hi,

    Have you solve your problem, I have the same problem ?

    Thanks for your answer.

  • Hi,

    I have a similar problem but I think I made it past what you were asking about. I have the connection working from sql2000 to ingres and am able to create a view of tables in ingres. Did you create vnodes on your sql server to allow the creation of the odbc system dsn?? Once I was able to create both of those I was able to create a linked server to ingres and then create views on sql server db's to the ingres tables.

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

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