>Hi,
>
>I have been considering mixing a lan product (dbc, foxpro tables) and MsSQL server in the code.. I wonder if anyone has any suggestions - like "are you nuts" or " I did it and it's easy". I was thinking I could use the same DBC and just add the remote_views. At first this sounded OK but then I thought I could just create a second DBC just for the remote_views. The code that would use the MsSQL will (90%) of the time only read the fox tables. Any help or suggestions?
>
>Thanks in Advance
>
>John
It certainly can be done. I use a combination of VFP free tables, DBCs and SQL Server tables, accessed directly via SQLEXEC, not remote views, in lots of different applications.