Problem with notes connection to SQL using ODBC

HCL Domino Domino Forum
1

Hi

I have a scheduled agent that makes contact with an sql table. This agent is hanging since last night.

This is causing that the agent manager is hanging also because the sql agent does not complete.

This causes also another thing. If I go to my sql client to do a query on the same table, it does

not complete because (probably) the agent keeps the session ( handle ) open to the table. there is

no way to do a query or even count how many rows there are in the table.

Is there a way ( besides restarting the notesserver) to remove the handle to the sql table?

Regards

2

Subject: Problem with notes connection to SQL using ODBC

Did you check the computer running Domino server? You might see some Windows erros messages or ODBC prompts there.

Use SilentMode when establishing connection if you do not already do so. Make sure that server can find to network location of the SQL server and that multiple network interfaces or firewalls do not cause problems.

3

Subject: Problem with notes connection to SQL using ODBC

Hi,

Although I can not give you a big clue, my idea may help you to get it done.

Pls try to use Error handler in your Lotus Script Scheduled agent to identify which one is causing that error. Besides, try to close all the files (if any) /handles upon getting error.

Regards,

Karthik KS

India.

4

Subject: RE: Problem with notes connection to SQL using ODBC

Hi

I use errorhandlers in my agent. the problem is that the agent hangs without giving an error messages in the log or status bar. It is just hanging.

5

Subject: RE: Problem with notes connection to SQL using ODBC

You can try using the OLE DB connector instead. (See Lotus Connector and Connectivity Guide and Lotus Connector Lotusscript Extensions Guide under \Help.) See the EI forum for more details, examples etc.