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