AnsweredAssumed Answered

Linked table / invalid password

Question asked by JIrnsinger on Oct 6, 2017
Latest reply on Dec 22, 2017 by mskallet

Hi there,


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?