← Back to team overview

sikuli-driver team mailing list archive

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

 

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

Ramanjaneyulu posted a new comment:
Hi Raiman,

Thanks for giving information.

i have written the following script using zxJDBC module to connect with SQLServer but is is showing "driver not found error"
 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
from com.ziclix.python.sql import zxJDBC
connection = zxJDBC.connect('jdbc:sqlserver://RAM-PC\SQLEXPRESS', 'new_user', 'Ram@000324','com.microsoft.sqlserver.jdbc.SQLServerDriver')
cursor = connection.cursor()
cursor.execute("use Auto")
SQLCommand = ("INSERT INTO sample " 
        "(name,sex)" 
        "VALUES (?,?)")
VALUES = ['syam','male']
cursor.execute(SQLCommand,Values) 
connection.commit() 
connection.close()

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR:
[error] script [ sql ] stopped with error in line 2
[error] zxJDBC.DatabaseError ( driver [com.microsoft.sqlserver.jdbc.SQLServerDriver] not found )
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Could you please help me how to resolve it??

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