Skip to main content
Kofax

Connection failed SQLState 01000 attempting ODBC connection to SQL Server using the dynamic port

3018236

Question / Problem: 

What can cause an issue where the following error occurs when attempting to make an ODBC connection to the SQL Server instance using the dynamic port?

 

Connection failed:

SQLState: '01000'

SQL Server Error: 67

[Microsoft][ODBC SQL Server Driver]DBNETLIB]ConnectionOpen (Connect())

Connection failed:

SQLState: '08001'

SQL Server Error: 17

[Microsoft][ODBC SQL Server Driver]DBNETLIB]SQL Server does not exist or access denied.

 

How can this issue be resolved?

 

Answer / Solution: 

This issue can be caused by attempting to make an ODBC connection by running odbcad32.exe from the Windows\System32 folder on a 64-bit machine.

 

On a 64-bit machine, the ODBC connection should be made by running odbcad32.exe from the Windows\SysWOW64 folder since Kofax Capture is a 32-bit application.

 

To resolve this issue, make the ODBC connection by running odbcad32.exe from the Windows\SysWOW64 folder.

 

Applies to:  

Product Version
CAPTURE 10.0
  10.1
  10.2
  11.0