Page 1 of 1
Writing to .mdb file via datastage
Posted: Sun Jan 22, 2012 11:18 pm
by knnath
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
Posted: Mon Jan 23, 2012 12:11 am
by chulett
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.
Posted: Mon Jan 23, 2012 1:24 am
by ray.wurlod
Welcome aboard. When's the interview?
Posted: Mon Jan 23, 2012 1:37 am
by knnath
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.
Posted: Mon Jan 23, 2012 8:26 am
by chulett
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".
Posted: Mon Jan 23, 2012 3:18 pm
by ray.wurlod
Craig meant "import it into Access using Access".
Posted: Mon Jan 23, 2012 3:37 pm
by chulett
Yes, that.
Posted: Fri Feb 03, 2012 3:59 pm
by knnath
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.
Posted: Fri Feb 03, 2012 8:48 pm
by ray.wurlod
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.
Posted: Tue Feb 07, 2012 6:19 pm
by knnath
that helped, iam able to connect to Access DB. Thank you so much.
Posted: Tue Feb 07, 2012 6:37 pm
by ray.wurlod
Please mark the thread as Resolved using the green button at the top of the screen.
Posted: Tue Feb 14, 2012 11:36 am
by knnath
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.