Apex - Server Connection not accepted

Question

so I currently have to work with Apex for the first time. My job is to make a Page that displays data previously sent by E-Mail.

I now have a "Interactive Report" set up and theoretically only have to add some SQL-Query code to get the data.

I dicided to use the "Local Database" as source and "SQL-Query" as Type. The code I wrote is select * from lu34pisi14vm.org.

But when I use this code the error message connection description for remote database not found pops up.

Does someone know why and how to fix this?

Kind regards Elias

Answer 1

The simplest option is to use

• location: local database (as you did)
• type: table / view (instead of SQL Query)
• table owner: usually set to "parsing schema"
• table name: select it from list of values - doing so, you can't miss

Because, error you got suggests that you're using a database link which is invalid.