Is there an equivalent of Open Database Connectivity (ODBC) in Linux? I am running Microsoft SQL on four servers and have asked companies in my area about converting to MySQL. Alas, I have been unable to find the expertise. I wouldn't mind running Linux on all desktops, but I would need an ODBC equivalent. As a football club we sell tickets on match day from approximately 22 PCs. I have to have a SQL license for each of these machines, but only four are used daily; the other 18 are used fortnightly for approximately three hours for 14 games. Maybe there is an ODBC equivalent in Linux, but I couldn't find it.
From your question it is not clear whether you are trying to replace the desktop or to move MS SQL server to MySQL. There are a number of desktop tools that can provide a GUI SQL environment to replace your MS Windows application that interfaces to an SQL server.
I have not yet seen a connector for Linux desktops that will allow you to connect to an MS SQL server. There are tools like ksql, pgaccess and TkSQL that will allow you to connect to an MySQL or Postgresql backend server. These tools are available in open source both for MS Windows and for Linux/Unix. Additionally, the ODBC drivers for MySQL or Postgresql allow native MS applications like MS Excel and MS Access to access SQL backend data from MySQL and Postgresql respectively.
In most cases you will find the MySQL and Postgresql performance equal to or better than MS SQL running on tha same hardware under MS Windows 2000 Advanced Server.
>> For more information and links on ODBC, check out this definition on SearchVB.com.
This was first published in March 2003