How to fix the error "MDBTools_0309E - DBDriver failed to install" that occurs while running the setupmdb command for installing a MDB Patch?

Document ID : KB000031110
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

How to fix the error "MDBTools_0309E - DBDriver failed to install" that occurs while running the setupmdb command for installing a MDB Patch?

SETUPMDB log shows: ERROR - com.microsoft.sqlserver.jdbc.SQLServerException: The index 'evt_x0' is dependent on column 'sym'.

 

Answer:

This problem occurs due to the index 'evt_x0' being present on the 'evt' table in the MDB.

  1. Login to SQL Management Studio as a SQL administrator.  Expand MDB Database -> Expand the table dbo.evt -> Expand Indexes -> Right-click on evt_x0 -> Select Script table as -> Create to -> Copy the complete CREATE INDEX into a text editor (i.e. Notepad).
  2. Right-click on the 'evt_x0' index and delete. 
  3. Run SETUPMDB to install the MDB patch.
  4. Upon successful completion of SETUPMDB, go back to the SQL Query Window and paste the copied 'evt_x0' index saved in step #1 above and execute the query to recreate the 'evt_x0' index..