Linked server

• sanjit

  Valued Member

  Points: 74

  More actions

  April 5, 2004 at 3:09 pm

  #152107

  created linked server

  works fine for other databases

  and then attached new database and when i try to run query on that database get error

  (not able to access any table from new database)

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

  Invalid schema or catalog specified for provider 'SQLOLEDB'.

  OLE DB error trace [Non-interface error: Invalid schema or catalog specified for the provider.].

  also if i use openqury it works fine

  sp_catalogs gives me database name

  sp_tables_ex gives me default database list if i select default database to new database i cam see all list od tables for new database

  but when i pass all parameters to sp_tables_ex like table name and all

  i get nothing

  i also try to drop and recreate the linked server but not working for this database

  also if i excute following command on table

  sp_columns_ex

  sp_indexes

  i can see the column name and index name for the table but not able to query

  what a stupid error msg not much of help from error message

  also couple of days back it was working fine suddenly we start getting this error

  any help will be Appreciated

  sanjit

• shoayb

  Say Hey Kid

  Points: 709

  More actions

  April 6, 2004 at 6:03 am

  #501844

  does the login you're using for the linked server connection have permissions on the new database?

  sho

• sanjit

  Valued Member

  Points: 74

  More actions

  April 6, 2004 at 7:00 am

  #501859

  It's a sa account so it's not a problem with securities

   

  sanjit