Ask the Expert

Is there an ODBC equivalent in Linux?

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.

Requires Free Membership to View

Go to http://www.mysql.com/downloads/api-myodbc-3.51.html for the latest ODBC drivers for MySQL. There are ODBC drivers for Linux as well as for your MS Windows clients.

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: