sikuli-driver team mailing list archive

[Ramanjaneyulu <question288871@xxxxxxxxxxxxxxxxxxxxx>]

New question #288871 on Sikuli:
https://answers.launchpad.net/sikuli/+question/288871

Hi 

I am working on small automation using sikulix. In that i need to connect to database(SQL Server) to execute some queries. 

for that i have written sample script as shown in below.  But i am facing the issue regarding python package "pypyodbc"
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
import pypyodbc
connection = pypyodbc.connect('Driver={SQL Server};'
                               'Server=RAM-PC\SQLEXPRESS;'
                                'Database=Auto;'
                                'uid=new_user;pwd=Ram@000324')
cursor = connection.cursor() 
SQLCommand = ("INSERT INTO sample " 
        "(name,sex) 
        "VALUES (?,?)")
VALUES = ['syam','male']
cursor.execute(SQLCommand,Values) 
connection.commit() 
connection.close()
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR is:

[error] script [ Untitled ] stopped with error in line 1
[error] ImportError ( No module named pypyodbc 

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Could you please help me to resolve this..... :)

and remaining modules like os,xlrd..etc are working fine




-- 
You received this question notification because your team Sikuli Drivers
is an answer contact for Sikuli.