Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
New Web Server Setup
Message
From
28/04/2005 20:57:10
 
 
To
28/04/2005 08:59:09
Todd Wolfe
Certified Marketing Services
Kinderhook, New York, United States
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
FoxPro Windows
OS:
Windows Server 2003
Miscellaneous
Thread ID:
01008889
Message ID:
01009510
Views:
15
You can use LINK Server of SQL Server. This allow Fox DB to be like part of SQL Server then You can now query FoxDb via TCP/IP or SQL name Piple.The most benefits is you are using Client/Server not the File Sharing Approach just like sharing Folder.In case you only pass SQL Command to the network and get the result. By then you can now easy integrate it to your web.
EXEC sp_addlinkedserver
  'FOXDB',
   '',
   'VFPOLEDB.1',
   'D:\nosij\vinstron\MIS\Data\mis.dbc',
   NULL,
   'VFPOLEDB.1'
To Execute Query
Select *
 from FOXDB...Sales
Hope this will help
Roses are #FF0000 Violets are #0000FF all my base are belong to you
Previous
Reply
Map
View

Click here to load this message in the networking platform