I am developing an AppPart in Sharepoint 2013 and I am having problems when connecting to an external list. The following ways have been my attempts:
- Accesing a external list with an app using the External Content Type. After deploying my new App (called "Hello Administrator") and browsing it, if I go to http://app-12313123.myfirstapp:3000/Lists/myList in order to load the external list, I get a "LobSystem (External System) returned authentication error" when the pages load asynchronously.
- Trying to generate an External Content Type using Designer. First going to Data Sources I am prompted for the connection to the DataBase but I don't know how to build the connection string and I get an authentication error, not being able to generate the connection to access the external lists.
Any ideas? Thank you very much!