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 ?
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

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.
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

786 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