RE: Multi-user issues with mySQL and VB Bound Controls - John...@bench.com - com.mysql.lists.win32

10 messages in com.mysql.lists.win32RE: Multi-user issues with mySQL and ...

From	Sent On	Attachments
John...@bench.com	13 Aug 2003 13:35
John...@bench.com	14 Aug 2003 05:15
PF: MySQL	14 Aug 2003 05:35
John...@bench.com	14 Aug 2003 14:35
jbon...@sola.com.au	14 Aug 2003 16:52
Peter Goggin	14 Aug 2003 21:30
Petr Vileta	15 Aug 2003 03:19
Karam Chand	15 Aug 2003 08:49
John...@bench.com	15 Aug 2003 10:21
Director General: NEFACOMP	14 Sep 2003 11:29

Subject:	RE: Multi-user issues with mySQL and VB Bound Controls
From:	John...@bench.com (John...@bench.com)
Date:	08/14/2003 02:35:39 PM
List:	com.mysql.lists.win32

OK,

Here's what I've learned so far about doing Grid controls with mySQL:

Dont use bound controls. Apparently bound controls dont work too well. Handle
the interface to the database directly, in code. I tried to avoid this because
coding the DBGrid control in unbound mode was painful. Maybe this MSFlex Grid
will be easier.

Use Active Data Objects as the DB interface. This means I have to use VB 6
Enterprise and learn YET ANOTHER database API.

Does anybody else have recommendations? I want to nail down some "best
practices" before I spend much more time on this project.

Thanks,

-John

-----Original Message----- From: Glauter Moulin Coelho [SMTP:agri...@cits.br] Sent: Thursday, August 14, 2003 10:07 AM To: Cook, John Subject: RES: Multi-user issues with mySQL and VB Bound Controls

Hi,

I had several problemas with data bound controls + MySQL + ADO + VB6 in a migration process from Access to MySQL. In my case the solution was : do not use grids ( TRUE DBGRID + ADODC ) to updates and inserts and always as possible use direct SQL querys.

Regards,

Glauter

-----Mensagem original----- De: John...@bench.com [mailto:John...@bench.com] Enviada em: quinta-feira, 14 de agosto de 2003 09:16 Para: mark...@yahoo.com Cc: win...@lists.mysql.com Assunto: RE: Multi-user issues with mySQL and VB Bound Controls

Mark,

Here's the text of the error:

Theres a diaglog box named DBGrid (which is the name of the bound data grid I'm using) with this text:

"The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time"

And an OK button.

Thanks in advance.

-----Original Message----- From: Mark Mchugh [SMTP:mark...@yahoo.com] Sent: Wednesday, August 13, 2003 5:17 PM To: Cook, John Subject: Re: Multi-user issues with mySQL and VB Bound Controls

hi John, I've done something similar, and got it working, whats the exact error message u get? --- John...@bench.com wrote:

Hi all,

I hope I've not coded myself into a corner. I'm doing a visual basic 5 pro project with mySQL as the database. Originally, I coded the prototype using Access using a data aware bound grid control and an ordinary Data Control.

Now I have to move up to mySQL and multi-user issues. I used the ODBC Direct mode of the Data Control because I couldnt get Remote Data Objects to work.

I've got it working fine with mySQL 4.0 except for a teensey little problem.

I can add new records just fine using the bound data grid. No problem.

I can view existing records just fine.

I cannot go back and edit them without getting a multi-user error. VB thinks that some other user already has that existing record open and wont let me edit it. Thats impossible because there is just one user (me) running the program.

I've read about handling multi-user issues in VB but all the examples are for very simple controls, nothing as nastily complex as a bound data-aware grid. All the examples also use controls in unbound mode and handle the Update method directly in code instead of using the Data Control.

Am I stuck? Im not a good enough coder to code by hand all the stuff the Data Control does in bound mode.

Thanks,

-John C. Network Admin.

-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe:

http://lists.mysql.com/win32?unsub=mark...@yahoo.com>