You will need to install an ODBC driver for MySQL. The .msi installer for MariaDB is not bundled with an ODBC-driver. The driver from Oracle should work with MariaDB as well (http://dev.mysql.com/downloads/connector/odbc/). Monty AB+SkySQL have a C-connector and a JAVA-connector of their own breed - but not ODBC drivers or .NET connectors currently. But *all* drivers/connectors from Oracle should work with MariaDB.

Note that if your application is 64 bit you will need the 64 bit ODBC driver - a 64 bit application on Windows cannot use a 32 bit driver.  If your application is 32 bit you can use both the 32 bit and 64 bit driver (the latter only on 64 bit systems obviously). However on a 64 bit system a 32 bit driver will not show up in Control Panel .. Administration .. Data Sources.  However there is a 32 bit version of the ODBC manager ('odbcad32.exe') in the SysWOW64 folder on 64 bit Windows systems where the 32 bit driver will show up after being installed (refer for instance: http://faq.webyog.com/content/17/187/en/problems-creating-a-functional-dsn-on-64-bit-windows.html)


Peter
Webyog


On Tue, Jul 9, 2013 at 4:25 PM, AskMonty KB <noreply@askmonty.org> wrote:
Hello,

A new question has been asked in "A MariaDB Primer" by marcw:
--------------------------------
Hi,

I'd like to use MariaDB to back-end a system that expects an ODBC interface.

Is there a way to create a system DSN for MariaDB in Windows 7?  It's not showing up as a connection type in the Data Sources panel.
--------------------------------

To view or answer this question please visit: http://kb.askmonty.org/en/creating-a-system-dsn-for-mariadb-on-windows/

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp