Description: This solution discusses how to resolve the error: ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xf3c Thread 0xf48 DBC 0x1cfbd024 Excel'.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xf3c Thread 0xf48 DBC 0x1cfbd024 Excel'.ERROR [HY000] [Microsoft][ODBC Excel Driver] Failure creating file.ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xf3c Thread 0xf48 DBC 0x1cfbd024 Excel'.ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xf3c Thread 0xf48 DBC 0x1cfbd024 Excel'.ERROR [HY000] [Microsoft][ODBC Excel Driver] Failure creating file. -->System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)-->System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)-->System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)-->System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupPro
Answer:
This error indicates that ImportOmatic can't access the MasterID file created in Excel.
Move the file to a network drive that is accessible to every IOM user. In your IOM profile under Gifts, select the Edit link to browse for and select the new location of the Excel file.
For more information on how to set up a MasterID file in Excel, please How to Use the MasterID file in Excel.
Please use the following link to locate the ImportOmatic User Guide for additional information.