?
Solved

Multiple clients, one ODBC connection?

Posted on 2003-03-26
14
Medium Priority
?
231 Views
Last Modified: 2013-12-18
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
Comment
Question by:s3cmp5
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 6
14 Comments
 
LVL 9

Expert Comment

by:Arunkumar
ID: 8209775
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
 

Author Comment

by:s3cmp5
ID: 8209957
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
 

Author Comment

by:s3cmp5
ID: 8209960
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 9

Expert Comment

by:Arunkumar
ID: 8210077
YES!

I can send you a sample code if you wish...
0
 

Author Comment

by:s3cmp5
ID: 8210303
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
 
LVL 9

Expert Comment

by:Arunkumar
ID: 8210521
okay... send me your email id... I dont want to post it here in this forum.
0
 

Author Comment

by:s3cmp5
ID: 8210614
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
 

Author Comment

by:s3cmp5
ID: 8210638
chris@kelros.com

thanks a lot
0
 
LVL 9

Accepted Solution

by:
Arunkumar earned 560 total points
ID: 8210828
sent it...modify according to your requirements. Its a working raw example from one of my apps.
0
 

Author Comment

by:s3cmp5
ID: 8210920
chris@kelros.com

thanks a lot
0
 

Author Comment

by:s3cmp5
ID: 8211322
Very helpful - thanks a lot
0
 
LVL 9

Expert Comment

by:Arunkumar
ID: 8211348
Did it work ?
0
 

Author Comment

by:s3cmp5
ID: 8211435
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
 
LVL 9

Expert Comment

by:Arunkumar
ID: 8212122
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question