DSXchange

Hi All

Im using an ODBC stage to pull data. But when i try using that its not resolving connection. Errored out with below message.

DSR.MetaGeta(GET.DSNINFO)(SQLConnect('pscrm3g','sysadm')): BCI Error:
SQLSTATE=08001,CODE=-1,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]TNS-12505: TNS:listener could not resolve SID given in connect descriptor

Is there any configuration setup which i need to do in server ?

I'm able to connect to the same database using an OCI stage.

Kindly suggest me...

Thanks

suresh.narasimha wrote:Hi All

Im using an ODBC stage to pull data. But when i try using that its not resolving connection. Errored out with below message.

DSR.MetaGeta(GET.DSNINFO)(SQLConnect('pscrm3g','sysadm')): BCI Error:
SQLSTATE=08001,CODE=-1,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]TNS-12505: TNS:listener could not resolve SID given in connect descriptor

Is there any configuration setup which i need to do in server ?

I'm able to connect to the same database using an OCI stage.

Kindly suggest me...

Thanks

Hi,

For ODBC stage to work you need a DSN connection. Did you create a DSN connection.

Without proper DSN connection ODBC stage will not work.

Thanks,
sandeep.

TNS:listener could not resolve SID given in connect descriptor

You are able to connect to Oracle through OCI stage, as you have TNS entry in tnsname.ora in you unix box, but connecting through ODBC, you need to mentioned following string in uvodbc.conifg file

<db_handle>
DBMSTYPE = ODBC

and db_handle would be you dsn.

You have to update .odbc.ini file for drivers to be used for this database.

[db_handle]
Driver="DSHOME"/Server/branded_odbc/lib/
VMmsss22.so
Description=DataDirect SQL Server Wire Protocol
Database=db_handle
LogonID=<UserName>
Password=<Password>
Address=<IP,Port>
QuotedId=No
AnsiNPW=No


Regards,
Nitin Swarnkar.