It is something to do with the user, as I have now created a user called "tester", changed my connection string and when I try and add the table stock to my remote view I get the error table tester.stock doesn't exist, does that help?
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Chris Davis Sent: Thursday, 25 January 2018 22:21 To: profoxtech@leafe.com Subject: RE: MariaDB
Well there is no code as such
The connection in the DBC has the following connection string
DRIVER={MariaDB ODBC 3.0 Driver};UID=root;PWD=xxx;DESCRIPTION={MariaDB via ODBC};SERVER=localhost;DATABASE=mydb;PORT=3306;
The mydb database has one table called stock.
When I create a remote view and select the connection it correctly offers me "stock" as a table I can add to the view but then crashes with that error saying table root.stock does not exist.
If I do some code i.e.
lnConnection=sqlconnect("myconnection")
sqlexec(lnConnection,"select * from stock")
that works fine and retrieves the records without error.
So my question is why won't it work with the remote view designer?
I have done exactly the same in the past with MySQL without issue.
I have tried both v2 and v3 of the ODBC drivers from the MariaDB site.
If there is anything else you can think of that I can provide to help I will.
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, 25 January 2018 22:12 To: profoxtech@leafe.com Subject: Re: MariaDB
Can you give us the code?
I don't do Marina but you may be in the wrong database on the server as a guess. I know people long ago were connecting and being in Master database thinking they were in their own db.
This is a part of the connection string.
On Thu, Jan 25, 2018 at 3:15 PM, Chris Davis chrisd@actongate.co.uk wrote:
I guess just for ease when designing forms etc and having the view on the data environment , also interested in why it just doesn't work
My table is called stock and I get the error saying root.stock doesn't exist!
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, 25 January 2018 21:11 To: profoxtech@leafe.com Subject: Re: MariaDB
Make the views on the actual database. From there you can call them.
One question is why use a view instead of a stored procedure?
On Thu, Jan 25, 2018 at 3:01 PM, Chris Davis chrisd@actongate.co.uk 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]