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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.