I'm using the following connection string to import an external table to PI-AF:
Provider=MSDASQL;Password=<PASSWORD>;Persist Security Info=True;User ID=MYUSER;Data Source=P1WEB3
This works perfectly fine, except that performance is very slow, because there are to many rows to import. So I tried to change this to a linked table, but I get the following error message:
Unable to link to external table: An invalid password was configured for table 'P1WEB3'.
The password is correct. It works fine with the imported table, but not with the linked table. I already tried to find answers on PI squre, but wasn't successfull. Can someone help me with this?