DSXchange

After re-starting the server, it works well for wire protocol but not for non-wire. But we have the oracle client installed on the machine where the DataStage server is installed. Still we could not connect using non-wire protocol. Can you help me on this?

Hi chulett,
I did all the things as said. Server has also been restarted. but when i tried to import an odbc table i got this error:

Error calling subroutine: DSR_IMPORT (Action=14); check DataStage is set up correctly in project project1
(The connection is broken (81002))

Hi Kommven, I have few questions here. 1. We need to have a separate entry for the dsn(instead of using the template). which should start with the dsn name like [oracle10] ......... right ? 2. Can we keep entries for both wire and non-wire protocols in the same .odbc.ini file ? If yes, in such a cas...

entry in .odbc.ini [Oracle] Driver=/opt/dataStage/Ascential/DataStage/branded_odbc/lib/VMor820.so Description=DataDirect 5.00 Oracle ApplicationUsingThreads=1 ArraySize=60000 CatalogIncludesSynonyms=1 CatalogOptions=0 DefaultLongDataBuffLen=1024 DescribeAtPrepare=0 EnableDescribeParam=0 EnableNcharS...

Hi Shankar
The dbuser has no rights problem. We have given two entries in the file .odbc.ini for both wire and non-wire for Oracle. Does having both of them in the file make an issue ?

Please advise

Hi We are getting the following error while trying to import tables from Oracle 10g DSR.MetaGeta(GET.TABLES)(SQLConnect('castle','hg426c')): BCI Error: SQLSTATE=IM002,CODE=0,[DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Data source name not found and no default driver specified We have defined...

The entry is AUTHENTICATION 1 in the uvconfig file. Is it to be changed?

Check whether any firewall restrictions are there for your server ip?.... I am not usre whether it is a firewall issue. The default port is open. It is a sun solaris server. How can I check whether my server uses PAM authentication or not? If so I need to configure that isn't it? The error message ...

Hi,
We are able to ping the port using telnet. The port is opening without any issuse. But not able to login.

ds_developer wrote:Did you telnet using the server name or an IP? Due to network/domain issues I have to use the IP when I login to DataStage from my workstation.

You might try typing in the IP as the Host Name.

John

It did not help John. I tried that. Thanks.

The ping utility tells you nothing more than that the server machine is visible on the network. In particular, it tells you nothing about software. Can you connect via telnet? If so, can you ve ... I am able to Telnet to the DataStage Server from my client PC. Sorry for the misunderstanding. The ds...

i am able to ping the DS Server

Hi,
I am able to ping using telnet.

Hi DS Gurus, We have our DS Server installed on a unix box. The client on windows machines. We are able to ping the unix box from the client machine. But when we tried to connect the server for the first time to create projects we are not able to do. It is throwing the message "host is not resp...