Re: [QF-Test] Error when try to connect to a sql server database using Jython (executeSelectStatement procedure).

["Robert Lahmer, QFS support" <support@?.de>]

Hello Gustau,

looks indeed that the manual is wrong or at least incomplete - thank you 
for bringing this up.
Microsoft changed the JDBC driver name and the connection URL between SQL 
Server 2000 and SQL Server 2005. For the latter it should read
 com.microsoft.sqlserver.jdbc.SQLServerDriver

and

jdbc:sqlserver://databaseserver:port;Databasename=database;



Best regards,
   Robert



--On Mittwoch, März 28, 2012 18:58:47 +0200 Gustau Mansanet Perez 
<GUSTAU.MANSANET.PEREZ@?.COM> wrote:
> Hello,
>
> My name is Gustau and I'm entering the world of QF-Test and I have
> encountered the following problem: I can not connect to a sql server
> database using Jython(executeSelectStatement procedure).
>
> I have downloaded from the Microsoft website the driver "sqljdbc4.jar"
> and have placed in the plugin folder, but the following error occurs:
>
> The script failed with the Following message:
> Traceback (most recent call last):
>    File "", line 1, in
>    File "C: \ Program Files (x86) \ qfs \ qftest \ qftest-3.4.5 \ jython
> \ Lib \ qftest.py", line90, in runscript      qfcommon.runscript (ctxt,
> code, exContext, dir)
>    File "C: \ Program Files (x86) \ qfs \ qftest \ qftest-3.4.5 \ jython
> \ Lib \ qfcommon.py", line 826, in runscript      exec compile (code,
> file, "exec") \
>    File "C: \ Users \ gmansane \. Qftest \
> _script5127568149610756196.py", line 11, in      db = zxJDBC.connect
> (rc.lookup ("connectionString"), user, password, dbclass)
> zxJDBC.DatabaseError: driver
> [com.microsoft.jdbc.sqlserver.SQLServerDriver] not found
>
> The params I am using are:
>
> driver
> com.microsoft.jdbc.sqlserver.SQLServerDriver connectionString
> jdbc:microsoft:sqlserver://12.84.66.134;DatabaseName=MyDatabase dbUser
> User
> dbPass                                   Pwd
> statement                               Select * from tb_biblio
> resultGroupName                  resultGroup
>
> Which is what I am doing wrong?
>
> Thanks in advance.
>
>
> ________________________________
> AVISO DE CONFIDENCIALIDAD.
> Este correo y la informaci?n contenida o adjunta al mismo es privada y
> confidencial y va dirigida exclusivamente a su destinatario. everis
> informa a quien pueda haber recibido este correo por error que contiene
> informaci?n confidencial cuyo uso, copia, reproducci?n o distribuci?n
> est? expresamente prohibida. Si no es Vd. el destinatario del mismo y
> recibe este correo por error, le rogamos lo ponga en conocimiento del
> emisor y proceda a su eliminaci?n sin copiarlo, imprimirlo o utilizarlo
> de ning?n modo.
>
> CONFIDENTIALITY WARNING.
> This message and the information contained in or attached to it are
> private and confidential and intended exclusively for the addressee.
> everis informs to whom it may receive it in error that it contains
> privileged information and its use, copy, reproduction or distribution is
> prohibited. If you are not an intended recipient of this E-mail, please
> notify the sender, delete it and do not read, act upon, print, disclose,
> copy, retain or redistribute any portion of this E-mail.


--
QFS Support - Robert Lahmer
Quality First Software GmbH                http://www.qfs.de
Tulpenstr. 41                         Tel: +49 8171 38648-20
DE-82538 Geretsried                   Fax: +49 8171 38648-16
GF: Gregor Schmid, Karlheinz Kellerer     HRB München 140833