serial communication error for loop

Dhileepan Kumar dhilip04211 at gmail.com
Tue Mar 13 20:23:46 EDT 2018


#!/usr/bin/python

import serial 
import MySQLdb
while True: 
#establish connection to MySQL. You'll have to change this for your database.
	dbConn = MySQLdb.connect("localhost","root","1234","ifet") or die ("could not connect to database")
	#open a cursor to the database
	cursor = dbConn.cursor()

	device = 'com3' #this will have to be changed to the serial port you are using
	arduino = serial.Serial(device, 9600) 


	try: 
	  data = arduino.readline()  #read the data from the arduino
	  if not data.strip():
	   continue
	  pieces = data.split("\t")  #split the data by the tab
	  #Here we are going to insert the data into the Database
	  try:
		cursor.execute("INSERT INTO answer1 (voltage,current) VALUES (%s,%s)", (pieces[0],pieces[1]))
		dbConn.commit() #commit the insert
		cursor.close()  #close the cursor
	  except MySQLdb.IntegrityError:
		print "failed to insert data"
	  finally:
		cursor.close()  #close just incase it failed
	except:
	  print "Failed to get data from Arduino!"

................................................................................
it is my program.if do not use while true loop successfully run but can't get a continues data from arduino so i have decide to using while loop  but if using while loop shows some error


(project) C:\Users\DHILEEPAN\project\project>python mysql.py
Traceback (most recent call last):
  File "mysql.py", line 13, in <module>
    arduino = serial.Serial(device, 9600)
  File "C:\Users\DHILEEPAN\Envs\project\lib\site-packages\serial\serialwin32.py", line 31, in __init_
    super(Serial, self).__init__(*args, **kwargs)
  File "C:\Users\DHILEEPAN\Envs\project\lib\site-packages\serial\serialutil.py", line 240, in __init_
    self.open()
  File "C:\Users\DHILEEPAN\Envs\project\lib\site-packages\serial\serialwin32.py", line 62, in open
    raise SerialException("could not open port {!r}: {!r}".format(self.portstr, ctypes.WinError()))
serial.serialutil.SerialException: could not open port 'com3': WindowsError(5, 'Access is denied.')

please any one fix this






More information about the Python-list mailing list