Comments - External (Connect) Tables read-only after MariaDB upgrade from 10.0.12.0 to 10.0.15.0
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
I am not sure I understood correctly your problem. My last comment was because I thought you had problem using MariaDB via ODBC.
Now I understand you try to modify some CONNECT ODBC tables created on extenal MSSQL tables. By MSSQL do you mean Microsoft Access or Microsoft SQL Server?
I don't have SQL Server installed but using Access or Oracle I could normally read, insert, update or delete from CONNECT ODBC tables created on theseservers provided the remote database is not readonly. But this depends on the ODBC database, not on CONNECT. This of course using MariaDB version 10.0.15.
Hi,
Yes I connect from MariaDB to an external MSSQL server (SQL 2008). I haven't tried with Oracle or Access. But I got it on both servers. Everything works in 10.0.12, but when I upgrade everything becomes read-only and when I roll-back everything works again.
But I will make a new development server soon to start debugging possible causes (maybe there are ODBC upgrades available since I am connecting from a Windows Server 2008 to a Windows Server 2008). So the remote database is not read only, but will try in a couple of days to set up a new environment and check the ODBC driver. Thanks so far.
Did you ever manage to find the cause of the problem?
Yes, the problem got solved with MariaDB support. I was using a srcdef query for retrieving the data. After switching to the tabname (which I couldn't get working in 10.0.12 and that's the reason I used srcdef) everything worked.