At 09:50 AM 05/16/2001 -0400, you wrote:
>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.
Out of random curiosity...
How did you make a copy of the database? If you use an OS file-copy,
Notes is incapable of distinguishing the initial database from the
original, because they are given the same unique identifier. I only
experienced the problem, however, when using both database at the same time
from the same client. Creating documents in one would save to the other,
for instance.
Whether this holds true for ODBC.. I have idea. But, notes does
provide a 'make database copy' option which takes care of this. Also you
have the option to create a replica of the database.
>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.
I think saying Notes is not a true relational database is an
understatement. It is very good in certain applications, but not RDBMS.
I wonder if I still have a Notes server floating around, I wonder if I
could get CF and Notes working together. ( In my spare time? :ha, ha: )
>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/[email protected]/
>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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
