It is very simple really just a case of knowing all the products invloved (which I don't that well) I should point out that I have had quite a history with notes and coldfusion and making it work has been a real nightmare in the past usually because the ODBC drivers have been pants. I hope this new driver works better but we'll see.
To get it all going you will need a notes client on your server (you could maybe just use the dll files that the connector looks for) This MUST be 4.6.4 or above YOU WILL GET PROBLEMS IF IT ISNT Once the notes client is in place and installed you'll need a notes id file. Install the notes id file and make sure you can access notes ok and that all is working in notes before you go any further. Download and install the notessql3.2b driver from the lotus website on the server Download and install the notes sql sample pack (If only for the Nsql_alm.exe file) http://www.lotus.com/products/rnext.nsf/873769A79D9C5B2285256A0800720B96/F8 BA31E9F7BDEC3A85256C4700667625?OpenDocument In the ODBC administrator on the server you will see NotesSQL_SampleDB - I suggest you use this one first and then create your own later! Use the file Nsql_alm.exe (in the notessql samples directory) to point at the notes.ini file and most importantly setup the notes id files you are going to use for the connection. THIS BIT IS IMPORTANT !!! Using the ALM allows you to create multiple accounts - quite useful! Now to the CFMX administrator Login and choose Data Sources (as if you didn't know) Call the datasource what you want (I called mine notes) and select the ODBC socket. If you installed the sample pack you will see the ODBC DSN in the list (NotesSQL_SampleDB) Click the advanced settings button Insert the notes id username and password in the username and password boxes Click submit Green text saying - datasource updated successfully There you go - done! As I said easy really it was just a pain going through the learning curve of notes id files etc..... Regards - Paul - One more thing do not use notessql2.6 on win2k this is crap and will kill your server on a regular basis ************************************************************* This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] The views expressed within this email are those of the individual, and not necessarily those of the organisation ************************************************************* -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
