Support Knowledge Base
Login Registration
Contents

Invalid String or Buffer Length

Reported for version 9

Problem

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)

Solution

  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="com.microsoft.sqlserver.jdbc.SQLServerDriver" name="DriverName"
url="jdbc:sqlserver://yourHostName:1433;databaseName=yourDBName"
user="yourUser" password="yourPassword"/>