Someone told me in [this|Report can be refreshed in DeskI / WebI but not in InfoView; post that besides my native Oracle client, I need to define an ODBC connection to Oracle in order to be able to connect through InfoView to the source database for lets say a simple refresh.
How do I do this?
I go to Admin tools > data sources > system DSN ...
To which fields do following Oracle ODBC parameters refer ?
Data Source Name =? TNSNAMES entry
Description =? Free to choose
User Name = DB User
Serevr =? TNSNAMES entry or DNS address
Does one of the parameters need to be similar to the name of the connection as I see them in the CMC ??
The thing is, I can edit, refresh, create reports with source data in the thin clients, but can't do a refresh in InfoView... Some oracle messge then shows telling me:
SetPrompts failed - Connection or SQL sentence error: (DA0005): [Exception: DBD, ORA-12154: TNS:could not resolve the connect identifier specified State: N/A] A connection required to refresh this document is unavailable. (DA0004):  The following data providers have not been successfully refreshed: Query 1 with PHOENIX. (DMA0007): 
Thanks in advance...