Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
mysql openssl Question
mysql:it 's a db not a dbms how it 's possible?!
Does the binary log enabling affect the MySQL performances?
Strange behavior, Table Level Permission
FULLTEXT query format question
Preventing Duplicate Entries
Comparing and writing out BLOBS
Executing MySQL Commands From Within C Program
Can 't access mysql after kernel upgrade
Mysql 4 0 Oracle Stored Procedure Trigger Conversion
Downgrade Mysql from 4 to 3 23
MySQL Cluster Software
mysql test 4 1 fails with the gis test
ERROR 2002: Can 't connect to local MySQL server through socket
Getting Identity after INSERT
Update one field with more fields from another table
ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
mysql have same function mthod as Oracle decode()
 
5.00.08 feedback

5.00.08 feedback

2006-11-21       - By David Dindorp

 Back
Minimally tested Connector/ODBC v5 through MS-Access.

Issues encountered:

1) Connecting without proper GRANT table entries yields:
  "Reserved error (-7711); there is no message for this error"
  instead of the proper access denied message from the server.

2) Trying to export a table containing an euro-sign fails,
  Connector/ODBC chops off everything after the euro sign
  from the query.

3) Trying to export a table containing data with international
  character fails, Connector/ODBC chops the query short by a number
  of characters equal to the number of international characters used
  in a particular query.

4) Trying to export another table containing a boolean column fails,
  an empty string is in the INSERT statement where the data for each
  row's boolean field should be.  Maybe Connector/ODBC removes
  whatever MS-Access inserted there?

5) Trying to export another table containing a smallint column fails,
  an empty string is in the INSERT statement where the data for each
  row's smallint field should be.  Maybe Connector/ODBC removes
  whatever MS-Access inserted there?

6) Trying to export another table succeeds DDL-wise, but fails
  when data would be inserted.  The error message shown is
  [MySQL][MyODBC 5.00.08] Option type out of range (#0).

7) Trying to export another table with many columns fail with
  [MySQL][MyODBC 5.00.08] Driver not capable (#0).
  The CREATE TABLE statement is issued, but seems to be chopped
  around character 1136.

I'm starting to see the same bugs again and again now,
so I'll stop testing this until the above has been fixed.


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=mysql@(protected)