Solved

Create sp_addlinkedserver  code for sql server 2005 express

Posted on 2010-09-22
2
1,145 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
2 Comments
 
LVL 26

Accepted Solution

by:
tigin44 earned 500 total points
Comment Utility
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
Comment Utility
Thanks
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
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.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

762 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now