Notes SQL Authentication List Manager Warning

Posted on 2006-07-12
Last Modified: 2013-12-03
Hi experts

I apologize from the moderator of EE if the question should be somewhere else.

I have CR 10 and Lotus Notes 6.5.4 March 27 2005 and Notes ODBC 3.02e.

It worked for awhile, then I started to receive this error : "This system could not properly load the version of Notes it found on this machine. Please see the NotesSQL user documentation for a list of supported versions of Notes."

I tried to configure the database connections through ODBC and thats what I got : "odbcad32.exe has encountered a problem and needs to close. We are sorry for the inconvenience".

Any remedy for this please ? Many thanks in advance.
Question by:Faraj1969

Author Comment

ID: 17089378
Hi again, I remembered something now, I just recently upgraded Office XP to Office 2003.

Does that has anything to do with the ODBC ?

LVL 42

Expert Comment

ID: 17090134
That could do it.  I believe that Office 2003 updates you MDAC (Microsoft Data Access Components) which includes the base dll's used for odbc connections.  I would look for a newer Notes ODBC driver and see if that solves the problem.

Author Comment

ID: 17090181
I upgraded from 3.02e to 3.02g but still the same

I believe Office 2003 changes some registry keys which is necessary for the ODBC, now I uninstalled Office 2003, but I think the changes wasn't reverted since I'm getting the same error. Is there any information or patch from Microsoft regarding this issue ?
LVL 42

Expert Comment

ID: 17093872
>>> now I uninstalled Office 2003, but I think the changes wasn't reverted since I'm getting the same error

Unfortunately uninstall doesn't roll back mdac changes and I'm not sure that's the route you want to take anyway - that's just a guess on my part that the problem is there.  There is a Domino / Notes forum - you might want to try a posting there  because this seems more like a Notes issue than a Crystal issue.
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

LVL 100

Expert Comment

ID: 17096838
Agree.  Keep this open (I can close and refund later if it doesn't get resolved here).

Frodman is correct that MDAC changes are not rolled back.  Mainly because I don't think they can be.


Author Comment

ID: 17097595
Guess the only solution I can think of is to reformat the computer and avoid installing 2003, or install 2003 before installing Notes, NotesSQL and Crystal. What you think ?

Author Comment

ID: 17277488
Hi again,

The only solution I found is to avoind 2003 for some time, this way everything is working fine, in any case, I'll try to get a test machine and regenrate the problem, then download the latest MDAC from Microsoft and see if it works. For now, mlmcc kindly close the question.

Many thanks to all for your support.

Accepted Solution

DarthMod earned 0 total points
ID: 17470289
PAQed with points refunded (250)

Community Support Moderator

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now