Re: Linked Server

From: Patricia Howe (anonymous_at_discussions.microsoft.com)
Date: 08/11/04 

Date: Wed, 11 Aug 2004 06:29:45 -0700

Thanks for the replay Wayne

Patricia

>-----Original Message-----
>Do sp_helpserver to see if it is listed... Or use SEM
under linked servers,
>Go to the last tab, and make sure data access is
selected...If you do not
>find the server at all (in sysservers)... re-add the
linked server.
>
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>
>"Patricia Howe" <anonymous@discussions.microsoft.com>
wrote in message
>news:408601c47f7e$f4d800a0$a401280a@phx.gbl...
>> I have the following queries...
>>
>> sp_addlinkedserver N'ExcelTest', N'Jet 4.0',
>> N'Microsoft.Jet.OLEDB.4.0',
>> N'c:\Test.xls', NULL, N'Excel 5.0'
>> go
>>
>> SELECT *
>> FROM OPENQUERY(ExcelTest,
>> 'SELECT * FROM SCOPE('' "c:\SaraLee.XLS" '')')
>>
>> When executed gives
>> Server: Msg 7202, Level 11, State 2, Line 4
>> Could not find server 'ExcelTest' in sysservers. Execute
>> sp_addlinkedserver to add the server to sysservers.
>>
>> Can anyone tell me why ?
>>
>
>
>.
>

Relevant Pages

  • Re: Dynamic SQL generation is not supported against a SelectCommand that does not return any base ta
    ... When you execute Update (for the first ... UpdateCommand etc. See my article on the CommandBuilder and why it should be ... SQL Server or MS Access. ... Code works fine with MS SQL Server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: E-Mail Nachricht an Operator
    ... Man kann ja mit dem SQL Server ... SQL Server-Agent / Operatoren ... EXECUTE msdb.dbo.sysmail_add_account_sp ...
    (microsoft.public.de.sqlserver)
  • Re: Error running sql command
    ... If the commands are in a table on the server, I would create strings on the server and use SQL EXECUTE to execute them... ... I fetch a command from a table, process it and if command executes successfully I delete it form the queue. ... The basic problem with your code is that you are not using SQL Server as it should be used. ...
    (microsoft.public.dotnet.framework.adonet)
  • it all started on 5/27....
    ... individual DTS packages on SQL Server 2000 SP 4 that import and convert ... The SQL lives on a separate server than Pervasive. ... the same machine as SQL Server 2K SP 4. ... Now, if I execute the DTS packages individually on the server, all ...
    (microsoft.public.sqlserver.dts)
  • Re: Executing DTS from Code (correction)
    ... Granting execute permissions on these procs means that external Com objects can be called etc. ... If they run in-process and crash then bye-bye SQL Server. ... I moved the DTS package to the production server and>>> installed the application on the production server. ...
    (microsoft.public.sqlserver.dts)