How to connect MS access tables from datastage server editio

sree569 · 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 · 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.

sree569 · 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

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

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 · 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.bodduluri · 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/