Forum Discussion

Jeth01's avatar
Jeth01
New Contributor
11 years ago

Data connection not returning rows, but the log/UI says it does

I am having a problem with my data connections. I have them all configured correctly, and they pass the connection test. When I run the query, the UI shows "Got 2 rows in 187ms", but no data is retur...
GCushman's avatar
GCushman
Occasional Contributor
11 years ago

Any update on this issue?  I am running into the same problem.  If I go into the Query Builder and run it, the 'Result Preview' window displays my data.  But when I run it from the Data Source window, I see same behavior as noted in original post.

 

This is not cosmetic issue.  I cannot use this data in property expansions in a script assertion because all fields are evaluating to empty string ("").  If I change my Data Source to a flat file, my script assertions work as expected.

 

I am using Ready API! 1.3.1

My JDBC driver from my data source is:

com.microsoft.sqlserver.jdbc.SQLServerDriver

 

Any help/suggestions greatly appreciated as I really prefer to use SQL as my source over text file.

 

Thanks,

Greg