Notes SQL Authentication List Manager Warning

Posted on 2006-07-12
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

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 ?
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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 101

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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 …
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses
Course of the Month12 days, 15 hours left to enroll

777 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