Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to work form VFP with Lotus data
Message
 
 
À
06/06/2002 01:15:05
Vladimir Zhuravlev
Institute of the Physics of Earth,Russia
Moscow Region, Russie
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00665272
Message ID:
00665429
Vues:
21
>I need some sampes or hints , how to get data from Lotus ( server)
>through VFP into MS SQL and back . Propably I am not intrested in any direct import utilities , but in hand written codes
>Thanks in advance, Vladimir.

Vladimir,
If you want to access Notes data from VFP, check out Message#430658 for a small example.

However, since the ultimate destination is SQL Server, you may want to look at interfacing Notes with SQL Server without using VFP at all (unless you need information in VFP tables). Two ways to handle this:

1. Use the Notes server as the conduit - check out using the Domino Enterprise Connection Service (DECS) to handle this. You can see a web cast of this here: http://www.lotus.com/homepage.nsf/(search)/search?OpenDocument&SQL%20Server.

2. Use SQL Server as the conduit - set up the Data Transformation Service (DTS) to connect to your Notes server and pull any information you need from it. You can create a job and schedule it to run any time you want. Bring up the wizard and it will walk you through the process.

HTH.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform