Forum Discussion

alibaba82's avatar
alibaba82
Super Contributor
17 years ago

% in connection string - Please help Fast (releasing software today)

Hello

I have a connection string that looks like this for one of my environments
sql = Sql.newInstance("............;password=tvgdev1\$;")

I have no issues with this string above.

In another environments the connection string is
sql = Sql.newInstance("...........;password=$123read%;")

When the groovy script compiles I get the following error. Can you please help fast.

Wed Jul 25 17:22:42 PDT 2007:ERROR:An error occured [startup failed, C:\Workspace\QA\Automation\SoapUIScripts\Global_Groovy\GlobalFunctions.groovy: 62: illegal string body character after dollar sign;
  solution: either escape a literal dollar sign "\$5" or bracket the value expression "${5}" @ line 62, column 14.
  sql = Sql.newInstance("jdbc:sqlserver://tul1cspdb1:1433;databaseName=cpswebp2;user=datareader;password=$123read%;")
                ^

1 error
], see error log for details