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