Solved

Create sp_addlinkedserver  code for sql server 2005 express

Posted on 2010-09-22
2
1,170 Views
Last Modified: 2012-05-10
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
Comment
Question by:fordraiders
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 26

Accepted Solution

by:
tigin44 earned 500 total points
ID: 33735702
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
 
LVL 3

Author Closing Comment

by:fordraiders
ID: 33735783
Thanks
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question