Hi everybody,
I get some troubles on a Visual Basic application (Microsoft Access 2010).
I’ve a Microsoft Access Application which initialize a session with Lotus Notes in order to get back attachments and incorporate those documents in a Microsoft Access Table.
It’s a really simple application. This application worked perfectly on the old Lotus Notes version (8.X).
Few weeks ago, I migrated on the new Lotus version 9.0, and my application doesn’t work. When I launch the application, I get this error message: “Automation Error”
My application blocks on this line: “Session.Initialize”. I never had any problem with this application.
When I try to called my application again, I get a new error message : “Insufficient Memory”.
For information, I’m using this Microsoft Access Library: “Lotus Notes Automation Classes” => C:\XXX\XXX\Lotus\Notes\notes32.tlb
I tried to replace this library by this one: C:\XXX\XXX\Lotus\Notes\nlsxbe.dll but I can’t import this library: “Impossible to add this library”. I also make before this command: regsvr32 “C:\XXX\XXX\Lotus\Notes\nlsxbe.dll”
Have you got any idea to solve the problem ?
Thanks in advance. All your advice are welcome!
Sorry for my english. have a good day!
Alex.
Subject: Workaround doesn’t work
I already tried this workaround.
The new Lotus Notes version was installed in the same directory that the previous version.
So I did a regsvr32 on the nlsxbe.dll and I worked successfuly. But when I tried to add this .dll in my Microsoft Access application, it doesn’t work.
The error in French : “Impossible d’ajouter une référence au fichier spécifié” => “Impossible to add the reference…”.
Thanks for your help. I hope I will find an issue, every advices are welcome !
Alex.
Subject: Session.Initialize
Hi Chad, thanks for your reply. You’re right, the Automation Error occurs on a Session.Initialize line
When I’m opening my application, it should initializes a Notes Session :
Private Sub Form_GotFocus()
Dim pass As String
Dim Session As New NotesSession
pass = Config(“password”)
Session.Initialize (pass) => Automation Error
I put my password in a configuration files. Do you think this error occurs because I don’t use the right Library (reference) ?
Subject: Question/Suggestion
Have you tried running this on a brand new install of Notes 9.01? Try running the nice tool http://www-01.ibm.com/support/docview.wss?uid=swg21459714 http://www-01.ibm.com/support/docview.wss?uid=swg21459714 to remove all traces of old versions of Notes client, Then install the 9.01 client then regsrv the nlsxbe.dll
Subject: whats your path look like?
I start at the beginning, sometimes the path doesnt show up in the proper place. Ini files and all that.
If someone knows a utility thatll let you see what sub-dlls are /not loading, that woukd be great, we used to have that decades ago.
Subject: Can you post a code snippet?
Please post a code snippet. I think you are saying the Automation Error occurs on a Session.Initialize line, right?
Subject: Workaround doesn’t work
I already tried this workaround.
The new Lotus Notes version was installed in the same directory that the previous version.
So I did a regsvr32 on the nlsxbe.dll and I worked successfuly. But when I tried to add this .dll in my Microsoft Access application, it doesn’t work.
The error in French : “Impossible d’ajouter une référence au fichier spécifié” => “Impossible to add the reference…”.
Thanks for your help. I hope I will find an issue, every advices are welcome !
Alex.
Subject: Session.Initialize
Hi Chad, thanks for your reply. You’re right, the Automation Error occurs on a Session.Initialize line
When I’m opening my application, it should initializes a Notes Session :
Private Sub Form_GotFocus()
Dim pass As String
Dim Session As New NotesSession
pass = Config(“password”)
Session.Initialize (pass) => Automation Error
I put my password in a configuration files. Do you think this error occurs because I don’t use the right Library (reference) ?