maria-discuss team mailing list archive

[AskMonty KB <noreply@xxxxxxxxxxxx>]

Hello,

A new question has been asked in "CONNECT" by jhtclaessen. Please answer it at http://mariadb.com/kb/en/external-connect-tables-read-only-after-mariadb-upgrade-from-100120-to-1001/ as the person asking the question may not be subscribed to the mailing list.

--------------------------------
Hello,

I am testing MariaDB and I have ODBC connections to MSSQL server. This seemed to work pretty well in 10.0.12.0. After we installed a new 10.0.15.0 we could not get this working, all our external tables reported back as 'read-only'. (SQL Error (1036): Table '.....' is read only).

We started troubleshooting but couldn't figure out why. So we upgraded the 10.0.12.0 version to 10.0.15.0 as well and now we have the same problem there. I see a lot of changes to the Connect Engine in 10.0.13.0, so that might be the problem. But I cannot downgrade anymore, hence we now have a problem, since we cannot use the functionality anymore due to the fact that we cannot update or insert records into another MSSQL database (through triggers).

Does anyone have any clue what could cause this and how to solve this? 

Thanks in advance!
--------------------------------

To view or answer this question please visit: http://mariadb.com/kb/en/external-connect-tables-read-only-after-mariadb-upgrade-from-100120-to-1001/