odbc

kishoreramachandran · Wed Dec 27, 2006 10:18 am

how to install a odbc driver on my machine

chulett · Post by **chulett** » Wed Dec 27, 2006 10:22 am

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

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

kishoreramachandran · Wed Dec 27, 2006 10:24 am

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.

kishoreramachandran · Wed Dec 27, 2006 10:26 am

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

DSguru2B · Post by **DSguru2B** » Wed Dec 27, 2006 10:27 am

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.

kishoreramachandran · Wed Dec 27, 2006 10:28 am

yes , I am not able to connect to the database

DSguru2B · Post by **DSguru2B** » Wed Dec 27, 2006 10:30 am

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'

kishoreramachandran · Wed Dec 27, 2006 10:32 am

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

chulett · Post by **chulett** » Wed Dec 27, 2006 10:34 am

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.

chulett · Post by **chulett** » Wed Dec 27, 2006 10:35 am

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.

kishoreramachandran · Wed Dec 27, 2006 10:36 am

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

DSguru2B · Post by **DSguru2B** » Wed Dec 27, 2006 10:37 am

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.

narasimha · Post by **narasimha** » Wed Dec 27, 2006 11:18 am

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.

kishoreramachandran · Post by **kishoreramachandran** » Wed Dec 27, 2006 1:42 pm

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

narasimha · Post by **narasimha** » Wed Dec 27, 2006 1:47 pm

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