DSXchange

Hi

i need to read a .mdb file and a .dbf file in my job. the server is on AIX. i tried to use the ODBC Enterprise stage,but it works on a DSN.

please let me know how can we configure DSN on the unix server.

As far as i remember Ascential has its own foxpro and dbase drivers and you just need to add you DSN definitions in the .odbc.ini and uvodbc.config files in your DSHOME directory.

The ".mdb" file - is that Microsoft Access? No ODBC driver for Access ships with DataStage - you will need to source a third party driver for operating on UNIX.