Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1230
  • Last Modified:

Create sp_addlinkedserver code for sql server 2005 express

sql server 2005 express

Trying to get the following from below into  code to similiar to this:

exec sp_addlinkedserver @server='GpsFindMroData',
@srvproduct='Access',
@provider='Microsoft.Jet.OLEDB.4.0',
@datasrc='C:\Program Files\CrEn\Databases\mro.mdb'
go

But using the information below...

Thanks
fordraiders




Linked Server name :  LINKED_CHGO
Server Type : Other Data Source

server provider name: SQLNCLI

Product Name  :  RAYMOND

DATASOURCE:  PMTB04.campus.ggg.com

PROVIDER STRING: DSN=BMOnly;Description=PRODUCT db;UID=BMOnly;PWD=BMly;APP=Microsoft Office 2003;WSID=2CE942HWD1;DATABASE=CPIR_Product  


CATALOG: CPIR_Product

Open in new window

0
Fordraiders
Asked:
Fordraiders
1 Solution
 
tigin44Commented:
try this
USE [master]
GO
EXEC master.dbo.sp_addlinkedserver 
	@server = N'LINKED_CHGO', 
	@srvproduct=N'RAYMOND', 
	@provider=N'SQLNCLI10', 
	@datasrc=N'PMTB04.campus.ggg.com', 
	@provstr=N'DSN=BMOnly;Description=PRODUCT db;UID=BMOnly;PWD=BMly;APP=Microsoft Office 2003;WSID=2CE942HWD1;DATABASE=CPIR_Product', 
	@catalog=N'CPIR_Product'

GO

Open in new window

0
 
FordraidersAuthor Commented:
Thanks
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Tackle projects and never again get stuck behind a technical roadblock.
Join Now