Getting an error while writing or updating the access db

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
knnath
Premium Member
Premium Member
Posts: 6
Joined: Tue Oct 10, 2006 7:07 pm

Getting an error while writing or updating the access db

Post by knnath »

Hi,

We were able to connect to ms acces via ODBC

but while writing or updating the access table via ODBC, we are getting below error

ODBC_Connector_10,0: ODBC function "SQLSetStmtAttr(SQL_ATTR_PARAMSET_SIZE)" reported: SQLSTATE = HYC00: Native Error Code = 106: Msg = [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 533)

ODBC_Connector_10,0: ODBC function "SQLSetStmtAttr(SQL_ATTR_PARAMSET_SIZE)" reported: SQLSTATE = HYC00: Native Error Code = 106: Msg = [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented (CC_OdbcDBStatement::executeUpdate, file CC_OdbcDBStatement.cpp, line 808)

do we need to do anything more or download anything more to write/update in to ms-access tables via odbc.
narendra
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

We know, you already posted that in your other post. In your shoes, I would take that question to your official support provider.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply