hi,

I have a problem with connecting to MySQl from Visual Basic 6, I have set all
the permisions and grants properly, but when I connect using ADODC, it does not
allow me to change the values of the fields or add new record it gives the error
message "Binding Collection Error Field not updatable, Bound Property Name:
Text, Field Name: txtName" where txtNAme is the name of the textbox. I am using following connection string (db.Open
"PROVIDER=MSDASQL;driver={MySQL};server=localhost;uid=root;pwd=asdf;database=bnatc;"),
I have tried using dsn and other ways but I get the same error message.

It works with DAO connection using JET engine. I am using the following to
connect using
Jet(ODBC;DSN=mysqlds;DB=bnatc;SERVER=localhost;UID=root;PWD=asdf;PORT=3306;FLAG=0;).
it works fine without any problems. But ADODC gives only read only not updatable
views. The version of the MySql are MySql ver 3.23.49

MyODBC ver 2.50.19.00

Please help, I am stuck in a project to convert Ms Access application to MySql
and Vb as frontend. If u know a better frontend let me know.

Nabeel nesh...@yahoo.com