Multiple clients, one ODBC connection?
Posted on 2003-03-26
I need to know if it is possible to refresh my Notes-based fields (from SQL db) without having an ODBC connection set up on the client?
Problem is I have dialog lists which, on keyword change, need to update a 2nd field. ALL data (including dialog lists) is being read from an SQL backend, but it is impractical to set up a new DSN on every client.
I was thinking it might be possible to call an agent from the postrecalc of the form and from there, call another agent using the .RunOnServer method which would then use the server's odbc connection to retrieve the data and (maybe?) write the values to a db profile document for subsequent retrieval by the next line of code following the .RunOnServer. Is this possible or am I having a giraffe? Any other suggestions? Is it possible to use ADO??