sikuli-driver team mailing list archive

Thread
Date

Re: [Question #288871]: pypyodbc package does not import --- not possible because it uses c-types

To: sikuli-driver@xxxxxxxxxxxxxxxxxxx
From: Ramanjaneyulu <question288871@xxxxxxxxxxxxxxxxxxxxx>
Date: Sat, 19 Mar 2016 17:27:29 -0000
Reply-to: question288871@xxxxxxxxxxxxxxxxxxxxx
Sender: bounces@xxxxxxxxxxxxx

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

Ramanjaneyulu posted a new comment:
Thanks Raiman, :)

Could you please provide any example to connect SQL Server............

I have tried , but unable to connect to SQL Server.

Here following is the script that i have tried.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
from com.ziclix.python.sql import zxJDBC
connection = zxJDBC.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()
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
But it is not working..

Could you please provide any example :)

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