Mailing List - Entries of 2012
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] Re: [QF-Test] Error when try to connect to a sql server database using Jython (executeSelectStatement procedure).
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
|