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

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

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

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads