An Open Source SQL server.

Runs on many platforms: Many Unixes (Linux, Free BSD, HP-UX, SGI Irex, SCO, and more), Windows, Mac, and more.

My SQL was originally developed to handle very large databases much faster than existing solutions and has been successfully used in highly demanding production environments for several years. Though under constant development, My SQL today offers a rich and very useful set of functions. The connectivity, speed, and security make My SQL highly suited for accessing databases on the Internet.

There are windows odbc drivers ( MyOdbc ) for it. http://www.mysql.com/documentation/mysql/bychapter/manual_ODBC.html

All for free.

Well, free as long as you don't want to sell your application, if I read the license correctly:

The Commercial License, which allows you to provide commercial software licenses to your customers or distribute My SQL - based applications within your organization. This is for organizations that do not want to release the source code for their applications as open source / free software; in other words they do not want to comply with the GNU General Public License (GPL).

-- from http://www.mysql.com/company/legal/licensing/

http://www.mysql.com

---

NOTE: There are problems with the latest My SQL ODBC driver with some versions of VFP on some OSes. The MyODBC driver version 3.51 will throw C5 and/or connectivity errors with VFP 7 SP 1 on Windows 98 SE. I don't know if the problem is with the version of VFP, the OS, or both.

The older 2.5x ODBC driver works with this configuration. The My SQL website doesn't make it easy to find, though. You can get it at:

http://downloads.mysql.com/archives.php?p=myodbc-2.50

-- Ken Dibble

---

[2005.04.04] MyODBC 3.35.11 seems to have addressed the problems that were occurring with the earlier .10 version - ?tr

[2005.01.24] MyODBC 3.51.09 seems to work okay with VFP 8 and xCase. The recent "production" version, 3.51.10, is filling up the support forums with complaints. You can find the earlier version on any of the My SQL ftp mirrors.

Note that you will need to use the older password hash method with driver 3.51.09 if you are using the latest My SQL. Details at::
http://dev.mysql.com/doc/mysql/en/old-client.html

Use your favorite ftp client to navigate to

ftp://mirror.services.wisc.edu/mirrors/mysql/

(or any of the other ftp sites listed at http://dev.mysql.com/downloads/mirrors.html)

Follow the links/folders down to: Downloads/MyODBC3

You're looking for a file named MyODBC-3.51.9-win.exe

ftp://mirror.services.wisc.edu/mirrors/mysql/Downloads/MyODBC3/MyODBC-standard-3.51.9-win.exe

-- Ted Roche

---

See http://www.freesql.org - Free Database Hosting For Developers

---

See also: VFP my SQL Linux P 1 http://groups.yahoo.com/group/vfpmysql and http://www.mysqlfront.de {{ William Sanders }}

---

My SQL Administrative Front Ends
Browser-based: MyPHPAdmin
Desktop-based: MySQLcc, SQLyog

My SQL Query Browser: http://www.mysql.com/products/tools/query-browser/
My SQL Admin: http://www.mysql.com/products/tools/administrator/

-- David Fung

---

Category Data Category Database Alternatives