Skip to main content
Kofax

Conversion from type DBNull to type String is not valid error when configuring the Database Export Connector with Sybase Adaptive Server Enterprise

17748

QAID # 17748 Published

Question / Problem:

I received the following error message when configuring Kofax Database Export Connector with Sybase Adaptive Server Enterprise Database:

Kofax Capture Export Connector – Database Setup – Unhandled exception has occurred in a component in your application. If you click Continue, the application will ignore this error and attempt to continue. Conversion from type ‘DBNull’ to type ‘String’ is not valid….

How can I resolve this issue?

Answer / Solution:

The issue is related to Kofax Database Export connector API (Application Programming Interface) changes made in Kofax Capture 10.

There are two solutions to the issue:

  • Install Fix Pack 1 or later for Kofax Capture 10 Service Pack 2. This issue was reported in SPR 114763.
  • The other option is to replace Kofax Capture Database Export files with the files from version 9.0:
    1. Obtain the DBRel.DLL file from a KC 9.0 machine with the latest patches and replace the same file in Kofax Capture 10.
    2. Configure the Release Script, edit the AscRelSC.INF file as follows:
      In the [Scripts] section, add the following line:
      KOFAX Capture Database v9
      Create a new section and enter the associated parameters, as follows:
      [KOFAX Capture Database v9]
      SetupModule=.\DBRel.dll
      SetupProgID=DBRel.kfxreleasesetupscript
      SetupVersion=9.0
      ReleaseModule=.\DBRel.dll
      ReleaseProgID=DBRel.kfxreleasescript
      ReleaseVersion=9.0 SupportsNonImageFiles=True
      SupportsKofaxPDF=True
      RemainLoaded=True
      SupportsOriginalFileName=True
      SupportsMultipleInstances=True
    3. Save the INF file and add this Release Script into your Document Class. Configure as necessary.

Applies to: 

Product Version
CAPTURE 10.0

Keywords: Sybase, Export, SQL_NO_DATA_FOUND, Code 100, Validation, ODBC