Connecting CF 8 to Lotus Notes Database

[Ray_Bakker]

I have setting up an ODBC connect on Windows 2003 server (IIS 6) using NotesSQL 3.02 with Notes Client 6.5. I am now trying to create a data source in CF using the ODBC Socket and I get the following error:

Connection verification failed for data source: LN_Test
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]Network problem, session aborted due to internal error in remote procedure call, connection closed.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]Network problem, session aborted due to internal error in remote procedure call, connection closed.

Any thoughts.

Thanks

[Newsgroup_User]

harkg hrauiohgtasrit wrote:
> I have setting up an ODBC connect on Windows 2003 server (IIS 6) using NotesSQL
> 3.02 with Notes Client 6.5. I am now trying to create a data source in CF using
> the ODBC Socket and I get the following error:
>
> Connection verification failed for data source: LN_Test
> java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]Network problem,
> session aborted due to internal error in remote procedure call, connection
> closed.
> The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC
> Driver]Network problem, session aborted due to internal error in remote
> procedure call, connection closed.

"session aborted due to internal error in *remote* procedure call" can
you check the log files on the server side ?
--
Mack

[Ray_Bakker]

Mack

Thanks for the quick response. This error occurs when I am testing the data source set up in the cf admin. There is nothing in the application, exception, and server logs.

Thanks

[Newsgroup_User]

harkg hrauiohgtasrit wrote:
> Mack
>
> Thanks for the quick response. This error occurs when I am testing the data source set up in the cf admin. There is nothing in the application, exception, and server logs.

I think it's worth also checking the logs on the database side, not only
on CF's side (and also check that the network is really working by using
ping host and telnet host #port_of_NotesSQL# - if it's using TCP/IP).

--
Mack

[Ray_Bakker]

Mack

I can get to the database via the Notes Client on the server so the server can talk to each other.

Good call on the event logs. Here is what I found in the Event Viewer:

Description:
The description for Event ID ( 0 ) in Source ( ColdFusion 8 ODBC Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: ColdFusion 8 ODBC Server@LOCALHOST,ErrorCode=3004,ErrorMessage=sched.swschd.1424.Internal error, an unexpected exception was detected..

The service is started. What do you think?

Thanks