Post reply

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

  • July 13, 2004 at 8:52 am

    #108560

    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

  • July 13, 2004 at 9:24 am

    #514415

    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