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-o... ) 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