SQL query cannot be executed

Hi,

Iam trying to run a simple sql query but getting error. Please suggest where aim doing wrong. Also Iam using Webservices protocol.

lr_db_connect("StepName=myStep", 
        "ConnectionString=Initial Catalog=<DB Name>;Data Source=<server Name>;user id =sa ;password = <password>" ,
        "ConnectionName=MyConnection",
        "ConnectionType=SQL",
        LAST);
    
    lr_db_executeSQLStatement("StepName=UpdateStep", 
        "ConnectionName=MyConnection", 
        "SQLQuery=select * from employee", 
        "DatasetName=ds1", 
        LAST);
    

    lr_db_disconnect ("StepName=Closestep",
    "ConnectionName=MyConnection",
LAST);

=================================================================

The error is
 Error: The "SQLQuery=select * from employee" argument (#3) is invalid or not recognized at this position in the function call

Thanks
Dips

Tags: