ODBC Connection error

Aster

ODBC Connection error

Hi all,

I'm trying to create a simple ODBC connection using a couple of 3rd party tools called:  Aqua Data Studio and Razor SQL.   First, I followed the steps in the Aster nCluster user guide to create the DSN ODBC connection on a Windows 7 x64 SP1 desktop.  I was able to test the connection succesfully.

However, when I use the DSN in Aqua Data Studio or Razor SQL (as mentioned above), I receive the following error message:

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

    at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)

    at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)

    at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3907)

    at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5698)

    at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:354)

    at sun.jdbc.odbc.JdbcOdbcConnection.buildTypeInfo(JdbcOdbcConnection.java:1503)

    at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:381)

    at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)

    at \...\ .\हिñçêČάй語简�?한\.vꉤ ꇖ͌.b(Unknown Source)

    at \...\ .\हिñçêČάй語简�?한\.vꉤ ꇖ͌.f(Unknown Source)

    at \...\ .\हिñçêČάй語简�?한\.gꍩ⡢ꀀ̦ 6.vE(Unknown Source)

    at \...\ .\हिñçêČάй語简�?한\.gꍩ⡢ꀀ̦ 6.getConnection(Unknown Source)

    at \...\ .\हिñçêČάй語简�?한\.gꍩ⡢ꀀ̦ 6.getConnection(Unknown Source)

    at \...\ .\हिñçêČάй語简�?한\.jꇌᜯꄉꋿ.process(Unknown Source)

    at \...\ .\हिñçêČάй語简�?한\.Q⣂ꐈ⢶ᢅ.run(Unknown Source)

This error is occurring using the latest Aster 64-bit ODBC driver version 5.00.00.00.   Any help would be greatly appreciated!

Thanks,

Frank

1 REPLY
Teradata Employee

Re: ODBC Connection error

Aster Database is compatible with ADS version 10.0.2 with patch ads-10.0.7_03-patch.zip.

Please see Section “Connect Reporting Tools to Aster Database” in “Aster Client Guide 0511”