3 messages in com.mysql.lists.win32RE: problem with ADODC help needed| From | Sent On | Attachments |
|---|---|---|
| Futuretech Computers | 05 Jun 2002 07:53 | |
| Takenori Satoh | 05 Jun 2002 10:01 | |
| jbon...@sola.com.au | 06 Jun 2002 17:49 |
| Subject: | RE: problem with ADODC help needed |
|---|---|
| From: | jbon...@sola.com.au (jbon...@sola.com.au) |
| Date: | 06/06/2002 05:49:37 PM |
| List: | com.mysql.lists.win32 |
I am familiar with this area. My connect strings have OPTIONS=16386 ("Return matching rows" and "Convert BIGINT to INT"). I am using VB6 systems running on various Windows versions talking to MySQL on RH Linux. I use Access 2000 to work with the database sometimes and particularly when I was porting the data from Access to MySQL.
I have since swapped to using MyVBQL instead of ADO/ODBC. I avoid data controls (ADODC) as they are too restrictive and do all my own binding which gives me a lot more flexibility and control.
John Bonnett
-----Original Message----- From: Futuretech Computers [mailto:futu...@vsnl.com] Sent: Thursday, 6 June 2002 12:24 AM To: win...@lists.mysql.com Subject: problem with ADODC help needed
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;F LAG=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