dbTalk Databases Forums  

Re: Specifying a Linked Server in EM.

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools Re: Specifying a Linked Server in EM.

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Re: Specifying a Linked Server in EM. in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
David Penney
 
Posts: n/a

Default Re: Specifying a Linked Server in EM. - 07-05-2003 , 06:09 PM





John,
I would be interested in how you find performance.

Regards,
David Penney
www.metamatrix.com
"John Peterson" <johnp (AT) azstarnet (DOT) com> wrote

Quote:
(SQL Server 2000, SP3)

Hello, all!

I'm trying to specify a Linked Server to another SQL Server machine using
the Microsoft
OLE DB Provider for ODBC. I'm wondering if I can put the ODBC connection
string
somewhere, in lieu of having a ODBC System DSN specified on the local
server? If so, what
would I make that connection string look like (particularly the "Provider"
section)?

Thanks!

John Peterson



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top