What do you think "root" is in reference to? Is that the database name?
If so, try to add a different table and see if you get the same error.
On Thu, Jan 25, 2018 at 4:53 PM, Chris Davis chrisd@actongate.co.uk wrote:
If i create a new remote view , pick the connection , I see my table stock listed , I add the table to the view and then I get an error saying table root.stock does not exist
On 25 Jan 2018, at 21:41, Ted Roche tedroche@gmail.com wrote:
On Thu, Jan 25, 2018 at 4:01 PM, Chris Davis chrisd@actongate.co.uk wrote:
I have a server working, a database and table created ... I can do "select * from mytable" using sqlexec but I can't create a remote view with the same table on.
Please explain "can't create?" What are you doing? Are you getting an error message?
-- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com
[excessive quoting removed by server]