Just wondering, any way cold fusion can extract data from lotus domino? all suggestions are appreciated. TQ
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
You can download the newest ODBC driver from http://www.lotus.com/rw/dl
Once installed, just define a DSN datasource using the Lotus driver. You'll have to enter the Lotus server name and the database name
Then create a Lotus view containing the data you want and access the view like:
<cfquery datasource="myDSN">
select * from myView myView
</cfquery>
Note that you might have to enter the view name twice
You can extract it directly after installing the Notes ODBC driver and creating the Notes view.
In fact, under Microsoft Access you can link or import the Notes view directly in a table
From File/Get External Data/Import
From Import popup, select File of Type ODBC Databases
From Select Data Source click Machine Data Source tab
Select the Data Source you created using the Notes driver
Select the view you created
Just click OK when prompted for unique identifier
Now you have a MS Access table
Greetings.
This question is still open today, perhaps it was overlooked or just lost in the volumes. Please return to this question to update it with comments if more information is needed to get your solution. If you've been helped by the participating expert(s), you may just convert their comment to the accepted answer and then grade and close. If an answer has ever been proposed you may not have this option to accept the comment as answer, if that is the case, ask the specific expert you wish to award to post an answer. This benefits others who then search our PAQ for just this solution, and rewards the experts who have provided information. A win/win scenario.
If you wish to award multiple participants, you can do so by creating a zero point question in the Community Support topic area, include this link and tell them which experts you'd like to award what amounts. If you'd like to delete this question, use the same process as above, but explain why you think it should be deleted. Here is the Community Support link: http://www.experts-exchang
You can always click on your profile to see all your open questions, in the event you also have other open items to be resolved. If your number of Questions Asked is not equal to the number of Answers Graded, choose to VIEW question history, and you'll quickly be able to navigate to your open items to close them as well.
I've had excellent help from experts-exchange through the years and find the real key to getting what I need is to remain active in all my questions, responding with results to suggestions until my solution is found, and recommend that highly.
Thank you very much for your responsiveness, it is very much appreciated.
":0) Asta
P.S. Some of the older questions from last year are not in the proper comment date order, and Engineering has been advised.
StingRay,
No comment has been added lately (886 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:
RECOMMENDATION: Award points to iamari http:#4790859
Please leave any comments here within 7 days.
-- Please DO NOT accept this comment as an answer ! --
Thanks,
jyokum
EE Cleanup Volunteer
Business Accounts
Answer for Membership
by: Dain_AndersonPosted on 2000-10-18 at 04:14:36ID: 4787119
If Lotus Domino has an available ODBC driver, then the answer is yes. I don't use Domino, but you can connect to any ODBC datasource via ColdFusion. Once connected, use Domino's query syntax to extract data (which I've heard is slightly different than straight SQL).