DSN in UNIX for using in ODBC Stage

[sendtothil]

Hi,
I am using DataStage v7.1 server edition on UNIX.
I need to connect to a sybase database server throught the ODBC stage of datastage.
Where should I do to add a DSN to my datastage server pointing to the sybase database server in order to access the databse through the ODBC stage.
Can anyone help me on this....?

Thanks in advance,
Senthil.

[ray.wurlod]

${DSHOME}/.odbc.ini

[sendtothil]

Hi Thanks for the reply,
I have copied the .odbc.ini file to my
datastage home directory and made the appropriate entries.

But still the DSN entry which i have made is not getting populated in
the dropdowns when i try to import the table definitions....

Any clue on the mistake i am doing...?

Thanks,
Senthil.


[quote="ray.wurlod"]${DSHOME}/.odbc.ini ...[/quote]

[chulett]

Nothing will appear in any dropdown until you actually import something and the value is in the repository. To start things off, you should just be able to type the value in rather than pick it from a list. From what I recall.

[sendtothil]

I am trying to import the tabel definitions through ODBC as follows:
Import -> Table Definitions -> ODBC Table Definitions...

In this option, the DSN dropdown is non-editable.
This is the problem I am facing.

Can you help on this...?

[sendtothil]

I am trying to import the tabel definitions through ODBC as follows:
Import -> Table Definitions -> ODBC Table Definitions...

In this option, the DSN dropdown is non-editable.
This is the problem I am facing.

Can you help on this...?

[chulett]

Sorry, I was thinking of another stage. If you click on the Help button and then on the DSN on the help page, it will tell you where those values must be defined:

This lists all the ODBC data sources defined in the Windows registry for Windows servers or the uvodbc.config file for UNIX servers.