Using ODBC in script coding

[sccice]

I am working on an existing database and whoever developed it has set an odbc connection within a lotus script that requires each individual user to have an ODBC connection set up.
Question.
Is it possible to set up a single ODBC connection on the notes server and for the database to use this rather than each individual having to have an ODBC.

 

[spa77]

An apllication called LEI (Lotus Enterprise Integrator) will utilise an ODBC connection on your Notes Server thus negating the need for a connection on every client's unit. This isn't all that LEI does, so it may be overkill if you want none of the other features.