Did you try it from the Command prompt?: CREATE [SQL] VIEW [ViewName] [REMOTE] CONNECTION ConnectionName [SHARE] | CONNECTION DataSourceName] AS SQLSELECTStatement]
p.s. when checking this I came across the CREATE VIEW command (.vue files) - I do not remember ever using this, or even knowing it existed - anyone use it?
On 26-Jan-2018 2:31 AM, Chris Davis wrote:
Hi All
Just wondered if anyone out there is using MariaDB as a back end but using remote views in a DBC with it?
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.
Any help you could give would be appreciated.
Thanks
Chris.
This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]