DSXchange

how to install a odbc driver on my machine

What 'machine'? What are you trying to accomplish exactly?

ps. They are already installed, they just need to be configured.

I have told that the installation has been done on the server , on my machine what exactly am I suppposed to do. I am not able to see the driver on my machine.

I have been told that the installation has been done on the server.

What are you trying to achieve? Are you trying to connect to a database via odbc stage? Need more info then what you are providing buddy.

yes , I am not able to connect to the database

you need to add entries to two files. uvodbc.config and .odbc.ini on the server. Search this forum for exact details on 'how to'

I was told that the entries have been made for those two files , on my machine what should I do.

Again, what is 'my machine'... your PC? If so then no you won't see them there or do anything with them there. Everything is done on the UNIX server where DataStage is installed.

Assuming we're talking DataStage here and the ODBC drivers that come with it, yes? The ones you would use with the ODBC stage in a job, yes?

Read the Install and Upgrade Guide pdf (dsupgde.pdf) that is in your Docs directory on your PC. In the Installing on UNIX Systems chapter is a discussion on Configuring ODBC Access where what you need to do is explained in detail.

kishoreramachandran wrote:I was told that the entries have been made for those two files , on my machine what should I do.

Find out the name that was setup for your connection and then just use that name in the ODBC stage.

yes I mean my Pc when I say machine . And I want to access the data through odbc stage.

Nothing on your machine, drop the odbc stage on your canvas, open its properties, go to output tab, go to columns tab and click on load. Click on Import...'odbc table definitions'. From the drop down list in 'DSN' you should be able to see the entries that are in the two entries. Chose the one you want, enter username and password, if it lets you through, that means its configured properly. Use that dsn. Its already configured and you dont need to do anything from your end other than use it.

kishoreramachandran wrote:yes I mean my Pc when I say machine . And I want to access the data through odbc stage.

What database are you trying to connect?
Sometimes, if you dont have a DSN set up for that database, you might have to create one yourself.

I am able to see a dsn but when I select it I get the message invalid authorization BCI error

Check this
Do a search an exact search on BCI error, you will get more results