InForm Service Fails to Start With Error: No valid ODBC handle to retrieve diagnostic information

(Doc ID 2377959.1)

Last updated on APRIL 05, 2018

Applies to:

Oracle Health Sciences InForm - Version 4.1.0 and later
Information in this document applies to any platform.

Symptoms

InForm server will not start and fails with the below error.

Command line error:

 

Event log Error:

Windows could not start the InForm Service service on Local Computer.

Error 0x80041c06: 0x80041c06

HRESULT=0x80041c06
Details=ODBC execution Error. ODBC error code -1, Error message=No valid ODBC handle to retrieve diagnostic information, Table=PF_DBUID, where clause=DBUID = (SELECT MAX(DBUID) FROM PF_DBUID)

Process: 3472
Thread: 1440
Action: Connect to database
Error: Connection Error #1 State: IM004 Message: {Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
Code: -1
SQL:
Bind Parameter Count: 0

 

Changes

A new Oracle home directory was created.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms