Testing scenarios with tables having type External Sql.

(0) Share

Report

Posted on by Kirill Cheremisin

Hi team!

Is it possible to make tests with External Sql tables in NAV 2018?

I made one test and had an error message "Cannot use tables of type External Sql in test isolation.".

I tried different values of TestPermissions and TransactionModel on codeunit and test function. I use the following sintaxt to conntect to External Sql:

REGISTERTABLECONNECTION(
        TABLECONNECTIONTYPE::ExternalSQL,
        "Database Name",
        'Server='+"Server Name"+';'+
        'Database='+"Database Name"+';' +
        'Integrated Security=SSPI;');

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Stefano Demiliani 37,162 Most Valuable Professional on at

Like (1)

Report

RE: Testing scenarios with tables having type External Sql.

Never tested but I'm not so sure you can do that in a test.