Lotusscript

I have a novice question.

I have a View that calls a script in the QueryOpen event, at some point this scipt has to open an ODBC connection to db2. The password etc. are in the server notes.ini. Which part, if any must run on the server to be able to open the datasource? There is an ODBC script whic retrieves the password etc from the environment variables in the Initialize routine. These variables are blank when I run debug. If the initialize is executed when the script is loaded how do I tell it to run on the server?

Thanks for any help.

Subject: RE: lotusscript

The way to get a script to run on the server is to put it in an agent and use RunOnServer to run the agent. This and a few other options that directly address your situation, are discussed here: Off-loading Lotus Enterprise Integration tasks to the server.

By the way, please use a more informative subject line next time.

Subject: RE: lotusscript

Will do and thank you.