Results 1 to 2 of 2

Thread: linked server

  1. #1
    Join Date
    Apr 2004
    Posts
    3

    Unanswered: linked server

    i am able to query linked server using openquery
    but when i try to access table directly it give error

    Server: Msg 7313, Level 16, State 1, Line 1
    Invalid schema or catalog specified for provider 'SQLOLEDB'.


    i am connecting as sa so security is not an issue

    also all othere database from linked server are working this is new database which i attached

    sanjit

  2. #2
    Join Date
    Apr 2004
    Location
    kansas city, missouri
    Posts
    1

    Re: linked server

    some thoughts. I like to use domain accounts that have been registered across the linked servers. Otherwise, some ports can be blocked on the linked server.
    Originally posted by sanjit
    i am able to query linked server using openquery
    but when i try to access table directly it give error

    Server: Msg 7313, Level 16, State 1, Line 1
    Invalid schema or catalog specified for provider 'SQLOLEDB'.


    i am connecting as sa so security is not an issue

    also all othere database from linked server are working this is new database which i attached

    sanjit

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •