cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Connection Issue with SQLServer

axe
New Contributor

JDBC Connection Issue with SQLServer

Hi ,

 

I am trying to do JDBC Connectin to SQL Server in SOAPUI 5.2.1

 

Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver ( sqljdbc42 )

Placed the driver jar fiel in /bin/ext/ folder.

Connection String: jdbc:microsoft:sqlserver://xxxxxxx:1433;databaseName=xxxxxxxx;user=xxxxxx&password=xxxxx

Java:

java version "1.7.0_55"
Java(TM) SE Runtime Environment (build 1.7.0_55-b13)
Java HotSpot(TM) 64-Bit Server VM (build 24.55-b03, mixed mode).

 

When I click the TestConnetion Button. it Neither says any error No Sucess Message.  Also When I execute the JDBC Step ' it says the below error" 

  • Mon Feb 15 20:41:46 EST 2016:INFO:Error getting response for [JDBC Request]; null."

Not sure what wrong here. Please correct me if something wrong here.

Tags (1)
2 REPLIES 2
nmrao
Community Hero

Re: JDBC Connection Issue with SQLServer

Not sure if the connection string has any issue. Please try the options mentioned in the below link

http://stackoverflow.com/questions/16851938/equivalent-jdbc-connection-string-for-sql-server


Regards,
Rao.
go2khurram
Contributor

Re: JDBC Connection Issue with SQLServer

try by changing the connection string in the fomat below

 

 

jdbc:sqlserver://IPAddress:1433;databaseName=xxxxxxxx>;user=xx;password=xxxxxxx;

New Here?
Join us and watch the welcome video:
Top Kudoed Authors