Connect to MS Access

Sanket_Saraph · Post by **Sanket_Saraph** » Thu Mar 29, 2007 12:46 pm

Hi All,

I wanna make connection to MS Access through DataStage PX(7.5.1A), OS: Unix .

Did anyone successfully make it?
I have explored the previous topics but got confused.

Can we connect without Datadirect or is it necessary?

Please give the steps do the same.

Thanks a lot,
Sanket...

kcbland · Post by **kcbland** » Thu Mar 29, 2007 1:15 pm

DS --> SQL-Server --> MS-Access

Sanket_Saraph · Post by **Sanket_Saraph** » Thu Mar 29, 2007 1:24 pm

Hi Kenneth,

Could you please elaborate it, please?

Thanks,
Sanket...

kcbland · Post by **kcbland** » Thu Mar 29, 2007 1:52 pm

Link MS-Access to SQL-Server. DS supplies ODBC drivers for Unix-->SQL-Server.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 29, 2007 4:05 pm

This is because Data Direct do not provide an ODBC driver, based on UNIX, for connection to MS Access.