We have some end users that are having trouble connecting to reports that they have currently running in Crystal 8.5 without any problems. When they try to run them in Crystal 11, which we are connection through a ODBC Connection to a Lotus Notes Database, the users keep getting a Login Failed message and then two more messages that say:

Database Connector Error: 'S1000:[Lotus][ODBC Lotus Notes]Unable to validate userid Christy Deking [Database Vendor Code: 23319]'

and the other one is:

Logon failed.
Details:28000:[Lotus][ODBC Lotus Notes]Invalid authorization specification [Database Vendor Code: 23319]

Does anybody know anything about this error or had the samething happen to them. If so what can we do about this or how can it be fixed.

Thanks for the help

Christy DeKing

Hi
Did you find a solution to this problem? I am also experiencing the same error when connecting via ODBC to a Lotus Notes database.

Thanks
Denise

Having the same issue. How did you resolve.

I've logged a support request with Business Objects. They advised me to update my Windows ODBC drivers. I don't believe this will fix the issues, as my reports work OK for a while, then generate this error randomly. So no resolution unfortunately,

Denise

BINGO!!!!

Not running Crystal- but I have been receiving the same error message.

The problem here is actually nothing to do with Crystal.

I found this forum whilst researching a similar issue- someone here at work got the same message trying to make an ODBC connection to Notes.

Now, I've managed to fix the machine here- so I want to make sure anyone else googling this problem doesn't waste as much time as I did today... here's the solution:


Several different things you need to check here.

1) Do you have a notes.ini file set up? Is there only one on your machine?

If there are multiple- it could be picking the wrong one. Even if you have one it might not be finding it.

In your System Environment Variables, make sure the path that your .ini file is in is included in the path variable.

2) Look for the following line in your notes.ini file:

NotesSQL_CFG_Path=C:\Program Files\notes\NotesSQL.cfg

The above variable should point to wherever your notessql.cfg file exists on your machine.

3) Look in your registry

"HKEY_LOCAL_MACHINE\software\lotus" (varies depending on your version - but it should be something like that)

Make sure the path specified is where your notes.ini file exists.

4) Open up the file: NotesSQL.cfg in notepad... it should look something like this:

; This file was generated by the NotesSQL Driver.
; Visit us on the web at http://www.lotus.com/NotesSQL
[Users]
Fred Flintstone/bedrock=C:\Program Files\notes\data\fflintst.id


(path may vary)
The name above should be the one you're trying to connect using.




If none of the above works then- sorry you've gone beyond what I've researched today... I was able to fix it using the above techniques.



Good Luck... Hope this helps someone.


PS I hate Lotus Notes- causes me nothing but problems. Why can't every database be relational?

Wycco, you just saved me a lot of time. Thanks for posting that info. I solved my problem at step 1.

Thanks again!