Unable to connect to Microsoft SQL Server

[Anonymous]

Hi 

I am trying to connect to a Microsoft SQL server to execute a select statement and return the results

The Job:

I get the following Error during execution

Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\ )

at financialreports.extractreceipts_0_1.ExtractReceipts.tMSSqlInput_1Process(ExtractReceipts.java:792)
at

Has anyone experienced this before? I can connect to the server via SQL Manager and ODBC

Thanks

[Anonymous · Accepted solution]

Resolved, by adding an additional \ escape to be like this dbname\\db