Test data connection with scripterror and variable

yoyo_le_landais — Tue, 08 Mar 2022 16:00:39 GMT

Hello everybody,
I want to test my sgbd connection before to launch the download of data.
So,i simule a try catch with qliview with ErrorMode=0;

set ErrorMode=0;
OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=patient;Data Source=TDV03DVGHT211;Extended Properties=""] (XPassword is TOTOZKeGYYIGTBNKDbcGYJOATYIGTBNKDbcGYJOATYIGTBNKDbcGYJOADeB);
ErrorLog:
LOAD
'$(ScriptErrorCount)' as vScriptErrorCount,
'$(#ScriptError)' as vScriptErrorNo,
'$(ScriptError)' as vScriptError,
'$(ScriptErrorDetails)' as vScriptErrorDetails
AutoGenerate(1);

This script it's OK but when i varies my connexion string, it'KO...

set ErrorMode=0;
$(vCONNEXION);
ErrorLog:
LOAD
'$(ScriptErrorCount)' as vScriptErrorCount,
'$(#ScriptError)' as vScriptErrorNo,
'$(ScriptError)' as vScriptError,
'$(ScriptErrorDetails)' as vScriptErrorDetails
AutoGenerate(1);

The variable ScriptError is empty 😞
Have you an idea why ? how can i get around this ? do you have another solution ?
Thanks a lot.
Lionel

topic Test data connection with scripterror and variable in Connectivity & Data Prep

Test data connection with scripterror and variable