You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by naveen sharma <ma...@yahoo.com> on 2006/12/19 05:57:00 UTC

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

Re: Problem while connecting to SQL Server through Jmeter

Posted by Ch...@labware.com.
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 <ma...@yahoo.com> 
12/19/2006 10:27 AM
Please respond to
"JMeter Users List" <jm...@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