exec SQL with OLEDB provider
Trying to get 'exec SQL' to work in DE6.53 and DE8.5 and get the same issue.
Connection must be to DB via OLEDB provider which is defined in a UDL file.
The same database link is defined in database links with UDL file and works A-ok for normal DQL actions.
The following statement gives an error 1 parsing script error.
exec SQL connect TESTDB to OLEDB provider c:\testDB.udl as TEST PWD .