XPost: microsoft.public.sqlserver.programming   
   From: genew@ocis.net   
      
   On Sat, 12 Mar 2011 13:00:16 +0100, Erland Sommarskog   
    wrote:   
      
   >Gene Wirchenko (genew@ocis.net) writes:   
   >>   
   >>      The subject about says it all.  How do I do this?   
   >>   
   >>      My SQL Server 2008 Express system is LOOP\SQLEXPRESS.   
   >>   
   >>      Apparently, I should create an ODBC connection.  I have no idea   
   >> how to do this.   
   >>   
   >>      If you only know the SQL Server side, please reply with that   
   >> side.  That is more than what I know.   
   >   
   >You use sp_addlinkedserver to define a linked server. If authentication   
   >is requireed, you may also need to set up login mapping with   
   >sp_addlinkedsrvlogin.   
   >   
   >Once you have this set up, you can query the FoxPro database using   
   >four-part notation, for instance "SELECT * FROM SERVER.db..tbl".   
      
        I want to query *from* VFP *to* SQL Server.   
      
        (Why is it that so many people do not read the title of posts?   
   Why is it that I forgot this?)   
      
   >If there is an OLE DB provider for Foxpro, use that one. Else you can   
   >use the MSDASQL provider - that is OLE DB over ODBC - and any the ODBC   
   >driver for Foxpro there might be.   
   >   
   >I suspect that Google can be helpful.   
      
        No.  I do not know enough to know what to look for, so it just   
   gets me swamped.   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)