← Back to team overview

sikuli-driver team mailing list archive

Re: [Question #684246]: Sikuli connect to Sql Server from command line

 

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

    Status: Needs information => Open

David Flood gave more information on the question:
Thank you for replying, and apologies for the rambling nature of my
question. I am trying to connect Sikuli 1.1.3 using the IDE and Jython
to a SQL server database.


url = "jdbc:sqlserver://ddd-alt-us01.firm.uk;DatabaseName=bkr900;sendStringParametersAsUnicode=False"
dbuser = "Test.Testing"
dbpassword = "Test3r!"
driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
dbconn = zxJDBC.connect(url, dbuser, dbpassword, driver)
dbcur = dbconn.cursor()
#try:
dbcur.execute("select id, name from member")
rs = dbcur.fetchall()
for elm in rs:
    print elm[0], elm[1]

Get error message.


[error] Error caused by: Traceback (most recent call last): File "C:\alpen1.sikuli\alpen1.py", line 6, in <module> dbconn = zxJDBC.connect(url, dbuser, dbpassword, driver) zxJDBC.DatabaseError: driver [com.microsoft.sqlserver.jdbc.SQLServerDriver] not found


-----Original Message-----
From: bounces@xxxxxxxxxxxxx <bounces@xxxxxxxxxxxxx> On Behalf Of RaiMan
Sent: 26 September 2019 14:58
To: David Flood <david.flood@xxxxxxxxxxxxx>
Subject: Re: [Question #684246]: Sikuli connect to Sql Server from command line

Your question #684246 on Sikuli changed:
https://answers.launchpad.net/sikuli/+question/684246

    Status: Open => Needs information

RaiMan requested more information:
what is the question?

--
To answer this request for more information, you can either reply to this email or enter your reply at the following page:
https://answers.launchpad.net/sikuli/+question/684246

You received this question notification because you asked the question.


________________________________________
The receiver of this message is required to check if he/she has received it erroneously. If so, the receiver is requested to immediately inform the sender and - in consideration of the responsibilities arising from undue use and/or disclosure of the message and/or the information contained therein - destroy the original message and any copy or printout thereof.

Chi riceve il presente messaggio e' tenuto a verificare se lo stesso non
gli sia pervenuto per errore. In tal caso e' pregato di avvisare
immediatamente il mittente e, tenuto conto delle responsabilita'
connesse all'indebito utilizzo e/o divulgazione del messaggio e/o delle
informazioni in esso contenute, voglia cancellare l'originale e
distruggere le varie copie o stampe.

;

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