XPost: microsoft.public.sqlserver.programming   
   From: esquel@sommarskog.se   
      
   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".   
      
   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.   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)