Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
New Web Server Setup
Message
De
28/04/2005 20:57:10
 
 
À
28/04/2005 08:59:09
Todd Wolfe
Certified Marketing Services
Kinderhook, New York, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
FoxPro Windows
OS:
Windows Server 2003
Divers
Thread ID:
01008889
Message ID:
01009510
Vues:
14
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform