[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    Re: myodbc
From:       Rich Cowan <rich () organizenow ! net>
Date:       2003-04-30 13:17:35
[Download RAW message or body]

I just tried a similar configuration (visual basic 5.0) and had the
same problem.  I spent about 4 hours debugging it and found
that the "Addnew" and "Edit" methods would not work when
I selected MySQL data using a DAO recordset.

When I switched to use an ADO recordset instead, MySQL
was able to update the underlying database.

I would prefer in this case to use ADO.  I am wondering if I
go back to myODBC 2.50, whether DAO recordsets would then
be updatable.

-rich cowan


At 08:07 PM 4/29/2003 -0300, you wrote:

>I'm work with myodbc 3.51 under win98 and visual basic 6.0, I can install 
>de driver odbc and connect with database, but I can't update the tables, 
>the Visual Basic show me the error "The database or the object is not 
>updatable", How fix this error ?
>
>Thanks
>
>Mauricio
>
>_________________________________________________________________
>Charla con tus amigos en línea mediante MSN Messenger: 
>http://messenger.yupimsn.com/
>--
>MySQL ODBC Mailing List
>For list archives: http://lists.mysql.com/myodbc
>To unsubscribe:    http://lists.mysql.com/myodbc?unsub=rich@organizenow.net


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=mysql-odbc@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]