The database name is not root but the username is > On 25 Jan 2018, at 22:04, Ted Roche <[email protected]> wrote: > > 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 <[email protected]> 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 <[email protected]> wrote: >>>> >>>> On Thu, Jan 25, 2018 at 4:01 PM, Chris Davis <[email protected]> >>>> 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]
_______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
