Mark A Matte
markamatte at hotmail.com
Wed May 5 13:37:20 CDT 2010
Nice article Susan... I link to Informix and Teradata from SQL Server... I typically use 1 of 2 options for queries: --Pass-through Syntax Select * from OPENQUERY(CCMS, 'Select case_ID from ps_rc_case_note nt where nt.case_id=1') --A 4 part naming convention (DO NOT USE UNLESS NECESSARY-pulls all data locally then applies where clause) Select case_ID from CCMS.ccnc_rep.informix.ps_rc_case_note where case_id='1' > Date: Tue, 4 May 2010 08:16:13 +0200 > From: Gustav at cactus.dk > To: accessd at databaseadvisors.com > Subject: Re: [AccessD] SQL Server Linked Servers Post > > Hi Ken (and Susan) > > Nice finding! That explains it very well. > > The only topic missing is how to link an mdb file shared - not exclusively - meaning that it may already be opened by another process, typically an Access frontend, and even though SQL Server will be able to at least read the mdb file. > Yes, you need to specify the workgroup file's full path (it is specified but not explained how to do this in the BOL), but I have yet to get this to work as expected. > > /gustav > > >>> kismert at gmail.com 03-05-2010 23:42 >>> > Susan, > > A shout out for your excellent post: > > How do I... Query foreign data using SQL Server's linked servers? > http://blogs.techrepublic.com.com/datacenter/?p=133 > > Simple and useful, unlike the impenetrable Microsoft help on the subject. > > Thanks, > -Ken > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com _________________________________________________________________ Hotmail is redefining busy with tools for the New Busy. Get more from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2