Re: Linked Server and Verify Connection

From: Steve Kass (skass_at_drew.edu)
Date: 07/01/04

  • Next message: Anith Sen: "Re: Error using QA" 
    Date: Thu, 01 Jul 2004 14:46:12 -0400

    Matt,

      When you add a linked server, you do not make a connection, but
    instead just provide the details needed so a connection can be made to
    execute a query that refers to the linked server. Basically there is no
    "open a connection for the code that follows" statement in SQL. I'm not
    quite sure why you would want to add a linked server within a stored
    procedure - do you drop the linked server in that procedure as well, so
    that repeated calls to the procedure won't try to create an existing
    linked server?

      It would help if you could give more information about what you are
    trying to accomplish.

    Steve Kass
    Drew University

    Matt Tapia wrote:

    >I am adding a linked server to another SQL server within a stored procedure.
    >I need to verify the link was made before I start running any more code. How
    >can I verify that I have connected successfully to the linked server?
    >
    >
    >
    >

  • Next message: Anith Sen: "Re: Error using QA"

    Relevant Pages

    • MS SQL 2005 to Sybase via Linked server
      ... I'm having an issue setting up a linked server connection on a new SQL 2005 ... The connection is working on the existing sql 2000 box. ... I enter all the sybase server info and use the "Test ...
      (microsoft.public.sqlserver.odbc)
    • Transaction with linked server
      ... When I open transaction with insert statement from linked server and that ... When I kill connection it ... transaction or kill connection without restarting? ... (MySQLServerColumn) ...
      (microsoft.public.sqlserver.programming)
    • Re: Link Server
      ... I was trying to use a connection is the DTS packages, ... But it sounds like I have to write out the sql code in order to connect. ... >> I'm not sure what connection to use and how to set it up. ... > do you mean a linked server is defined on your SQL Server? ...
      (microsoft.public.sqlserver.dts)
    • Re: MSDASQL headache
      ... The DSN used to create the linked server on SQL ... connected using credentials on the Progress database. ... ASP.NET connection string. ...
      (comp.databases.ms-sqlserver)
    • RE: Linked Server Problem
      ... values for these without success. ... view that I am trying to execute, ... the access project causing it to lose track of its ... >> I have a view to a table in a linked server (an Access ...
      (microsoft.public.access.adp.sqlserver)