RE: CF-Notes database connection

[Moneymaker, Jon S (WPNSTA Yorktown)]

We have a custom designed program written in Lotus Notes at my
organization...
I have, on several occasions attempted to connect to the "database" (if you
really want to call it that) with little success.
I was able to extract information and present it to a webpage, but ANY
attempt to write back or change the data through ODBC proved
disastrous....it corrupted the copy I made of the "database" beyone use. 

I finally gave up.
IBM/Lotus was NO help....
Everyone I have talked to (including a Lotus Notes rep at an IT conference a
while back) states/stated that Lotus Notes is NOT a true relational database
and is (in our case) being asked to do something it was NEVER designed to
do.

Sigh....
good luck.
If I discover a solution I will post it.

Jon

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 1:00 PM
To: CF-Talk
Subject: CF-Notes database connection




I investigated the CF-Talk archives and found a very brief mention of this
last
December, but am wondering if anyone else has had any experience with
getting
data into or out of a Lotus Notes database.  I downloaded Lotus' NotesSQL
driver, installed it, created a DSN, and verified it in CF Administrator.
Only
problem is that after the verification, CF Server was dead.  I had to stop
and
restart CF Server.  I created a simple query, which gave a NotesSQL error
message, and CF Server was dead again.  After repeated trials, after every
attempt to connect to the database (Personal Address Book on local machine),
either through a  <cfquery> or through CF Admin, CF Server dies.

Has anyone else found a way to make this connection in a semi-reliable
manner?

Thanks,

Loyd Campbell

Website Manager
Bank One International Group
1700 Pacific Ave., 21st Floor
Mail Code TX1-2805
Dallas, TX 75201
[EMAIL PROTECTED]
214-290-2811 (office)
972-567-9082 (cell)



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists