MySQL Manual
9 MySQL APIs
- 9.2 MySQL ODBC Support
- 9.2.1 How To Install MyODBC
- 9.2.2 How to Fill in the Various Fields in the ODBC Administrator Program
- 9.2.3 Connect parameters for MyODBC
- 9.2.4 How to Report Problems with MyODBC
- 9.2.5 Programs Known to Work with MyODBC
- 9.2.6 How to Get the Value of an
AUTO_INCREMENTColumn in ODBC - 9.2.7 Reporting Problems with MyODBC
9.2.4 How to Report Problems with MyODBC
MyODBC has been tested with Access, Admndemo.exe, C++-Builder,
Borland Builder 4, Centura Team Developer (formerly Gupta SQL/Windows),
ColdFusion (on Solaris and NT with svc pack 5), Crystal Reports,
DataJunction, Delphi, ERwin, Excel, iHTML, FileMaker Pro, FoxPro, Notes
4.5/4.6, SBSS, Perl DBD-ODBC, Paradox, Powerbuilder, Powerdesigner 32
bit, VC++, and Visual Basic.
If you know of any other applications that work with MyODBC, please
send mail to myodbc@lists.mysql.com about this!
With some programs you may get an error like:
Another user has modifies the record that you have modified. In most
cases this can be solved by doing one of the following things:
- Add a primary key for the table if there isn't one already.
- Add a timestamp column if there isn't one already.
- Only use double float fields. Some programs may fail when they compare single floats.
If the above doesn't help, you should do a MyODBC trace file and
try to figure out why things go wrong.
User Comments
| Posted by Dot_Cotton on Sunday May 26 2002, @4:13pm | [Delete] [Edit] |
And lotus approach?
| Posted by Maurice Hilarius on Thursday October 10 2002, @5:09pm | [Delete] [Edit] |
Star Office 6.0 ?
| Posted by Stephan Terrill on Monday June 9 2003, @3:10pm | [Delete] [Edit] |
I am running Connector/ODBC 3.51 on windows 2000 profesional. I am also running MySql 4.0. Here is the situation I had: I created a dsn connection; connected and queried to the database just fine. But when I created a dsn-less connection string I got an error: "Can't find odbc driver...". So after of week of researching I had friend duplicate the error and he did. So we decided to uninstall the Connector/ODBC 3.51 and installed the earlier version, Connector/ODBC 2.50. Once we did that the dsn-less connection ran without error. If anyone else has ran into the same problem and has come up with a different solution, Please let me know.
Regards,
Stephan
