DSXchange

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 Micro...

we were able to connect to ms acces via ODBC we were able to read from ODBC into a file 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 C...

that helped, iam able to connect to Access DB. Thank you so much.

our conf. mgmt team downloaded the drivers for ms access but when i try to connect to the odbc stage, i see only sql server info in it. how do i connect via odbc to the ms access DB. and what all i need to do on the ms access side to have the connection from datastage odbc(recently loaded the ms asc...

If generating a flat file and importing it to mdb format, do we need some drivers to be installed? If so please let me know the way how to import it.

Hi,

There is a requirement in our project where we have to generate files in .mdb format. Is it possible via datastage? Please suggest ways how this can be done? If there is an external interface or some drivers to be installed.

Please list out the various ways this can be achieved.

Thanks