Writing to .mdb file via datastage

knnath · Post by **knnath** » Sun Jan 22, 2012 11:18 pm

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

chulett · Post by **chulett** » Mon Jan 23, 2012 12:11 am

MDB is the old format for Access database files. I would assume you would either need to obtain ODBC drivers for Access, that or just produce a flat file and import it.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 23, 2012 1:24 am

Welcome aboard. When's the interview?

knnath · Post by **knnath** » Mon Jan 23, 2012 1:37 am

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.

chulett · Post by **chulett** » Mon Jan 23, 2012 8:26 am

knnath wrote:If generating a flat file and importing it to mdb format, do we need some drivers to be installed?

No. And technically, I meant "import it into Access".

ray.wurlod · Post by **ray.wurlod** » Mon Jan 23, 2012 3:18 pm

Craig meant "import it into Access using Access".

chulett · Post by **chulett** » Mon Jan 23, 2012 3:37 pm

Yes, that.

knnath · Post by **knnath** » Fri Feb 03, 2012 3:59 pm

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 asccess on the windows server)

our requirement is , we need to get the data from the oracle dabatase tables and create a .mdb file format file and send it to downstreams.

ray.wurlod · Post by **ray.wurlod** » Fri Feb 03, 2012 8:48 pm

You still need to configure a System DSN to associated the DSN with the mdb file, since DataStage will use the DSN. You also need to "register" the DSN in a uvodbc.config file.

Note: If you are using a 64-bit Windows operating system, use odbcad32.exe in %Windows%\SysWOW64 folder to configure the DSN.

knnath · Post by **knnath** » Tue Feb 07, 2012 6:19 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue Feb 07, 2012 6:37 pm

Please mark the thread as Resolved using the green button at the top of the screen.

knnath · Post by **knnath** » Tue Feb 14, 2012 11:36 am

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