Knowledge Base

Category: Carlson GIS
Topic ID: 827
Title: MDB related problems on x64 bit computers
Created: 0000-00-00Last modified: 0000-00-00

WARNING: the following steps are require that you MUST have Administrator Rights before proceeding to execute them.

*If you find that these instructions do not resolve the issue, and you are running a 64 bit version of Carlson on IntelliCAD, you may uninstall that version and install the 32 bit version. This will resolve the ADOX error. Carlson Software Downloads *
 
In the case of reading/writing data to a Microsoft Access MDB file format, on x64 bit computers, when the Carlson Application runs as a x64 bit process, we rely on so called "DllSurrogate" server, in order to pass data between the Carlson x64 bit process and the Microsoft Jet Database Access Driver (x32 bit driver). This is Microsoft limitation.

On some computers, the creation of the registry entries, required by the Carlson Office Software DllSurrogate server, are not completed through the installation process; or in some other cases the entries are deleted by other follow-up software installations, or antivirus software setups.

If this is the case, Carlson Office Software routines, which require access to the Microsoft Access MDB files, are likely  to report an error in the command line similar to "Please install ado/adox 6.0 database server" or other MDB failures.

To correct this issue, you could try the following workaround solution:

WARNING: the following steps are requiring that you have Administrator Rights before proceeding to execute them.

Windows 7 Procedure

1.	Download the txt file, ado_surrogate.txt and save it on your hard drive.
2.	Save and Close all other programs on your computer.
3.	From the Start Menu of Windows 7, type: regedit , in search field to find the registry editor.
4.     Right-click on the regedit.exe and select Run As Administrator.
5.	Under File use Import and load the file ado_surrogate.txt.
6.	Wait until the process finishes. Then, close the registry editor window.
7.	Re-start Carlson Office Software.

Windows 10 Procedure

1.	Download the txt file, ado_surrogate.txt and save it on your hard drive.
2.	Save and Close all other programs on your computer.
3.	Left-click on  the Start Menu of Windows 10. Then  type: regedit , to find the registry editor.
4.	Right-click on the regedit.exe and select Run As Administrator. 
5.	Click on the File drop-down, and select Import.
6.	On the bottom, right-hand side (above the Open button), change the "type of file to import" to All Files.  Then, locate and load the file ado_surrogate.txt.
7.	Wait until the process finishes. Then, close the registry editor window.
8.	Re-start Carlson Office Software.



*IF YOU FIND THAT THESE INSTRUCTIONS DO NOT RESOLVE THE ISSUE OR IF YOU GET AN ERROR, PLEASE TRY FOLLOWING THE PROCEDURE SHOWN IN THIS VIDEO TO FIX THE REGISTRY PERMISSIONS, THEN RE-RUN THE IMPORT.*

Fixing registry permission issues for KB827 You will need to modify the permissions on the following keys, one at a time, as the video indicates. Once completed, please re-run the surrogate text file. HKEY_CLASSES_ROOT->Wow6432Node->CLSID->{00000602-0000-0010-8000-00AA006D2EA4} HKEY_CLASSES_ROOT->Wow6432Node->CLSID->{00000609-0000-0010-8000-00AA006D2EA4} HKEY_CLASSES_ROOT->Wow6432Node->CLSID->{0000061B-0000-0010-8000-00AA006D2EA4} HKEY_CLASSES_ROOT->Wow6432Node->CLSID->{00000507-0000-0010-8000-00AA006D2EA4} HKEY_CLASSES_ROOT->Wow6432Node->CLSID->{00000514-0000-0010-8000-00AA006D2EA4} HKEY_CLASSES_ROOT->Wow6432Node->CLSID->{00000535-0000-0010-8000-00AA006D2EA4}

Links:
Attachments:
ado_surrogate.txt
Keywords: