Hello. My purpose is to embedd various modules inside of Business Objects reports using VB Macros. I’m tyring to pass my password string into the Initialize method of the NotesSession Password to avoid gettign prompted for the password. However it will always bring up the prompt box. Using Visual Basic I’m trying these sets of code.
Code:
Dim domSession As New Domino.NotesSession
Dim strPassword As String
strPassword = InputBox(“Please Enter a Password”, “Enter Password”)
domSession.Initialize (strPassword)
—and—
Code:
Dim domSession As New Domino.NotesSession
domSession.Initialize ("Hard Code My Password")
Weither hard coding or prompting via inputbox to populate a string variable and passing that , it does not matter if i put the correct password or not, it just prompts. If i put the wrong password in the prompt it errors out saying bad password. If I type the correct password in the prompt, it works. I’m using Notes 6.0.2CF1. What do I have to do to make the prompt go away. It’s like it’s ignoring my password string in the method call. It’s consumed 3 hrs of my time now (I did find out a lot of other useful information in that 3hrs of research at least). Please Help.
This seems to be frequently asked question on a variety of forums. The CreateObject method is usually given as the resolution; however, in my case, as well as for many others, this did not work. It did work on my development workstation, but it does not work in production. I could not figure out what was different but I finally found a solution:
To resolve the password prompt issue, enable “Don’t prompt for a password from other Notes-based programs.”
File → Tools → User ID → (login) → check box
Note: This seems odd that it is needed on the production station when it is not needed by the development workstation.
There must be something else going on but this did finally resolve the issue.
Note: This may not work for all scenarios. In my case, the application is running on a central application server. If your application runs locally, you would need to configure this setting for every workstation, which may not be practical.
Hope this was helpful…and I welcome a better resolution if someone can figure out a better way.