Multiple clients, one ODBC connection?

Hi

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??

Thanks
s3cmp5Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ArunkumarCommented:
ITS possible.

Have the dsn on server and use .RunOnServer  I have an application that runs seamlessly.  GO for it. The nice option you can explore.

-Arun.
0
s3cmp5Author Commented:
Thanks for the reply Arun, but are you saying that after using .RunOnServer, control will pass back to the client? Remember I need to DYNAMICALLY present the newly retrieved data to the user....Thanks
0
s3cmp5Author Commented:
Thanks for the reply Arun, but are you saying that after using .RunOnServer, control will pass back to the client? Remember I need to DYNAMICALLY present the newly retrieved data to the user....Thanks
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

ArunkumarCommented:
YES!

I can send you a sample code if you wish...
0
s3cmp5Author Commented:
Arun

Thanks again - any chance you could send me that code?  I don't quite understand how I can use the server agent to get the data and then return it immediately to the calling client?
0
ArunkumarCommented:
okay... send me your email id... I dont want to post it here in this forum.
0
s3cmp5Author Commented:
Arun

Thanks again - any chance you could send me that code?  I don't quite understand how I can use the server agent to get the data and then return it immediately to the calling client?
0
s3cmp5Author Commented:
chris@kelros.com

thanks a lot
0
ArunkumarCommented:
sent it...modify according to your requirements. Its a working raw example from one of my apps.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
s3cmp5Author Commented:
chris@kelros.com

thanks a lot
0
s3cmp5Author Commented:
Very helpful - thanks a lot
0
ArunkumarCommented:
Did it work ?
0
s3cmp5Author Commented:
To be honest I don't know yet, but I see how your code works (retrieving the current doc and then looping until the server agent has finished).  What I am worried about is that I basically need an "instant" refresh so that when a keyword changes, other fields change based on that selection.  There are quite a few of these on the same form with different lookups to the backend.  The only way I can see of doing it is writing all the code in the postrecalc and setting all keyword fields to refresh doc on keyword change.  All the fields are in dialog boxes by the way.

One other thing I'm looking at is converting some VB I've found into lotusscript which checks for existence of DSN and creates a new one if not found. I wouldn't then have to worry about running agents on the server...
0
ArunkumarCommented:
the code will have something called as set uidoc = ws.editdocument(doc).... This will bring the new values into the user interface. And the doc.Remove will delete the backend document.

Shoot me questions if you have any.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.