Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
sree569
Participant
Posts: 12 Joined: Fri Nov 16, 2007 10:15 pm
Post
by sree569 » Mon May 12, 2008 12:22 pm
Hi All,
I have a job where I need to connect to the MS access tables in a different server and they are stored in a perticular folder in that server.
They are in .mdb format.
May I know if we can access them in any why using any of the stages.
Thanks for your help in advance.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Mon May 12, 2008 2:26 pm
You should be able to access them using an ODBC driver for 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.
sree569
Participant
Posts: 12 Joined: Fri Nov 16, 2007 10:15 pm
Post
by sree569 » Mon May 12, 2008 3:01 pm
Hi Ray,
Thanks for your info. But when i use the ODBC stage in server jobs,what username/pwd do i need to specify..is it the servername userid.pwd or ms access DB username/pwd to access those tables.
Thanks
daignault
Premium Member
Posts: 165 Joined: Tue Mar 30, 2004 2:44 pm
Contact:
Post
by daignault » Mon May 12, 2008 3:26 pm
Try the connection without a userid/password. Microsoft Access is not the most secure environments.....
That's why Diebold uses it for their vote tally machines :(
Ray D
daignault
Premium Member
Posts: 165 Joined: Tue Mar 30, 2004 2:44 pm
Contact:
Post
by daignault » Mon May 12, 2008 3:28 pm
Try the connection without a userid/password. Microsoft Access is not the most secure environments.....
That's why Diebold uses it for their vote tally machines :(
Ray D
prasad.bodduluri
Participant
Posts: 30 Joined: Tue Jan 30, 2007 5:21 am
Location: bangalore
Post
by prasad.bodduluri » Thu May 15, 2008 6:10 am
FIRST OF ALL ,YOU CAN CREATE A DNS IN ADMINISTRATOR TOOL, USERID/PASSWORD IS A DNS, NOT DATA STAGE USERNAME/PASSWORD/
prasad
prasad.bodduluri
Participant
Posts: 30 Joined: Tue Jan 30, 2007 5:21 am
Location: bangalore
Post
by prasad.bodduluri » Thu May 15, 2008 6:11 am
FIRST OF ALL ,YOU CAN CREATE A DNS IN ADMINISTRATOR TOOL, USERID/PASSWORD IS A DNS, NOT DATA STAGE USERNAME/PASSWORD/
prasad