SQL query cannot be executed
Iam trying to run a simple sql query but getting error. Please suggest where aim doing wrong. Also Iam using Webservices protocol.
"ConnectionString=Initial Catalog=<DB Name>;Data Source=<server Name>;user id =sa ;password = <password>" ,
"SQLQuery=select * from employee",
The error is
Error: The "SQLQuery=select * from employee" argument (#3) is invalid or not recognized at this position in the function call
Re: SQL query cannot be executed
Not sure it will help, but try writing the select and from in upper case (SELECT / FROM).
let us know if it helpd.