jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Labudu Gopanna" <Labu...@cybage.com>
Subject RE: Problem while connecting to SQL Server through Jmeter
Date Tue, 19 Dec 2006 06:31:46 GMT
Hi naveen,

 Paste the proper .jar file in lib dercotory.
Enter the foloowing values in jdbc connection configuration.

Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver 
URL: jdbc:sqlserver://<host>[:<port1433>];databaseName=<database>
And give the username & password, if you have athentication for
sqlserver
Give the variable name properly in both connection configuration and
JDBC request.
I think it will solve ur problem,

From
Gopal,

-----Original Message-----
From: naveen sharma [mailto:maynaveen@yahoo.com] 
Sent: Tuesday, December 19, 2006 11:38 AM
To: JMeter Users List
Subject: Re: Problem while connecting to SQL Server through Jmeter

Hi subhra,
        I made the changes accordingly but still i am receiving same
error. Can you plz let             me how should i find the <port number
where the database listener is running>;             or this is static
port 1433. That I have specified.
 
~Naveen



----- Original Message ----
From: "Choudhury@labware.com" <Choudhury@labware.com>
To: JMeter Users List <jmeter-user@jakarta.apache.org>
Cc: jmeter-user@jakarta.apache.org
Sent: Tuesday, December 19, 2006 11:10:17 AM
Subject: Re: Problem while connecting to SQL Server through Jmeter


Hi,
         Ensure that the three jars
Msbase.jar,Msutil.jar,Mssqlserver.jar 
are in JMeter's lib directory.Then change the Database URL to 
jdbc:microsoft:sqlserver://<ip of the machine which is hosting the 
database>:<port number where the database listener is running>;
databaseName=<ur database Name>.Your JDBC driver class looks ok. You
need 
to change only the Database url and it should work.Hope this helps.

Regards,

Subhrajyoti 
Mobile: +919830079545
Mail: choudhury@labware.com
Web: www.labware.com

LabWare LIMS Solutions - Results Count



naveen sharma <maynaveen@yahoo.com> 
12/19/2006 10:27 AM
Please respond to
"JMeter Users List" <jmeter-user@jakarta.apache.org>


To
jmeter-user@jakarta.apache.org
cc

Subject
Problem while connecting to SQL Server through Jmeter






Hi all,

I'm trying to create a database connection pool using "JDBC Connection
Configuration".Our database is SQL server 2000. 


I just found after I run the setup.exe of JDBC driver I downloaded from
Microsoft, I find the three jar files in the \Microsoft SQL Server 2000
Driver for JDBC\lib dir. I copied them to \jakarta-jmeter-2.1.1\lib 
And in Database Connection Configuration I wrote like this:

Database URL: jdbc:microsoft:sqlserver://localhost:1433\mydb
JDBC Driver class: com.microsoft.jdbc.sqlserver.SQLServerDriver 
Username: ***
Password: ***

But after I ran the script, I got this error.
" org.apache.jmeter.protocol.jdbc.util.NoConnectionsAvailableException"
Is
my Database URL and JDBC Driver class set correctly?

Can anyone please let me know what the problem is ? 

Thanks in advance ,
Naveen






__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 



__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

"Legal Disclaimer: This electronic message and all contents contain information from Cybage
Software Private Limited which may be privileged, confidential, or otherwise protected from
disclosure. The information is intended to be for the addressee(s) only. If you are not an
addressee, any disclosure, copy, distribution, or use of the contents of this message is strictly
prohibited. If you have received this electronic message in error please notify the sender
by reply e-mail to and destroy the original message and all copies. Cybage has taken every
reasonable precaution to minimize the risk of malicious content in the mail, but is not liable
for any damage you may sustain as a result of any malicious content in this e-mail. You should
carry out your own malicious content checks before opening the e-mail or attachment."
www.cybage.com 



---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org


Mime
View raw message