-- To use named parameters:
EXEC sp_addlinkedserver
@.server = 'LONDON Payroll',
@.provider = 'MSDASQL',
@.provstr = 'DRIVER={SQL
Server};SERVER=MyServer;UID=sa;PWD=;'
GO
Is there anything different to link to SQL2005? How can
create a link to 2005?
Thx.Probably better to post this question in the SQL Server 2005 groups?
http://www.aspfaq.com/
(Reverse address to reply.)
"C TO" <anonymous@.discussions.microsoft.com> wrote in message
news:98cc01c478b5$b0382620$a301280a@.phx.gbl...
> -- To use named parameters:
> EXEC sp_addlinkedserver
> @.server = 'LONDON Payroll',
> @.provider = 'MSDASQL',
> @.provstr = 'DRIVER={SQL
> Server};SERVER=MyServer;UID=sa;PWD=;'
> GO
> Is there anything different to link to SQL2005? How can
> create a link to 2005?
> Thx.
>
Tuesday, March 27, 2012
addlinkedserver to 2005
Labels:
addlinkedserver,
database,
london,
microsoft,
msdasql,
mysql,
named,
oracle,
parametersexec,
payroll,
provider,
provstr,
server,
sp_addlinkedserverserver,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment