Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

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
0
s3cmp5
Asked:
s3cmp5
  • 8
  • 6
1 Solution
 
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 8
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now