Oracle ODBC connection
Posted: Fri Nov 09, 2007 1:05 pm
I set up an Oracle Wire Protocol ODBC connection to a data source.
When I test the connection from ODBC Data Source Administrator it connects succesfully.
When I try to import a table from that ODBC connection in Designer. I see all the tables in the Oracle DB and I am able to import it.
When I create a the DRS stage I am able to load all the table columns.
But when I view data I get:
GIL_DEM_ITEM..DRS_SRC_ITEM: [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00942: table or view does not exist
GIL_DEM_ITEM..DRS_SRC_ITEM: SQLFetch: Error retrieving results from server.
GIL_DEM_ITEM..DRS_SRC_ITEM.DSLink1: DSP.Open GCI $DSP.Open error -100.
I don't understand how I can use the ODBC datasource to pull the table and columns into the DRS source but the view data gives me an error.
When I test the connection from ODBC Data Source Administrator it connects succesfully.
When I try to import a table from that ODBC connection in Designer. I see all the tables in the Oracle DB and I am able to import it.
When I create a the DRS stage I am able to load all the table columns.
But when I view data I get:
GIL_DEM_ITEM..DRS_SRC_ITEM: [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00942: table or view does not exist
GIL_DEM_ITEM..DRS_SRC_ITEM: SQLFetch: Error retrieving results from server.
GIL_DEM_ITEM..DRS_SRC_ITEM.DSLink1: DSP.Open GCI $DSP.Open error -100.
I don't understand how I can use the ODBC datasource to pull the table and columns into the DRS source but the view data gives me an error.