Post reply

Invalid schema or catalog specified for provider SQLOLEDB

  • April 22, 2004 at 8:03 pm

    #82737

    Howdy hoping someone can help me.

    I am attempting to do a select statement

    select * from [servername].databasename.dbo.customer.

     

    I have recreated the link  server but I am still getting the same message?

    Server: Msg 7313, Level 16, State 1, Line 1

    Invalid schema or catalog specified for provider 'SQLOLEDB'.

     

    BTW this is a new database.

    Any ideas would be appreciated!

     

     

  • April 23, 2004 at 7:16 pm

    #504110

    What version is the SQL Server and what db type and version is the remote source?

  • April 25, 2004 at 5:52 pm

    #504161

    SQL Server 2000 sp3a on both machines.

    I managed to get around this problem by renaming the database.

     

    Cheers

  • April 25, 2004 at 5:52 pm

    #504160

    SQL Server 2000 sp3a on both machines.

    I managed to get around this problem by renaming the database.

     

    Cheers

  • July 13, 2004 at 8:07 am

    #514399

    Hi,

    I am getting the same error 'Invalid schema or catalog specified for provider SQLOLEDB' when i am trying to declare a cursor on remote procedure which is being called by Java ODBC driver.

    Can anyone help me out.

    Thanks & Regards,

    Himanshu

Viewing 5 posts - 1 through 4 (of 4 total)

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