Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to work form VFP with Lotus data
Message
 
 
To
06/06/2002 01:15:05
Vladimir Zhuravlev
Institute of the Physics of Earth,Russia
Moscow Region, Russia
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00665272
Message ID:
00665429
Views:
22
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform