IIS-CONN-ODBC-000004

ysrini9 · Post by **ysrini9** » 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

gssr · Post by **gssr** » 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.

ray.wurlod · Post by **ray.wurlod** » 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.