sikuli-driver team mailing list archive
-
sikuli-driver team
-
Mailing list archive
-
Message #37308
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.