Invalid String or Buffer Length

Reported for version 9


DQC running on a 64-bit system using JDBC ODBC bridge ends with the following error:

java.sql.SQLException: SQL Exception : [Microsoft][ODBC Driver Manager] Invalid string or buffer length)


  1. Copy the <DQC_HOME>\lib\jdbc\mssql\sqljdbc4.jar to the <DQC_HOME>\lib.
  2. Edit the database connections in your DQC IDE.
  3. Edit the database connections in the <DQC_HOME>\server\etc according to the following:

    <dataSource driverclass="" name="DriverName"
    user="yourUser" password="yourPassword"/>