topic Re: tDBConnection and special characters in Talend Studio

tDBConnection and special characters

JBristow — Fri, 15 Nov 2024 22:41:10 GMT

We have a connection to an Azure SQL Server Database using the tDBConnection. Works great in DEV - but fails in QA. One team member said the User Name is "UserName@test.com" - so in email format. Whenever I use the "@" in the User Name - I get an error as Talend tries to connect: "Cannot open server "test.com" requested by the login." Remove the "@" and we get the expected Invalid Login message - so it looks like the "@" throws everything off.

Are special characters allowed on the tDBConnection component?

If 'Yes" - then how do you escape or format the Username with the "@" in it? I've tried "\@"; "\\@"; and even "%40" but nothing seems to work as the Username looks to be simple text and thus I'm sending "UserName\@test.com" and it gets rejected.

I'm trying to get them to change the User Name to avoid the issue - but was curious if this might be a known issue or constraint.

Thanks.

Re: tDBConnection and special characters

wwang — Tue, 09 Aug 2022 08:11:14 GMT

please upload your sample job which can reproduce it, or show which component you use and config details.

Re: tDBConnection and special characters

JBristow — Mon, 29 Aug 2022 21:25:51 GMT

Here's the job configuration. They changed from an on-prem SQL Server DB an Azure. The change itself was fairly straight-forward and worked fine. It was just the user ID with the embedded "@" in the name that would not work. I had them provide a user ID without any special characters and we were fine.