Re: Problem with a repeated select from MS Access

2005-03-09 Thread Daniel Kasak
Osvaldo Sommer wrote: This is the code: Public Sub Graba_Recibido(texto As String) 277On Error GoTo Manejo_Error 278Dim db As Database 279Dim rec As DAO.Recordset 281texto = Mid(texto, 2, 2) & Mid(texto, 7, Len(texto) - 7) 282texto = Mid(texto, 1, Len(texto) - 1) 284Set db =

RE: Problem with a repeated select from MS Access

2005-03-09 Thread Osvaldo Sommer
ginal Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 8:26 PM To: Osvaldo Sommer; mysql@lists.mysql.com Subject: Re: Problem with a repeated select from MS Access Osvaldo Sommer wrote: >Daniel: > > The program is an interfase for a weigth syste

Re: Problem with a repeated select from MS Access

2005-03-08 Thread Daniel Kasak
Osvaldo Sommer wrote: Daniel: The program is an interfase for a weigth system in a Retail environment. The program query the weigth system for new data every 200 miliseconds, if new data is received it has to be stored in the database. The table has automatic correlative, the data in ascii, the d

RE: Problem with a repeated select from MS Access

2005-03-08 Thread Osvaldo Sommer
info? Osvaldo Sommer -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 6:29 PM To: Osvaldo Sommer; mysql@lists.mysql.com Subject: Re: Problem with a repeated select from MS Access Osvaldo Sommer wrote: >I have a msaccess program reading the ser

Re: Problem with a repeated select from MS Access

2005-03-08 Thread Daniel Kasak
Osvaldo Sommer wrote: I have a msaccess program reading the serial port every 200 mili sec. Each time it has to record the data from the port to a linked mysql table. I run the program and run fine but after a while ( not the same elapsed time) I start getting that the odbc fail to connect to the s