Connecting to a database

[ali_hijazi]

Hello
got a QVF file in which I'm connecting to a database using OLEDB

when I run the script it finishes successfully
however when I created a task on this QVF file and I run the task I get the below error every time:
Connector connect error: IDataInitialize::GetDataSource. HRESULT = 80004005. ErrorSource: OraOLEDB, ErrorMsg: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Any idea what could possibly be wrong?
kindly advise

[Or · Accepted solution]

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.

[ali_hijazi]

I assume this is it
yes the installation is multi-node
sounds reasonable