ColdFusion -Notes database connection

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 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 Loyd_W_Campbell@bankone.com 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

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: ) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

I know I came in at the tale end of this thread, but can you tell me if there's any scripting language that will write to NPAB? Note that the same scripting language does not need the capability to read from Any sort of database. Thanks, Tony Hicks ----- Original Message ----- From: <loyd_w_campbell@bankone.com> To: CF-Talk <cf-talk@houseoffusion.com> Sent: Thursday, May 17, 2001 7:28 AM Subject: CF-Notes database connection > > > Thanks to everyone who responded.  It is disappointing that no one has had any > success in doing what we are needing to do, which is exchanging data between > Notes and our SQL Server database.  We just wanted to get names, addresses, > phone numbers, etc. out of our db and into the Notes Personal Address Book for > our sales people to download into their Palms.  Sounds like a simple thing, but > I guess we'll have to wait for Bill to buy and kill Notes before we can get this > app written. > > If anyone has any other ideas, we'd like to hear them.  BTW, I did hear about > ZMerge and have downloaded an eval.  If it works I'll repost and let everyone ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

Does anyone have any working example sites of a Flash website with a CF backend.  I would be interested to see what is being developed using Flash + CF. Rich ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

> Does anyone have any working example sites of a Flash website > with a CF > backend.  I would be interested to see what is being > developed using Flash + http://www.thenetprofits.co.uk/coldfusion/faq/#question126 -- Aidan Whitehall <aidan.whitehall@netshopperuk.com> Netshopperuk Telephone +44 (01744) 648650 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

www.flashcfm.com is an example site, with tutorials on (also built in CF + Flash itself) J Does anyone have any working example sites of a Flash website with a CF backend.  I would be interested to see what is being developed using Flash + CF. Rich ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

flashcfm doesn't really have a flash front end with a cold fusion back end, it's mostly HTML.  They do have some good tutorials, from what I hear. A nice example of a dynamic flash site is http://www.flashmagazine.com/.  I think they use PHP on the back-end, but naturally you can create the same exact functionality with ColdFusion. --- Paul Mone Ninthlink Consulting Group paul@ninthlink.com 619.222.7082 www.flashcfm.com is an example site, with tutorials on (also built in CF + Flash itself) J Does anyone have any working example sites of a Flash website with a CF backend.  I would be interested to see what is being developed using Flash + CF. Rich ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

www.flashcfm.com Does anyone have any working example sites of a Flash website with a CF backend.  I would be interested to see what is being developed using Flash + CF. Rich ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

flashcfm doesn't really have a flash front end with a cold fusion back end, it's mostly HTML.  They do have some good tutorials, from what I hear. A nice example of a dynamic flash site is http://www.flashmagazine.com/.  I think they use PHP on the back-end, but naturally you can create the same exact functionality with ColdFusion. --- Paul Mone Ninthlink Consulting Group paul@ninthlink.com 619.222.7082 www.flashcfm.com Does anyone have any working example sites of a Flash website with a CF backend.  I would be interested to see what is being developed using Flash + CF. Rich ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

> Does anyone have any working example sites of a Flash website with a CF > backend.  I would be interested to see what is being developed using Flash + > CF. www.sydneyphototour.com www.italyphototour.com These sites are amazing.  A former co-worker of mine made them and did a stunning job. - - - Jeanne ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

   Well, in Notes you can use LotusScript.  Out of Notes...   I'm not sure.    I had a neat little application working that allowed users to register from the web.  It created their user accounts in a secondary name address book, and added them into the valid groups to the primary address book.  I think that Lotus provided a template similar to that. At 07:43 AM 05/17/2001 -0500, you wrote: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

i'm pretty sure you can exchange data between notes and SQL using XML. do some searches on this on the net and you'll find a good amount of resources. this isn't a full article, but look at the summary: http://www.advisor.com/Articles.nsf/aid/SOBCM04 it seems to resemble what you're trying to do. maybe it's a start. Thanks to everyone who responded.  It is disappointing that no one has had any success in doing what we are needing to do, which is exchanging data between Notes and our SQL Server database.  We just wanted to get names, addresses, phone numbers, etc. out of our db and into the Notes Personal Address Book for our sales people to download into their Palms.  Sounds like a simple thing, but I guess we'll have to wait for Bill to buy and kill Notes before we can get this app written. If anyone has any other ideas, we'd like to hear them.  BTW, I did hear about ZMerge and have downloaded an eval.  If it works I'll repost and let everyone know about it. Thanks again, Loyd Campbell Bank One International Corp. 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

Surely with Domino 5 and it's flashy wizzy web side you must be able to build a web intermediary between Notes an CF.    Well, in Notes you can use LotusScript.  Out of Notes...   I'm not sure.    I had a neat little application working that allowed users to register from the web.  It created their user accounts in a secondary name address book, and added them into the valid groups to the primary address book.  I think that Lotus provided a template similar to that. At 07:43 AM 05/17/2001 -0500, you wrote: had Book ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

   I haven't delt w/ Domino 5.   I would think that ya should be able too...    But dammed if I know how, and the general consensus seems to be problematic. At 03:47 PM 05/17/2001 +0100, you wrote: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

Has anyone seen any workshops, or classes on how to integrate Flash and Cold Fusion yet? Thanks, Chad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

Have you checked out FlashCFM.com? http://www.flashcfm.com/index.cfm Steven Semrau SRA International, Inc. Senior Member, Professional Staff steven_semrau@sra.com semraus@aaesa.belvoir.army.mil Com:  (703) 805-1095 DSN:  (703) 655-1095 Has anyone seen any workshops, or classes on how to integrate Flash and Cold Fusion yet? Thanks, Chad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

I've done some presentations to the local CFUG (San Diego) on this topic. 1) Using ColdFusion and Flash together.   Learn how to make a user login and address book. 2) Using ColdFusion, Flash, and WDDX together.   Learn how to create a news article browser and bar graph. I could share the materials with you if you email me off list. --- Paul Mone Ninthlink Consulting Group paul@ninthlink.com 619.222.7082 Has anyone seen any workshops, or classes on how to integrate Flash and Cold Fusion yet? Thanks, Chad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

Check this out: http://www.prodenhance.com/coldfusiontraining/BarGraph.cfm Respectfully, Adam Phillip Churvis Productivity Enhancement, Inc. Want truly advanced ColdFusion 5 training?  Register for the Advanced Bootcamp for ColdFusion 5, Database, and Javascript at http://www.ColdFusionTraining.com! http://www.CommerceBlocks.com E-mail:  info@coldfusiontraining.com Phone:   770-446-8866 ----- Original Message ----- From: "Chad Gray" <chad@attach.net> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Thursday, May 17, 2001 12:42 PM Subject: CF and Flash classes? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

I've done some presentations to the local CFUG (San Diego) on this topic. 1) Using ColdFusion and Flash together.   Learn how to make a user login and address book. 2) Using ColdFusion, Flash, and WDDX together.   Learn how to create a news article browser and bar graph. I could share the materials with you if you email me off list. --- Paul Mone Ninthlink Consulting Group paul@ninthlink.com 619.222.7082 Has anyone seen any workshops, or classes on how to integrate Flash and Cold Fusion yet? Thanks, Chad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

is it possible to use flash to update the client's display with data bieng pulled by cf from a database if so how is this done? Thanks KOla I've done some presentations to the local CFUG (San Diego) on this topic. 1) Using ColdFusion and Flash together.   Learn how to make a user login and address book. 2) Using ColdFusion, Flash, and WDDX together.   Learn how to create a news article browser and bar graph. I could share the materials with you if you email me off list. --- Paul Mone Ninthlink Consulting Group paul@ninthlink.com 619.222.7082 Has anyone seen any workshops, or classes on how to integrate Flash and Cold Fusion yet? Thanks, Chad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

If there is a OBDC driver for Notes then you can uses MD SQL DTS to import the data into MS SQL Rif -----Original Message----- From:   Jeffry Houser [mailto:jeff@farcryfly.com] Sent:  17 May 2001 20:00 To:  CF-Talk Subject:  RE: CF-Notes database connection    I haven't delt w/ Domino 5.   I would think that ya should be able too...    But dammed if I know how, and the general consensus seems to be problematic. At 03:47 PM 05/17/2001 +0100, you wrote: sure. same can hear ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

I haven't paid much attention to this thread, so I may be stepping on my own feet here. I do not know the volume of data, but why not use XML? Notes and SQL Server are both strong in this arena. There are several ways you can go here depending on what resources you have available for programming in Notes and SQL Server. Good Luck, Shaun Blain chadwick.s.blain@boeing.com Thanks to everyone who responded.  It is disappointing that no one has had any success in doing what we are needing to do, which is exchanging data between Notes and our SQL Server database.  We just wanted to get names, addresses, phone numbers, etc. out of our db and into the Notes Personal Address Book for our sales people to download into their Palms.  Sounds like a simple thing, but I guess we'll have to wait for Bill to buy and kill Notes before we can get this app written. If anyone has any other ideas, we'd like to hear them.  BTW, I did hear about ZMerge and have downloaded an eval.  If it works I'll repost and let everyone know about it. Thanks again, Loyd Campbell Bank One International Corp. 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

Hi all, Two years ago I had the same problem. I had a Lotus Notes DB which I wanted to import to a new --enterprise level-- Oracle host. I tried Notes Pump, ODBCs, direct API... The only way I found effective and the one I used was this one: 1.- Create the normalized table structure you want in your database (remember that Notes is doc based, not relational). 2.- Using LotusScript, export the data following the tables structure. 3.- Create the PL/SQL to read the files and insert them into the database (in my case, I work with Oracle). This process is hard and long, but it runs. Just my two cents, Albert. -----Mensaje original----- De: Rif Kiamil [mailto:Rif@jjfastfood.com] Enviado el: jueves, 17 de mayo de 2001 19:10 Para: CF-Talk Asunto: RE: CF-Notes database connection If there is a OBDC driver for Notes then you can uses MD SQL DTS to import the data into MS SQL Rif -----Original Message----- From:   Jeffry Houser [mailto:jeff@farcryfly.com] Sent:  17 May 2001 20:00 To:  CF-Talk Subject:  RE: CF-Notes database connection    I haven't delt w/ Domino 5.   I would think that ya should be able too...    But dammed if I know how, and the general consensus seems to be problematic. At 03:47 PM 05/17/2001 +0100, you wrote: sure. same can hear ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm

We use Notes LEI to pump information out of the notes database to SQL.  I have not had much luck using NotesSQL or JDBC drivers.  They are slow and kludgy.  I find that pumping the information out of notes is usually the best bet. Mary                                                                                                                                         Jeffry Houser                                                                                                        <jeff@farcryf        To:     CF-Talk <cf-talk@houseoffusion.com>                                                    ly.com>              cc:                                                                                                                 Subject:     RE: CF-Notes database connection                                                  05/17/01                                                                                                            02:59 PM                                                                                                            Please                                                                                                              respond to                                                                                                          cf-talk                                                                                                                                                                                                                                                                                                                                     I haven't delt w/ Domino 5.   I would think that ya should be able too...    But dammed if I know how, and the general consensus seems to be problematic. At 03:47 PM 05/17/2001 +0100, you wrote: sure. same has can hear ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm