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 date and time and a
Timestamp.
When we run the program it start well and the data gets processed and
stored. But after a while we start getting error 3151 ODBC can't connect
to mysql server.
We have MySql 4.0.12 and odbc 3.51.6, all the tables are linked to the
msaccess program.
What else you need of 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 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 server error
>3151.
>
>What I can do to fix the problem?
>
>Osvaldo Sommer
>
>
>
Provide more details.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 3/7/2005
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 3/7/2005
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
