Connecting to Lotus Notes Mail database

Report · May 13, 2009

I have Coldfusion 8. I am trying to connect to our Lotus Notes Mail database. I've installed the Lotus NotesSQL driver 8.0. I've created a DSN in the ODBC Data Source Administrator. When I try to set the datasource in Coldfusion Administrator using "ODBC Socket" as the driver type, I get the following error:

Connection verification failed for data source: NotesAddress
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Driver's SQLAllocHandle on SQL_HANDLE_DBC failed
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

Any help I can get on this would be much appreciated!

Report · May 20, 2010

So I've got a slighty different problem, but maybe we

can help each other.

We're on Coldfusion 9 but I get the connection working fine the admin but as soon as the report writer comes into play

it's broke.

Save the password on the ODBC connection setting as well as in the coldfusion adim console and remember

that the user names aren't straight forward "UserName/Server/Company" as a exmaple!

Also you need to the the .id files and Notes installed on the machine.

Best way to test your ODBC connection before using it in Coldfusion is use excel to try and get the data from

the ODBC connection first. Once you've achieved that then setup the coldfusion connection.

Once you've achieved that see if you can help me I can connect and the ODBC and everything is OK but it

break as soon as we try and create a report with some Driver not capable problem I also need help. Hope

I've managed to help you.

Regards