How to Install ODBC or MDAC on Terminal Server

Article translations Article translations
Article ID: 216149 - View products that this article applies to.
This article was previously published under Q216149
Expand all | Collapse all

SUMMARY

The installation of Microsoft Data Access Components (MDAC) presents special challenges when installing on Terminal Server. Also, as the Terminal Service Licensing service uses Open Database Connectivity (ODBC), an incorrect installation of MDAC renders the service inoperable.

Both programs and system services use ODBC, and some manual steps may have to be used to ensure that nonprivileged services can access the components.

MORE INFORMATION

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows

The first set of steps is necessary to ensure the MDAC service installation will finish. The last steps will ensure that MDAC will run on the terminal server and all users will be able to take advantage of the updates.

NOTE: The person performing the installation must be in the local Administrators group.
  1. Stop all ODBC-dependant services including, but not limited to, Internet Information Services (IIS), Structure Query Language (SQL) Server, SQL Server Enterprise Manager, Terminal Server (TS) licensing service, and ODBC Administrator itself, and so on.
  2. Remove all users who are logged on.
  3. Create a temporary folder in the System32 folder named "Oldodbc" (or any folder not in the computer's path), and then move the following files into that folder:
    Ds16gt.dll
    Ds32gt.dll
    Odbc16gt.dll
    Odbc32.dll
    Odbc32gt.dll
    Odbcad32.exe
    Odbcconf.dll
    Odbcconf.exe
    Odbccp32.cpl
    Odbccp32.dll
    Odbccr32.dll
    Odbcinst.cnt
    Odbcinst.hlp
    Odbcint.dll
    If a webdata package has ever been installed, then all values need to be removed under the following registry key. Do not remove the key. Save the key to a file before removing the values.
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\ExceptionComponents
  4. At a command prompt, type change user /install, and then close the command window.
  5. Now you are ready to start the installation. Download MDAC from the following Microsoft Web site and install it with the default options:
    http://msdn.microsoft.com/en-us/data/aa937729.aspx
    IMPORTANT: Before closing the Setup screen or restarting, you must run the program compatibility script, Odbc.cmd, which is located in the following folder:
    SystemRoot\Application Compatibility Scripts\Install
  6. Shutdown and restart the computer. This will automatically return the computer to Execute mode.
NOTE: Once you have verified that MDAC has installed properly, you may delete the folder created in Step 3 and all of its contents.

Access to some components located in Systemroot\System32 is limited to the person who performed the installation, the Administrator group, and System. The generic Everyone group needs Read and Execute rights to the following ODBC files. The current rights on these files will vary depending on the version of MDAC that is installed.
Msvcirt.dll
Msvcrt.dll
Odbc32.dll
Odbc32gt.dll
Odbccp32.cpl
Odbccp32.dll
Odbccr32.dll
Odbccu32.dll
Odbcint.dll
Odbcjet.*
Odbcji32.dll
Odbcjt32.dll
Odbctl32.dll
NOTE: If you are installing MDAC 2.6 and higher, the Jet 4.0 database also needs to be installed for Terminal Server to operate properly. This is a separate installation from MDAC. This is not needed for MDAC 2.6 or earlier. You can download the Jet 4.0 Service Pack 8 Release from the following Microsoft Web site:
http://msdn2.microsoft.com/en-us/data/aa937712.aspx#jet
For additional information about how to install MDAC on a Windows 2000 Server computer, click the following article number to view the article in the Microsoft Knowledge Base:
304332 PRB: Installing MDAC on Terminal Server
For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
286442 PRB: MDAC 2.6/2.7 Roll Back Installation/Give Error on Install
For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:
216159 Dr Watson Starting TS License Service with Error 3221487623
232060 HOWTO: MDAC Setup Troubleshooting Guide
307255 INFO: Component Checker: Diagnose Problems and Reconfigure MDAC

REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
305838 PRB: MDAC Installation on Windows Terminal Server May Fail

Properties

Article ID: 216149 - Last Review: February 20, 2007 - Revision: 5.6
APPLIES TO
  • Microsoft Windows 2000 Server
  • Microsoft Windows 2000 Advanced Server
  • Microsoft Windows NT Server 4.0, Terminal Server Edition
Keywords: 
kbinfo KB216149

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com