Issue while trying to use ODBC stage...

[ds_ram]

Hi,
We have DS installed on Unix(Solaris).I created a dsn (non-wired
protocol) for oracle in DataStage Server 7.5.1a. I have done the
configuration settings in .odbc.ini and uvodbc.config. Also made
the changes required in the uvodbc.config
Projects/<projectname>. I tested the connections and was able
query the database correctly from the DS prompt.
But when i use an odbc stage, I am not getting the dsn in the
dropdown list. Also when I use the ODBC TABLE DEFINITIONS for
import, I am able to see the DSN there but not able to connect
with correct usernames and passwords. Please help me in
resolving this.

[kris]

Is there any reason why you have chosen non-wired protocol?
Did you try other Oracle Wire Protocol?

It seems like you did everything right as you were able to test the connection from uv. Did you test using DS_CONNECT from uv?

Out of curiosity, what do you need odbc for? What about your Oracle plug-ins? do they work?

[ds_is_fun]

Is Oracle on the same server as DS is? Then you don't need ODBC stage.
If Oracle is on a difft server then you need to config your Oracle wire protocol for ODBC stage.

Is there any reason why you have chosen non-wired protocol?
Did you try other Oracle Wire Protocol?

It seems like you did everything right as you were able to test the connection from uv. Did you test using DS_CONNECT from uv?

Out of curiosity, what do you need odbc for? What about your Oracle plug-ins? do they work?

[chulett]

If Oracle is on a difft server then you need to config your Oracle wire protocol for ODBC stage.

Or install an Oracle client on your DataStage server and use OCI.