Programs known to work with MyODBC.

Most programs should work with MyODBC, but we we have tested these ourselves or got a confirmation from some user that is works:

Program

Comment

Access

To make Access work:

• You should have a primary key in the table.
• You should have a timestamp.
• Only use double float fields. Access fails when comparing with single floats.
• Set 2 in the options field when connection to MySQL.

Excel

Works. Some tips

• If you have problems with dates try to select them as strings.

  SELECT concat(sunrise_time), concat(sunset_time) FROM sunrise_sunset;
  

  Values returned in this format (string) should be correctly recognised by Excel97 as time values. What concat() does in this case is that it fools ODBC to think the column is of 'string type'. Without the 'concat()' ODBC knows the column is of time type. Excel does not understand that. Note that this is a bug in Excel because it automaticly converts a string to a time. This would be great if the source was a text file, but this is plain stupid when the source is a ODBC connection which reports exact types for each column.

odbcadmin

Test program for ODBC.

Delphi

One must use DBE 3.2 or newer.

C++Builder

Tested with BDE 3.0. The only known problem is that when the table schema changes, query fields are not updated. BDE however does not seem to recognise primary keys, only the index PRIMARY, though this has not been a problem.

Go to the first, previous, next, last section, table of contents.