MySQL Connector/ODBC 5.00.10 Beta has been released

MySQL Connector/ODBC 5.00.10 Beta has been released.
--

MySQL Connector/ODBC is our next generation ODBC driver which allows
access to the MySQL v5 server using the widely used ODBC standard. The
ODBC standard is a cross-platform, cross-database, C language, Call
Level Interface.

This version is being released to get community feedback but is NOT
suitable for production environments.

It is now available in binary form from the Connector/ODBC download
pages at http://dev.mysql.com/downloads/connector/odbc/5.0.html and
mirror sites.

Note: Not all mirror sites may be up to date at this point of time. If
you can't find this version on some mirror, please try again later or
choose another download site.

Install Notes
--

1. Those using the MSI based installer can simply install by 'executing'
the MSI file. Any existing MSI install should automatically upgrade.

2. Those using the noinstaller distribution should unzip the
distribution file and follow instruction found therein.

3. Connector/ODBC v5 can coexist with any existing install of
Connector/ODBC v3.


Changes
--

* FIX: String query parameters are new escaped correctly. (fix bug#19078)
* ENH: Added wide-string type info for SQLGetTypeInfo().
* ENH: Added loose handling of retrieving some diagnostic data. (fix bug#15782)
* ENH: Added initial support for removing braces when calling stored procedures and retrieving result sets from procedure calls. (fix bug#24485)
* ENH: Added initial unicode support in data and metadata. (fix bug#24837)
* ENH: Significant performance improvement when retrieving large text fields in pieces using SQLGetData() with a buffer smaller than the whole data. Mainly used in Access when fetching very large text fields. (fix bug#24876)
* FIX: Editing DSN no longer crashes ODBC data source administrator. (fix bug#24675)

Reporting Issues
--

Issues and questions can be directed to:

* MySQL ODBC mailing list at http://lists.mysql.com/myodbc
* MySQL ODBC forum at http://forums.mysql.com/list.php?37

Bugs can be reported to:

* MySQL Bug tracking system at http://bugs.mysql.com/

From the MySQL Connectors Team - enjoy!


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Problems with MySQL Connector/ODBC 5.00.10 Beta

Hello!

This beta seems to be a big improvement over the previous one. I have tried
connecting to a multilingual MySQL 5 database (InnoDB) using MS Access 2003.

Firstly, Windows does not give an error when creating the data source
(bugfix as advertised).
And secondly, when looking at a linked table in Access, I now see UFT-8 text
properly: Russian, Korean, etc., and not s string of question marks as
before.

But there are hitches:

1 - the connector sees not only the tables but also the Views in the MySQL
database. If in Access to click "Select All" to link all the tables, it
tries to link to the views as well and fails with an error ("Reserved error
(-7729); there is on message for this error.")

2 - some rows in a multilingual table, for no apparent reason have "#Error"
marked for all their values. These rows are quite usable by other programmes
(Navicat, for example).

3 - if I leave this table open in Access, then every minute or so, a pop-up
appears: "Reserved error (-7776); there is on message for this error." And
after a certain time (a few minutes), the MySQL database (also running on
Windows) crashes.

1 is just an annoyance. 2 & 3 render the connector unusable.

Paolo



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: Problems with MySQL Connector/ODBC 5.00.10 Beta

On Wed, Dec 13, 2006 at 03:40:00PM +0100, Paolo wrote:
> 1 - the connector sees not only the tables but also the Views in the MySQL
> database. If in Access to click "Select All" to link all the tables, it
> tries to link to the views as well and fails with an error ("Reserved error
> (-7729); there is on message for this error.")

Linking views is allowed just the same as tables.

> 2 - some rows in a multilingual table, for no apparent reason have "#Error"
> marked for all their values. These rows are quite usable by other programmes
> (Navicat, for example).

Would you mind sharing the table schema?

> 3 - if I leave this table open in Access, then every minute or so, a pop-up
> appears: "Reserved error (-7776); there is on message for this error." And
> after a certain time (a few minutes), the MySQL database (also running on
> Windows) crashes.

So you are saying the database server also crashes, and you cannot
reconnect until you restart the database server? Which version of the
server are you running?

Can you create an ODBC trace log for all three of these issues? This can
be enabled in the ODBC data source administrator applet.

Thanks.
Jess


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: Problems with MySQL Connector/ODBC 5.00.10 Beta

> > 2 - some rows in a multilingual table, for no apparent
> reason have "#Error"
> > marked for all their values. These rows are quite usable by other
> > programmes (Navicat, for example).

Jess Balint wrote:
>
> Would you mind sharing the table schema?

-- Table "contact" DDL

CREATE TABLE `contact` (
`id` int(11) NOT NULL auto_increment,
`language_id` int(11) NOT NULL default '0',
`country_id` int(11) NOT NULL default '0',
`organizer` tinyint(1) NOT NULL,
`gender` char(1) NOT NULL default '',
`lastname` varchar(80) default NULL,
`firstname` varchar(80) default NULL,
`address1` varchar(80) default NULL,
`address2` varchar(80) default NULL,
`city` varchar(80) default NULL,
`province` varchar(80) default NULL,
`postcode` varchar(20) default NULL,
`email` varchar(80) default NULL,
`phonehome` varchar(20) default NULL,
`phonework` varchar(20) default NULL,
`phonemobile` varchar(20) default NULL,
`fax` varchar(20) default NULL,
`remark` varchar(500) default NULL,
`privateremark` varchar(500) default NULL,
`birthdate` date default NULL,
`occupation` varchar(80) default NULL,
`reg_code_prefix` varchar(10) default NULL,
`password` varchar(20) default NULL,
PRIMARY KEY (`id`),
KEY `contact_FKIndex1` (`country_id`),
KEY `contact_FKIndex2` (`language_id`),
KEY `contact_lastname_index` (`lastname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


> > 3 - if I leave this table open in Access, then every minute
> or so, a
> > pop-up
> > appears: "Reserved error (-7776); there is on message for
> this error."
> > And after a certain time (a few minutes), the MySQL database (also
> > running on
> > Windows) crashes.
>
> So you are saying the database server also crashes, and you
> cannot reconnect until you restart the database server?

That is correct.

> Which
> version of the server are you running?

5.0.19-nt-max-log

>
> Can you create an ODBC trace log for all three of these
> issues? This can be enabled in the ODBC data source
> administrator applet.

OK, done. Hope to send you something soon.

Paolo



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: Problems with MySQL Connector/ODBC 5.00.10 Beta

On Wed, Dec 13, 2006 at 07:29:03PM +0100, Paolo wrote:
> > Which
> > version of the server are you running?
>
> 5.0.19-nt-max-log

I think your issue with linking views is due to a server bug that was
returning inconsistent data to the ODBC driver. This was fixed in MySQL
server 5.0.26. Please see the bug report for details at:

http://bugs.mysql.com/bug.php?id=14611

I'll take a look at the others when the ODBC logs are available.
Thanks!

Jess

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: Problems with MySQL Connector/ODBC 5.00.10 Beta

We have upgraded to

5.0.27-community-max-nt-log

However, as soon as I try to link a view from this database to MSAccess 2003
via ODBC, I still get:

"Reserved error (-7729); there is on message for this error."

Paolo


> -----Original Message-----
> From: Jess Balint [mailto:jbalint@mysql.com]
> Sent: Wednesday, December 13, 2006 7:40 PM
> To: Paolo
> Cc: myodbc@lists.mysql.com
> Subject: Re: Problems with MySQL Connector/ODBC 5.00.10 Beta
>
> On Wed, Dec 13, 2006 at 07:29:03PM +0100, Paolo wrote:
> > > Which
> > > version of the server are you running?
> >
> > 5.0.19-nt-max-log
>
> I think your issue with linking views is due to a server bug
> that was returning inconsistent data to the ODBC driver. This
> was fixed in MySQL server 5.0.26. Please see the bug report
> for details at:
>
> http://bugs.mysql.com/bug.php?id=14611
>
> I'll take a look at the others when the ODBC logs are available.
> Thanks!
>
> Jess
>



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org