Clarion MySQL Connection Problem

#1

I'm writing a Clarion program (Clarion6.3 9056) that connects to a MySQL database via an ODBC connection (MySQL Connector/ODBC driver). Everything seems to be ok, I can view records, scan through them and can insert records into the database, but if I try to change/update an existing record e.g.

Access:Staff.Update() or Access:Staff.TryUpdate()

I get an error - An error (Unsupported File Driver Function (80)) was experienced when making changes to the staff file.

The username and password I'm using in MySQL has ALL Priviledges turned on, so I can only assume I'm either using the wrong update statement or the ODBC driver has some kind of read-only setting on it. If someone could help it'd be much appreciated.

#2

"Stuart345" <user (AT) compgroups (DOT) net/> wrote

Quote:

I'm writing a Clarion program (Clarion6.3 9056) that connects to a MySQL
database via an ODBC connection (MySQL Connector/ODBC driver). Everything
seems to be ok, I can view records, scan through them and can insert
records into the database, but if I try to change/update an existing
record e.g.

Access:Staff.Update() or Access:Staff.TryUpdate()

I get an error - An error (Unsupported File Driver Function (80)) was
experienced when making changes to the staff file.

The username and password I'm using in MySQL has ALL Priviledges turned
on, so I can only assume I'm either using the wrong update statement or
the ODBC driver has some kind of read-only setting on it. If someone
could help it'd be much appreciated.

Have you tried the Clarion newsgroups?
They can be found on the news.softvelocity.com server.

MG

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Clarion MySQL Connection Problem

comp.databases.mysql comp.databases.mysql

Clarion MySQL Connection Problem - 10-15-2010 , 10:23 AM

Re: Clarion MySQL Connection Problem - 10-15-2010 , 11:39 AM