Result of MyODBC3.51 query always read-only

[Shane Lake]

I am experiencing a problem where a Lotus Approach resultset is always returned as read-only when running the following very basic (or for that matter, any) query on a server-based MySQL ODBC data source:

Dim con As connection
Dim qry As query
Dim rs As resultset

Set con = New connection()
connect_ok = Con.Connectto("ODBC Data Sources", "username", "password", "!datasource")
Set rs = New resultset
Set qry = New query
Set qry.connection = con
qry.SQL = "SELECT * FROM table1"
Set rs.query = qry
qres = rs.execute

The data source is on a Linux server on the network. I can update the table from Lotusscript using the same connection but with native SQL statements such as UPDATE and INSERT (which should rule out access privileges to the server) but when I switch to using a resultset object the table is considered read-only and no updates are possible.

Running this same code against a local Windows MySQL data source works fine and the resultset is returned properly with rs.isreadonly=0.

Based on postings, it seems a similar problem existed in the past with DAO but a resolution was never documented.

Versions:
MySQL ODBC Driver 3.51.09;
MySQL server (Linux) 4.1.1 (mysqld-4.1.1-alpha-standard-log)
and also tried with
MySQL server (Linux) 4.1.4 (mysqld-4.1.4-gamma-standard-log)
Lotus Approach 9.8 (with Patch 01) on Windows XP;