Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
Sanket_Saraph
Participant
Posts: 20 Joined: Tue Jun 13, 2006 5:16 am
Location: Pune
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...
SANKET SARAPH
kcbland
Participant
Posts: 5208 Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:
Post
by kcbland » Thu Mar 29, 2007 1:15 pm
DS --> SQL-Server --> MS-Access
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Sanket_Saraph
Participant
Posts: 20 Joined: Tue Jun 13, 2006 5:16 am
Location: Pune
Post
by Sanket_Saraph » Thu Mar 29, 2007 1:24 pm
Hi Kenneth,
Could you please elaborate it, please?
Thanks,
Sanket...
SANKET SARAPH
kcbland
Participant
Posts: 5208 Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:
Post
by kcbland » Thu Mar 29, 2007 1:52 pm
Link MS-Access to SQL-Server. DS supplies ODBC drivers for Unix-->SQL-Server.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.