English

Error: SQL Connect: Failed to get the expression service

Solution or Workaround

Error Message
While connecting to the Access database, the following error may occur:

Call to SQLDriverConnect recieved error
Received: SQL_ERROR
Return code: -1

State: S1000
Error: [Microsoft][ODBC Microsoft Access 97 Driver]General error
Failed to
get the expression service

File: ..\sql\ntcon.c
Line: 268

Cause

Outdated ODBC driver

Solution

Warning:
WARNING: The instructions below include making changes to essential parts of your operating system. It is recommended that you backup your operating system and files, including the registry, before proceeding. Consult with a qualified computer systems professional, if necessary.

ESRI cannot guarantee results from incorrect modifications while following these instructions. Therefore, use caution and proceed at your own risk.

Download and install the latest drivers for the database. Currently, you can download the MS ODBC drivers from:

http://www.microsoft.com/data/mdac2.htm

You must first accept the license agreement at the bottom of the page. From the next page select for download "Microsoft Data Access Components 2.0 SP2 Redistribution Typical Setup". This pack contains core MDAC 2.0 components including additional OLE DB providers and ODBC drivers for various data sources, including the drivers for Excel and Access.