Re: Link Server

Yes I mean linked 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.

Thanks for your help.



"Helge C. Rutz" <news050424@xxxxxxxxxxxxxx> wrote in message
news:3fjqb8F8889cU1@xxxxxxxxxxxxxxxxx
> Hi,
>
> "news.microsoft.com" wrote:
>>I have a link server I'm trying to connect to in a DTS package.
>> I'm not sure what connection to use and how to set it up.
>> Any suggestions??
>
> do you mean a linked server is defined on your SQL Server?
> Generally DTS connects servers through dedicated connections and therefor
> doesn't use your linked server.
> So you can query the linked server in sql tasks as normal source.
> Or you define a connection object for that server and specify your
> connection parameters there.
>
> Can you clearify your question?
>
> Helge


.

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: Linked Server and Verify Connection
    ... instead just provide the details needed so a connection can be made to ... execute a query that refers to the linked server. ... >I need to verify the link was made before I start running any more code. ...
    (microsoft.public.sqlserver.mseq)
  • 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: how to mapped the ms access db data to ms sql server
    ... I have setup my linked server. ... and the connection is ok. ... but how can i programmatically use the ms sql in my asp.net page? ...
    (microsoft.public.sqlserver.odbc)