I've been using the Notes SQL 9.0 driver for some time now and all of a sudden something on multiple Windows 7 x64 Enterprise systems broke the driver.  From what I read it might be related to a MDAC component being updated.  I'm hoping someone else has run into this issue as I'm out of ideas at this point.

When I install the 32 bit version of the NotesSQL driver it installs fine.  If I try and open Nsql_ALM.exe I get an error stating:

The system could not properly load the version of Notes it found on this machine.

When I open the 32 bit version of the ODBC administrator (C:\Windows\SysWOW64) and create a new DSN things start out fine.  However after I add my Domino Server I'm never prompted with my User ID as expected.  I then manually key in the database, then try and manually add the User ID.  When I do that I get a error that states:

Fail to add the new user

User name ??????

From C:\Program Files (x86)\IBM\Notes\Data\UserID.id

The new user could not be added for the Notes ID specified.

Whatever the issue is seems to be related to the initial error.  I added the Notes.ini environmental path, as well as the NotesSQL path, it makes no difference, I continue to get these errors.

Oddly enough  I have another Windows 7 x86 Enterprise system that works perfectly fine, the same can be said on a Windows Server 2012 x64.  Both systems only have IBM Notes 9.0 installed pointing to the same Domino server.

Any assistance would be greatly appreciated.