Errors when trying to connect to a database


Occasionally errors can arise when trying to connect to a database on an AS/400 using a HIT Technologies driver.


This is due to an incompatibility with the winsock32.dll in the Arcview startup script.

Solution or Workaround

Use HIT ODBC drivers with SQL connect

  1. Start Windows Explorer.
  2. Navigate to where Arcview is installed.
  3. Open the Startup file in the AV_GIS30/Arcview/ETC directory in a text editor such as Notepad or WordPad.
  4. Find the following lines:

    if (FN.FindInSystemSearchPath("wsock32.dll) <> nil) then

  5. Comment out those lines by inserting a single quotation mark at the beginning of each line.
  6. Save the file as Startup.

    Use Windows Explorer to make sure the text editor did not add a .txt extension to the file.

  7. Restart your computer.
  8. Retry the SQL connection.

Article ID:000004100

  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic