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:
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
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?