RE: Hooking to Lotus Notes.
Yes you can use ODBC to link to a Notes db. I'm not so sure about linking to a remote Notes db though. I know for Notes 4.5 to get the ODBC working you needed to have a Notes client installed, so you may need to install a Notes client on your CF server. This may of course be different for Notes 5. :) Alex -Original Message- From: Angél Stewart [SMTP:[EMAIL PROTECTED]] Sent: 27 July 2001 14:19 To: CF-Talk Subject: Hooking to Lotus Notes. Can you connect to a Lotus Notes database file..a .nsf file I believe, via ODBC? And can this be done remotely if the CF Server and the Lotus Notes database do not reside on the same machine? I've never used this darn thing before, but apparently a client has this as one of their requirements, that data be read from a .nsf file at regular intervals, and then we write a file that can be imported into that same Lotus Notes database to a location on the server. -Gel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hooking to Lotus Notes.
I've never tried to use the Notes ODBC drivers with Cold Fusion before, however, they can be downloaded from: http://www.lotus.com/home.nsf/welcome/downloads. Look for Notes SQL ODBC Drivers, the latest version is 3.0. tg :) -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 6:19 AM To: CF-Talk Subject: Hooking to Lotus Notes. Can you connect to a Lotus Notes database file..a .nsf file I believe, via ODBC? And can this be done remotely if the CF Server and the Lotus Notes database do not reside on the same machine? I've never used this darn thing before, but apparently a client has this as one of their requirements, that data be read from a .nsf file at regular intervals, and then we write a file that can be imported into that same Lotus Notes database to a location on the server. -Gel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hooking to Lotus Notes.
I'm using Notes 5.0.8, there are no Notes ODBC drivers on my workstation. Unless I missed something in the client install. I know that you can get to Notes via COM, but for hard-core web applications that's a pretty unreliable access method. If I find out anything more, I'll definitely let everyone know. This would be useful functionality for me, too. |-+---| |Eric A. Laney|Worry is a human emotion. | |Systems Engineer | | |LAN Optimization Team| | |Voice: 813.978.4404 | - Spock, Journey to Babel, stardate 3842..4.| |Pager: 888.985.8519 | | |-+---| A.Little@open .ac.uk To: CF-Talk [EMAIL PROTECTED] cc: 07/27/2001 Subject: RE: Hooking to Lotus Notes. 09:38 AM Please respond to cf-talk Yes you can use ODBC to link to a Notes db. I'm not so sure about linking to a remote Notes db though. I know for Notes 4.5 to get the ODBC working you needed to have a Notes client installed, so you may need to install a Notes client on your CF server. This may of course be different for Notes 5. :) Alex -Original Message- From: Angél Stewart [SMTP:[EMAIL PROTECTED]] Sent: 27 July 2001 14:19 To: CF-Talk Subject: Hooking to Lotus Notes. Can you connect to a Lotus Notes database file..a .nsf file I believe, via ODBC? And can this be done remotely if the CF Server and the Lotus Notes database do not reside on the same machine? I've never used this darn thing before, but apparently a client has this as one of their requirements, that data be read from a .nsf file at regular intervals, and then we write a file that can be imported into that same Lotus Notes database to a location on the server. -Gel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Hooking to Lotus Notes.- SOLUTION
Found it! http://www.lotus.com/download_kits.nsf/ You want to use the Select Product dropdown to download the Notes SQL 3.0 ODBC drivers. This package will install an ODBC driver for .nsf databases. You'll have to jump through Lotus' inane registration and login process, but what's a little spam between friends? |-+---| |Eric A. Laney|The great artist is the simplifier. | |Systems Engineer | | |LAN Optimization Team| | |Voice: 813.978.4404 |- Henri FrTdTric Amiel, Swiss poet, philosopher| |Pager: 888.985.8519 |(1821-1881)| |-+---| Angél Stewart To: CF-Talk [EMAIL PROTECTED] gel@carigamecc: r.com Subject: Hooking to Lotus Notes. 07/27/2001 09:18 AM Please respond to cf-talk Can you connect to a Lotus Notes database file..a .nsf file I believe, via ODBC? And can this be done remotely if the CF Server and the Lotus Notes database do not reside on the same machine? I've never used this darn thing before, but apparently a client has this as one of their requirements, that data be read from a .nsf file at regular intervals, and then we write a file that can be imported into that same Lotus Notes database to a location on the server. -Gel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hooking to Lotus Notes.- SOLUTION
Yes thats it! Thank you ! I've been scouring the Lotus Notes site but apparently wasn't looking in the right place heh heh. It's interesting that no one seems to have actually USED the ODBC driver to hook to notes for an application though.. :) *wiggles happily* -Gel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Found it! http://www.lotus.com/download_kits.nsf/ You want to use the Select Product dropdown to download the Notes SQL 3.0 ODBC drivers. This package will install an ODBC driver for .nsf databases. You'll have to jump through Lotus' inane registration and login process, but what's a little spam between friends? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hooking to Lotus Notes.- SOLUTION
Well, don't get excited just yet... I installed the drivers and attempted to connect to my local address book using CF and Notes SQL. I was able to set up the ODBC connection, and I even reverse-engineered the database structure using Visio 2002's Database Model template, but when I created a CF test page and did a cfquery, it immediately crashed cfserver.exe. CF server 4.5.2 Pro on Win2K Pro SP2, 256MB RAM, Lotus Notes R5.0.8, Notes SQL 3.0 |+| |Eric A. Laney |We didn't inherit the land from our fathers. We are| |Systems Engineer|borrowing it from our children.| |LAN Optimization|| |Team|| |Voice: | - Amish belief| |813.978.4404|| |Pager: || |888.985.8519|| |+| Angél Stewart To: CF-Talk [EMAIL PROTECTED] gel@carigamecc: r.com Subject: RE: Hooking to Lotus Notes.- SOLUTION 07/27/2001 10:49 AM Please respond to cf-talk Yes thats it! Thank you ! I've been scouring the Lotus Notes site but apparently wasn't looking in the right place heh heh. It's interesting that no one seems to have actually USED the ODBC driver to hook to notes for an application though.. :) *wiggles happily* -Gel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Found it! http://www.lotus.com/download_kits.nsf/ You want to use the Select Product dropdown to download the Notes SQL 3.0 ODBC drivers. This package will install an ODBC driver for .nsf databases. You'll have to jump through Lotus' inane registration and login process, but what's a little spam between friends? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Hooking to Lotus Notes.
At 09:18 AM 07/27/2001 -0400, you wrote: Can you connect to a Lotus Notes database file..a .nsf file I believe, via ODBC? Yes, Notes databases are .nsf files. And yes, you can connect to them via ODBC. I think Lotus used to have drivers downloadable from their site. And can this be done remotely if the CF Server and the Lotus Notes database do not reside on the same machine? I've never tried that, but since Notes is the god of client-server applications, I see no reason why it wouldn't work. I doubt you would be able to set it up an ODBC connection without a Domino server, actually, and once you are dealing with a server there is no reason why it has to be local. I've never used this darn thing before, but apparently a client has this as one of their requirements, that data be read from a .nsf file at regular intervals, and then we write a file that can be imported into that same Lotus Notes database to a location on the server. If they can define the format of that file, you've lucked out. I can't imagine trying to create documents in a Notes database via ODBC. -- Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- I'm looking for a room-mate in the Hartford CT area, starting in August -- Instant ColdFusion 5.0 | ISBN: 0-07-213238-8 http://www.instantcoldfusion.com -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Far Cry Fly, Alternative Folk Rock http://www.farcryfly.com | http://www.mp3.com/FarCryFly ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists