Hi,
I am trying to read data from a domino databases (located in our LAN
not on my local machine!) from my access project. I pass a code to the
function checkCodeInDomi no to be verified on Domino. On my local
machine everything went fine, but suddenly there came up following
problem:
I was coding and testing with the code below, and I have never been
asked for my lotus password, now when starting my function, there comes
a box up (dont know why this changed?) where I have to enter my lotus
password, when entering my notes password, my function works fine.
But I have to distribute my application to other clients and users, and
it doesnt make sense to use my password.
So I received a public account from our domino admin, for all of us.
When using "DomSession.Ini tialize (publicLotusPas sword)" there are no
errors.
But the problem is, that that's not a real solution for my
appliacation, because each user has to enter his own password, I dont
want that,
but entering a hard coded password doesnt work, because the password
that is asked is referring to
"c:\lotus\notes \data\wk\$userN ame.ID"
Is there any way to use "DomSession.Ini tialize" in some kind of a
"generic" way, so that any other user can use the function
"checkCodeInDom ino"?
Please remember that the domino database is always on a remote machine
and
"'DomSession.In itializeUsingNo tesUserName($Ad min, $Pass)"
does not work!
Here is my code...
Function checkCodeInDomi no(checkCode As Long)
On Error GoTo Err_Quit_Click
Dim DomDir As NotesDatabase
Dim DomContacts As NotesView
Dim DomDoc As NotesDocument
Dim StrName As String
Dim DomSession As NotesSession
Dim serverName As String
Dim databaseFile As String
Set DomSession = CreateObject("L otus.NotesSessi on")
serverName = "myServerNa me"
databaseFile = "myFile"
DomSession.Init ialize
Set DomDir = DomSession.GetD atabase(serverN ame, databaseFile)
Set DomContacts = DomDir.GetView( "myView")
Set DomDoc = DomContacts.Get FirstDocument
While Not (DomDoc Is Nothing)
If DomDoc.GetItemV alue("Dealer_Co de")(0) = checkCode Then
checkCodeInDomi no = True
Exit Function
End If
Set DomDoc = DomContacts.Get NextDocument(Do mDoc)
Wend
checkCodeInDomi no = False
Exit_Quit_Click :
Exit Function
Err_Quit_Click:
MsgBox Err.Description
Resume Exit_Quit_Click
End Function
Thank you for your attention!
Peter Neumaier 3 4467
I think you'll have more luck asking in a newsgroup related to Notes or
Domino, as opposed to a database group.
Have you tried looking for documentation at http://www.lotus.com?
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"Peter Neumaier" <Pe************ @gmail.com> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. . Hi, I am trying to read data from a domino databases (located in our LAN not on my local machine!) from my access project. I pass a code to the function checkCodeInDomi no to be verified on Domino. On my local machine everything went fine, but suddenly there came up following problem:
I was coding and testing with the code below, and I have never been asked for my lotus password, now when starting my function, there comes a box up (dont know why this changed?) where I have to enter my lotus password, when entering my notes password, my function works fine. But I have to distribute my application to other clients and users, and it doesnt make sense to use my password. So I received a public account from our domino admin, for all of us. When using "DomSession.Ini tialize (publicLotusPas sword)" there are no errors. But the problem is, that that's not a real solution for my appliacation, because each user has to enter his own password, I dont want that, but entering a hard coded password doesnt work, because the password that is asked is referring to "c:\lotus\notes \data\wk\$userN ame.ID"
Is there any way to use "DomSession.Ini tialize" in some kind of a "generic" way, so that any other user can use the function "checkCodeInDom ino"? Please remember that the domino database is always on a remote machine and "'DomSession.In itializeUsingNo tesUserName($Ad min, $Pass)" does not work!
Here is my code...
Function checkCodeInDomi no(checkCode As Long) On Error GoTo Err_Quit_Click
Dim DomDir As NotesDatabase Dim DomContacts As NotesView Dim DomDoc As NotesDocument Dim StrName As String
Dim DomSession As NotesSession Dim serverName As String Dim databaseFile As String
Set DomSession = CreateObject("L otus.NotesSessi on") serverName = "myServerNa me" databaseFile = "myFile"
DomSession.Init ialize
Set DomDir = DomSession.GetD atabase(serverN ame, databaseFile) Set DomContacts = DomDir.GetView( "myView") Set DomDoc = DomContacts.Get FirstDocument
While Not (DomDoc Is Nothing)
If DomDoc.GetItemV alue("Dealer_Co de")(0) = checkCode Then checkCodeInDomi no = True Exit Function End If Set DomDoc = DomContacts.Get NextDocument(Do mDoc) Wend
checkCodeInDomi no = False
Exit_Quit_Click : Exit Function
Err_Quit_Click: MsgBox Err.Description Resume Exit_Quit_Click
End Function
Thank you for your attention!
Peter Neumaier
Hi Douglas,
thank you for your answer, but I think that my problem is more VBA and
ACCES than it is to domino databases.
So the only problem I have to solve is, how to use a default password
when accessing the domino database ...
For sure I found documentation on lotus.com, but there isnt anything
regarding my problem
"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message news:<0c******* *************@r ogers.com>... I think you'll have more luck asking in a newsgroup related to Notes or Domino, as opposed to a database group.
Have you tried looking for documentation at http://www.lotus.com?
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Peter Neumaier" <Pe************ @gmail.com> wrote in message news:11******** **************@ g14g2000cwa.goo glegroups.com.. . Hi, I am trying to read data from a domino databases (located in our LAN not on my local machine!) from my access project. I pass a code to the function checkCodeInDomi no to be verified on Domino. On my local machine everything went fine, but suddenly there came up following problem:
I was coding and testing with the code below, and I have never been asked for my lotus password, now when starting my function, there comes a box up (dont know why this changed?) where I have to enter my lotus password, when entering my notes password, my function works fine. But I have to distribute my application to other clients and users, and it doesnt make sense to use my password. So I received a public account from our domino admin, for all of us. When using "DomSession.Ini tialize (publicLotusPas sword)" there are no errors. But the problem is, that that's not a real solution for my appliacation, because each user has to enter his own password, I dont want that, but entering a hard coded password doesnt work, because the password that is asked is referring to "c:\lotus\notes \data\wk\$userN ame.ID"
Is there any way to use "DomSession.Ini tialize" in some kind of a "generic" way, so that any other user can use the function "checkCodeInDom ino"? Please remember that the domino database is always on a remote machine and "'DomSession.In itializeUsingNo tesUserName($Ad min, $Pass)" does not work!
Here is my code...
Function checkCodeInDomi no(checkCode As Long) On Error GoTo Err_Quit_Click
Dim DomDir As NotesDatabase Dim DomContacts As NotesView Dim DomDoc As NotesDocument Dim StrName As String
Dim DomSession As NotesSession Dim serverName As String Dim databaseFile As String
Set DomSession = CreateObject("L otus.NotesSessi on") serverName = "myServerNa me" databaseFile = "myFile"
DomSession.Init ialize
Set DomDir = DomSession.GetD atabase(serverN ame, databaseFile) Set DomContacts = DomDir.GetView( "myView") Set DomDoc = DomContacts.Get FirstDocument
While Not (DomDoc Is Nothing)
If DomDoc.GetItemV alue("Dealer_Co de")(0) = checkCode Then checkCodeInDomi no = True Exit Function End If Set DomDoc = DomContacts.Get NextDocument(Do mDoc) Wend
checkCodeInDomi no = False
Exit_Quit_Click : Exit Function
Err_Quit_Click: MsgBox Err.Description Resume Exit_Quit_Click
End Function
Thank you for your attention!
Peter Neumaier
While I recognize that you're experiencing the problem using automation from
VBA, you're still issuing commands to directly to Domino. I would think that
people more familiar with the Domino programming model would be better able
to help than people familiar with VBA.
YMMV, though.
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"Peter Neumaier" <Pe************ @gmail.com> wrote in message
news:98******** *************** ***@posting.goo gle.com... Hi Douglas,
thank you for your answer, but I think that my problem is more VBA and ACCES than it is to domino databases.
So the only problem I have to solve is, how to use a default password when accessing the domino database ...
For sure I found documentation on lotus.com, but there isnt anything regarding my problem
"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message news:<0c******* *************@r ogers.com>... I think you'll have more luck asking in a newsgroup related to Notes or Domino, as opposed to a database group.
Have you tried looking for documentation at http://www.lotus.com?
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Peter Neumaier" <Pe************ @gmail.com> wrote in message news:11******** **************@ g14g2000cwa.goo glegroups.com.. . > Hi, > I am trying to read data from a domino databases (located in our LAN > not on my local machine!) from my access project. I pass a code to the > function checkCodeInDomi no to be verified on Domino. On my local > machine everything went fine, but suddenly there came up following > problem: > > I was coding and testing with the code below, and I have never been > asked for my lotus password, now when starting my function, there comes > a box up (dont know why this changed?) where I have to enter my lotus > password, when entering my notes password, my function works fine. > But I have to distribute my application to other clients and users, and > it doesnt make sense to use my password. > So I received a public account from our domino admin, for all of us. > When using "DomSession.Ini tialize (publicLotusPas sword)" there are no > errors. > But the problem is, that that's not a real solution for my > appliacation, because each user has to enter his own password, I dont > want that, > but entering a hard coded password doesnt work, because the password > that is asked is referring to > "c:\lotus\notes \data\wk\$userN ame.ID" > > Is there any way to use "DomSession.Ini tialize" in some kind of a > "generic" way, so that any other user can use the function > "checkCodeInDom ino"? > Please remember that the domino database is always on a remote machine > and > "'DomSession.In itializeUsingNo tesUserName($Ad min, $Pass)" > does not work! > > Here is my code... > > Function checkCodeInDomi no(checkCode As Long) > On Error GoTo Err_Quit_Click > > Dim DomDir As NotesDatabase > Dim DomContacts As NotesView > Dim DomDoc As NotesDocument > Dim StrName As String > > Dim DomSession As NotesSession > Dim serverName As String > Dim databaseFile As String > > Set DomSession = CreateObject("L otus.NotesSessi on") > serverName = "myServerNa me" > databaseFile = "myFile" > > DomSession.Init ialize > > Set DomDir = DomSession.GetD atabase(serverN ame, databaseFile) > Set DomContacts = DomDir.GetView( "myView") > Set DomDoc = DomContacts.Get FirstDocument > > While Not (DomDoc Is Nothing) > > If DomDoc.GetItemV alue("Dealer_Co de")(0) = checkCode Then > checkCodeInDomi no = True > Exit Function > End If > Set DomDoc = DomContacts.Get NextDocument(Do mDoc) > Wend > > checkCodeInDomi no = False > > Exit_Quit_Click : > Exit Function > > Err_Quit_Click: > MsgBox Err.Description > Resume Exit_Quit_Click > > End Function > > Thank you for your attention! > > Peter Neumaier > This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mike Discenza |
last post by:
I'm working on a new system that my superiors have determined should use
LDAP for it's authentication and user management. Not real bad, but it's
proving to be a bit of a hassel.
I'm using a Lotus Domino server for the LDAP part. If, in the
ldap_search(...) function I pass it "o=myCompany" for the dn parameter (the
second parameter), I only get back the list of users, not the groups. I
only want back the groups in this instance.
...
|
by: Christian Patterer |
last post by:
Hi,
Even after searching the web for hours, I can't get my PHP configuration
work.
I have Apache and PHP installed. Now I want to use the mail() function
in PHP. On the Linux server I have running Lotus Domino as SMTP server
and I don't know how to configure PHP to use the Lotus Domino SMTP server.
I use the setting SMTP=localhost to access the Domino server, but this
|
by: Peter Neumaier |
last post by:
Hi,
I am trying to read data from a domino databases (located in our LAN
not on my local machine!) from my access project. I pass a code to the
function checkCodeInDomino to be verified on Domino. On my local
machine everything went fine, but suddenly there came up following
problem:
I was coding and testing with the code below, and I have never been
asked for my lotus password, now when starting my function, there comes
a box up (dont...
|
by: Colin Anderson |
last post by:
I discovered, with great excitement, this article
http://www.davison.uk.net/vb2notes.asp when researching methods for
emailing from Access via Notes. Unfortunatly, when I run this I get a
Run-time error. When I run it on an XP machine it crashes, but on an
NT box it just generates an unknown error, handled by the error
handler. I have debugged and stepped through the code and have
narrowed the issue to the point at which the...
|
by: Kevin Yu |
last post by:
hi all
is there any managed component out there to send out email through the
domino email server??
Kevin
| |
by: gabriel.salama |
last post by:
I am desperately trying to create a login page in ASP.NET in which a
user can be authenticated against a Domino Directory but for the life
of me, I cannot even find anything remotely close to this on the
internet. It's like nobody has ever needed to do this.
I already did it in a ColdFusion page and I'm amazed at how incredibly
easy it was using the CFLDAP tag. I would have thought that a task like
this would have been equally easy in...
|
by: shenanwei |
last post by:
We just upgraded DB2 UDB workgroup Edition on Windows 2003 from V8.1.5
to V8.2.3, server and client with no problem.
Domino server is V6.0.2CF2 on Windows 2003 on another machine, DB2
client is upgraded to V8.2.3.
But Domino keep crashing when we run our application, application is
written by Lotus Script code and Java. They both need to connect to
DB2.
Does any one has the same configuration?
Thanks
|
by: VooDoo |
last post by:
Hi,
I am using domino email group to send notifications.
I would like to keep a record of the email sent, but also the list of the
person that are in the group.
Currently i just send an smtp email to "groupnameatmycomp.com".
How can I read the domino directory to know who is in the group?
Does anyone has already been using php and domino?
Thanks for your help and recommendations.
|
by: gilles.carali |
last post by:
Bonjour,
J'ai deux serveurs Domino Notes (A et B) en cluster qui se connectent
à l' AS400 via DB2 ou ODBC.
Configuration :
Win2000, Domino Notes V5.013a
Client Access Express en V4.5 (SP SF67104) sur le A
Client Access Express en V5.1 (SP SI08389) sur le B
|
by: carmelo |
last post by:
Hi guys, anyone knows the algorithm of the domino game? i was thinking
at the shortest common substring algorithm, but it doesn't work
because when you play, you can turn the dominos ,it must be something
with dymanic programming.. anyone has an idea?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |