Urgent Help -Invalid schema or catalog specified for provider SQLOLEDB.

  • Hi,

    I am getting the subjected error while i am trying to declare a cursor to select some rows based on some condtion. This cusor is defined in a procedure on remote server and I am calling this procedure thru Java ODBC bridge.

    Please help me out of this problem.

    Thanks

    Himanshu

  • How do you define linked server? From EM --> Security --> Linked Server --> YourLinkedServer --> Tables will tell you the schema and catalog name if you are able to see those linked tables.

    Try in format "select * from linkedservername.catalogname.schemaname.tablename" to your linked server.

     

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

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