https://community.qlik.com/t5/App-Development/Connecting-to-a-database/m-p/1819624#M67191 <P>I assume this is it<BR />yes the installation is multi-node<BR />sounds reasonable<BR /><BR /></P> Sun, 04 Jul 2021 14:02:12 GMT ali_hijazi 2021-07-04T14:02:12Z https://community.qlik.com/t5/App-Development/Connecting-to-a-database/m-p/1819621#M67189 <P>Hello<BR />got a QVF file in which I'm connecting to a database using OLEDB</P><P>when I run the script it finishes successfully<BR />however when I created a task on this QVF file and I run the task I get the below error every time:<BR />Connector connect error: IDataInitialize::GetDataSource. HRESULT = 80004005. ErrorSource: OraOLEDB, ErrorMsg: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA</P><P>Any idea what could possibly be wrong?<BR />kindly advise</P> Sun, 04 Jul 2021 10:30:56 GMT https://community.qlik.com/t5/App-Development/Connecting-to-a-database/m-p/1819621#M67189 ali_hijazi 2021-07-04T10:30:56Z https://community.qlik.com/t5/App-Development/Connecting-to-a-database/m-p/1819623#M67190 <P>Are you running this on the same server machine? If you have multiple nodes, you may be running your manual reload on one node, and the task-based reload on another node which may lack the required TNS information.</P> Sun, 04 Jul 2021 12:37:29 GMT https://community.qlik.com/t5/App-Development/Connecting-to-a-database/m-p/1819623#M67190 Or 2021-07-04T12:37:29Z https://community.qlik.com/t5/App-Development/Connecting-to-a-database/m-p/1819624#M67191 <P>I assume this is it<BR />yes the installation is multi-node<BR />sounds reasonable<BR /><BR /></P> Sun, 04 Jul 2021 14:02:12 GMT https://community.qlik.com/t5/App-Development/Connecting-to-a-database/m-p/1819624#M67191 ali_hijazi 2021-07-04T14:02:12Z