Page 1 of 1

Connect to MS Access

Posted: Thu Mar 29, 2007 12:46 pm
by Sanket_Saraph
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...

Posted: Thu Mar 29, 2007 1:15 pm
by kcbland
DS --> SQL-Server --> MS-Access

Posted: Thu Mar 29, 2007 1:24 pm
by Sanket_Saraph
Hi Kenneth,

Could you please elaborate it, please?

Thanks,
Sanket...

Posted: Thu Mar 29, 2007 1:52 pm
by kcbland
Link MS-Access to SQL-Server. DS supplies ODBC drivers for Unix-->SQL-Server.

Posted: Thu Mar 29, 2007 4:05 pm
by ray.wurlod
This is because Data Direct do not provide an ODBC driver, based on UNIX, for connection to MS Access.