IDC Script Fails to Connect to Database

 Last reviewed: April 22, 1997
Article ID: Q142681
The information in this article applies to:
  • Microsoft Internet Information Server version 1.0
  • Microsoft Internet Explorer versions 1.0 and 2.0

SUMMARY

When you try to run an Internet Database Connector (IDC) script file from a Web browser, the following or similar error messages appear depending on the Internet Explorer version:

In Internet Explorer 1.0: 

   The server considered the request for
   http://YourWebServer/YourScript.idc?' an invalid request.
In Internet Explorer 2.0: 

   Unable to open http://YourWebServer/YourScript.idc?. The site reported
   an invalid request.
The library ODBC32.DLL could not be loaded to perform the query. Make sure ODBC has been properly installed on the server.

CAUSE

A possible cause for these error messages is insufficient Windows NT File System (NTFS) file permissions for ODBC32.DLL.

ODBC32.DLL is located in the <nt_root>\System32 directory. By default, the group EVERYONE has Change permissions (RWXD) on this directory and the files created in this directory. If this default has been changed, there is a chance that when Odbc32.dll was copied into the System32 directory it did not receive the "eXecute" permission that Internet Information Server (IIS) needs to run the DLL for the Web browser.

RESOLUTION

To solve the problem, either restore the Change permission for the domain group Everyone on Odbc32.dll, or grant the eXecute permission for any account that you expect to be used to run IDC scripts from a Web browser. Typically, this includes the anonymous logon account that IIS creates for you during installation (IUSR_<machine_name>).

Additional query words: prodiis
Keywords : iisscript kbnetwork
Version : 1.0 2.0
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 22, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.