Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
|
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 15th, 2006, 03:52 PM
Registered User
 
Join Date: Mar 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem Connection to Lotus Notes in Crystal 11

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

 
Old May 9th, 2006, 07:11 PM
Registered User
 
Join Date: May 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old May 16th, 2006, 11:12 AM
Registered User
 
Join Date: May 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Having the same issue. How did you resolve.

 
Old May 17th, 2006, 01:00 AM
Registered User
 
Join Date: May 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old August 2nd, 2006, 04:24 PM
Registered User
 
Join Date: Aug 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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?

 
Old November 8th, 2006, 03:35 PM
Registered User
 
Join Date: Nov 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Thanks again!






Similar Threads
Thread Thread Starter Forum Replies Last Post
Email Via Lotus Notes poyserr Access 1 June 30th, 2009 04:05 PM
Issue with Lotus Notes Warbird VB How-To 1 November 13th, 2007 01:06 PM
Sending email using Lotus Notes S.A.M Excel VBA 5 August 23rd, 2007 07:10 AM
Integrating Lotus notes with .net vivek_inos ASP.NET 2.0 Professional 2 June 12th, 2007 04:52 AM
Lotus Notes GuyB ASP.NET 1.0 and 1.1 Basics 0 December 27th, 2005 07:01 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.