DSXchange

when i use odbc stage to viewdata, report error. error message:##E TOSH 000205 16:56:58(005) <main_program> PATH search failure: ##E TOSH 000000 16:56:58(006) <main_program> Error loading "orchodbc": Could not load "orchodbc": 0509-130 Symbol resolution failed for /app/dsadm/Asce...

this error message coming when i attempt to import ODBC table definitions.

i has been config .odbc.ini , uvodbc.config , dsenv , .profile; but use dssh->LOGTOT->DS_CONNECT connect greenplum is successful, but use datastage-designer tool and choose odbc stage faile to greenplum. error message:DSR.MetaGeta(GET.TABLES)(SQLFetch): BCI Error: SQLSTATE=24000,CODE=0,[DataStage][S...

i can use DS_CONNECT tools connect Greenplum,but when use datastage designer tools define tables, system is error.


error message:
DSR.MetaGeta(GET.TABLES)(SQLFetch): BCI Error:
SQLSTATE=24000,CODE=0,[DataStage][SQL Client]Invalid cursor state

tkbharani, can you tell config steps details? thank you

i has been accroding to your methds, and use example tools test odbc, resault is succesfull. but use DataStage Designer to define table use odbc methds, resault is faile.

who can tell me?
how config odbc connect greenplum on datastage?
please tell me details steps, thank you very much.


my os config:
ds version:7.5.2
os version:aix 5.3
greenplum version:4.1