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
ODBC configuration
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 81
- Joined: Mon Nov 21, 2005 4:17 am
- Location: Sydney, Australia
- Contact:
ODBC configuration
SURESH NARASIMHA
Re: ODBC configuration
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.
Re: ODBC configuration
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.
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.