Reading Access and Dbase files

pavankvk · Post by **pavankvk** » Thu Oct 25, 2007 11:10 am

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.

us1aslam1us · Post by **us1aslam1us** » Thu Oct 25, 2007 1:06 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 25, 2007 2:53 pm

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.