Re: Connecting to FoxPro data

Hi Julian,

Since you want to "mix" the Fox tables with the SQL tables it sounds like
what you need is a linked server.

Here's some of what I've posted:
http://groups.google.com/group/microsoft.public.fox.vfp.queries-sql/browse_thread/thread/bc3286cf3cf25b64/3300fe71db9bb97e?lnk=st&q=Linked+Server+Northwind+author%3ACindy+author%3AWinegarden&rnum=3&hl=en#3300fe71db9bb97e

Note that when you select data from a VFP linked server you need the three
dots:

Select SQLTable.* From SQLServerTable As SQLTable
Inner Join FoxLinkedServer...Customers As Customers
On SQLTable.ID = Customers.CustomerID

Also, the data source string in the example is for a FoxPro DBC or "database
container." For free tables you just point to the directory where they are
located:
@datasrc=N'"C:\Temp\"'

Offhand I don't know how you would make the linked server read-only -
perhaps by making a view of the data and letting the users have read-only
access to the view. A SQL Pass-through query is always read-only but if you
want users to use something like MS Access for querying and reports then an
SPT query wouldn't work.


--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@xxxxxxxxxxxxxxxxxxx


"stjulian" <stjulian@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ONBfsyqqGHA.2232@xxxxxxxxxxxxxxxxxxxxxxx
I was given this one. Right now I am familiar with how to do this in
Access, but SQL Server is what I need to use.

What does one have to do to connect SQL Server (right now 2000, but soon
2005) to a FoxPro free-table directory?

I would like to have this be a READ-ONLY data source as I do not want to
allow this data/indexes to be updated or modified in any way.

And, can these tables be mixed in with the SQL data tables in the same SQL
database? If not, how can a table in another database (this FoxPro
database) be referenced in T-SQL?

I'm willing to read, you can give links.

Thank you,
Julian



.

Relevant Pages

  • Re: Setting up Linked server to MsAccess
    ... I'm running SQL Server\Express in "Windows Authenication Mode" (Do I have to ... they are accessing my MS Access linked server? ... Containing folders with MSAccess Database X.mdb ... SQl Express has linked server X mapped via UNC to Database X.mdb ...
    (microsoft.public.sqlserver.security)
  • DBConvert for FoxPro & MSSQL 2.0.2
    ... DBConvert for MS FoxPro & MS SQL is a database migration tool for data ... Unicode Support, Primary keys and Indexes conversion, ...
    (comp.software.shareware.announce)
  • Re: Optimizing remote views to SQL 2k
    ... now what I have to do is convert an existing foxpro application that I ... learn foxpro / dbf and use my SQL knowledge to optimize it! ... but it took me 2 weeks to find how to open a database in foxpro!! ... Look up "Parameterized Remote Views" in the help file. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: SQL update in SQL database issue
    ... I am thinking if i change the database from Foxpro to SQL or MS Access, ... program installation require, if a table corrupted, user can just attach ...
    (microsoft.public.fox.programmer.exchange)
  • Linked Server Access Problems
    ... I have recently struggled with granting access to a linked server ... The SQL Server service was running ... database was linked using a named path, ... I experimented with various linkedsvrlogins ...
    (microsoft.public.sqlserver.security)