Unable to connect to Microsoft SQL Server

Seven Stars

Unable to connect to Microsoft SQL Server

Hi 

 

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

The Job:

talend1.PNG

 

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


Accepted Solutions
Seven Stars

Re: Unable to connect to Microsoft SQL Server

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


All Replies
Seven Stars

Re: Unable to connect to Microsoft SQL Server

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