Apr 28, 2016 Getting Microsoft SQL server data into MariaDB with the CONNECT storage engine Step 1. Microsoft is kind enough to supply us with an ODBC driver for Linux. We now install unixODBC using the builddm.sh script provided by the package.
Active2 years, 8 months ago
I have SQL Server 2008 SP4 instance accessing a linked server that is running a MediaWiki database on MariaDB (v 5.5.44). I am able to select from the table no problem:
But when I try to update the table:
I get the following error message:
The user has full permissions, so that shouldn't be an issue. I'm also able to make updates against other linked servers running MySQL. Any help is hugely appreciated. Thanks!
EDIT: I am able to get around this by building a dynamic query string and executing it at the linked server, mostly just curious as to why this is happening at this point.
chazbot7
chazbot7chazbot7
2 Answers
What kind of ODBC driver do you use? There are 2, MariaDB one, and MySQL one. This looks like a bug in one of these ODBC. Now what does 'def' mean. There is a great amount of confusion in MySQL world about catalog, database and schema. MySQL result sets are returned with metadata (column info description). Column info contains several fields, among them 'table catalog' (always hardcoded 'def') , and also 'table schema', aka database. Catalog does not have any meaning currently, and never had, but who knows maybe it could mean something in the future. 'schema' on the other hand, is something that you can put into UPDATE command ( UPDATE schema.table SET field=value WHERE ...) . So the bugs seems to be is that one of the ODBC drivers incorrectly chooses 'catalog' over 'schema'.
Vladislav VaintroubVladislav Vaintroub
I second Vladislav here. 'def' is used as catalog value(if you look in columns metadata returned by server, or in INFORMATION_SCHEMA tables 'TABLES' or 'COLUMNS'. Both MySQL and MariaDB connectors return table's schema as catalog, and NULL as schema.
It must be that MariaDB Connector/ODBC has but and returns 'def' somewhere in metadata as schema(or catalog?). What version do you use? In fact it could be fixed in latest version. But please better proceed in the JIRA issue created by Vladislav
RBT11.1k77 gold badges9090 silver badges115115 bronze badges
Lawrin NovitskyLawrin Novitsky
Not the answer you're looking for? Browse other questions tagged sql-servermariadbopenquery or ask your own question.
Code status:
- travis-ci.org (10.4 branch)
- ci.appveyor.com
MariaDB: drop-in replacement for MySQL
MariaDB is designed as a drop-in replacement of MySQL(R) with morefeatures, new storage engines, fewer bugs, and better performance.
MariaDB is brought to you by the MariaDB Foundation and the MariaDB corporation.Please read the CREDITS file for details about the MariaDB Foundation,and who is developing MariaDB.
MariaDB is developed by many of the original developers of MySQL whonow work for the MariaDB Corporation, the MariaDB Foundation and bymany people in the community.
MySQL, which is the base of MariaDB, is a product and trademark of OracleCorporation, Inc. For a list of developers and other contributors,see the Credits appendix. You can also run 'SHOW authors' to get alist of active contributors.
A description of the MariaDB project and a manual can be found at:
As MariaDB is a full replacement of MySQL, the MySQL manual athttp://dev.mysql.com/doc is generally applicable.
Help
More help is available from the Maria Discuss mailing listhttps://launchpad.net/~maria-discussand the #maria IRC channel on Freenode.
![Convert sql to mariadb Convert sql to mariadb](https://www.mssqltips.com/tipimages2/3425_1.jpg)
Live QA for beginner contributors
MariaDB has a dedicated time each week when we answer new contributor questions live on Zulip and IRC.From 8:00 to 10:00 UTC on Mondays, and 10:00 to 12:00 UTC on Thursdays,anyone can ask any questions they’d like, and a live developer will be available to assist.
New contributors can ask questions any time, but we will provide immediate feedback during that interval.
Licensing
NOTE:
MariaDB is specifically available only under version 2 of the GNUGeneral Public License (GPLv2). (I.e. Without the 'any later version'clause.) This is inherited from MySQL. Please see the README file inthe MySQL distribution for more information.
License information can be found in the COPYING file. Third partylicense information can be found in the THIRDPARTY file.
Bug Reports
Bug and/or error reports regarding MariaDB should be submitted at:https://jira.mariadb.org
For reporting security vulnerabilities see:https://mariadb.org/about/security-policy/
Bugs in the MySQL code can also be submitted at:https://bugs.mysql.com
The code for MariaDB, including all revision history, can be found at:https://github.com/MariaDB/server