DSXchange

Posted: **Fri Jan 28, 2011 2:03 am**

Hi ,

I am getting below error if I use ODBC Connector stage.

[IIS-CONN-ODBC-000004] ODBC function "SQLBindParameter" reported: SQLSTATE = HY104: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC SQL Server Driver]Invalid precision value (CC_OdbcDBStatement::dbsBindInputs, file CC_OdbcDBStatement.cpp, line 301)

If you use DRS stage it is working fine. Any idea why it is giving Fatal error

Thanks and Regards
SHRINIVAS

Posted: **Fri Jan 28, 2011 2:34 am**

Check the precision value of all the columns in your table. Some records are error loading a larger string.
To resolve, increase the length of the colulmn.

Posted: **Fri Jan 28, 2011 5:00 am**

In particular look for any column that has an empty precision value but has a data type that requires precision.

This message comes from the Connector Access Service. None of those messages yet appear in the Information Server messages manual.