cancel
Showing results for 
Search instead for 
Did you mean: 

DataSource Help

Highlighted
Super Contributor

DataSource Help

Hello Guys,
Would it be possible for you guys to have an illustrated example on how to use Data Source if my database is MS SQL Server 2005. Not a big urgency on this issue but it would be nice to know how to do it.

- Ali
6 REPLIES 6
Highlighted

Hi Ali!

I will look into it, make a tutorial and put it in the tutorials section.
Bare with me as this will take a day or two.
Product Guy for Ready! API, SoapUI and all things API
Highlighted

Hi Ali!

I've put up a tutorial showing how to connect to a MS SQL Server. Once you get the hang of it it's not that hard, but before you do it's pretty much impossible 

It's that connection string that's the hard part, it's the same connection string that's used in java development, but it's not that well documented.

The tutorial is here:
http://www.eviware.com/content/view/70/48/
Product Guy for Ready! API, SoapUI and all things API
Highlighted

On the implementation page I've added a movie which shows hot to use the Value Transfer editor.

http://www.eviware.com/index.php?option=com_content&task=view&id=71&Itemid=48
Product Guy for Ready! API, SoapUI and all things API
Highlighted
Super Contributor

Hello,
I see that in the JDBC connection string for SQL Server 2005 you specify a 'port'. How can I determine this 'port'. I launched SQL Server 2005 Management Studio but did not see anything for 'port'

Thanks

Ali
Highlighted
Super Contributor

hello,
I am having some trouble getting datasource to work.  I am using the following configuration but I get zero results when I click 'Test' to execute my sql query.

datasource: JDBC
driver:com.microsoft.sqlserver.jdbc.SQLServerDriver
ConnectionString:
jdbc:sqlserver://;databaseName=;user=;password=;
SQL Query: Select * from

When I click 'Test' I see nothing in the log.  Any idea whats going on ? If I have a bad SQL query, is soapUI supposed to show something in the log ?
Highlighted
Super Contributor

Actually it was my fault. I didnt know that that 'properties' value has to correspond to the column name in the database.

- Ali
New Here?
Join us and watch the welcome video:
Announcements
TechCorner Leaderboard
Want a fun and easy way to learn ReadyAPI and show off your skills? Try solving weekly TechCorner challenges and get into the Leaderboard!


Challenge Status

Get a full Raw JMS request

Participate!

Compare an expected JSON value and actual response in Events

Participate!

Fetch value/data from JSON response using Groovy Script

See replies!

Get data from Petstore and add it to Excel sheets

Participate!
Top Kudoed Authors