topic Re: Connection to a MSSQL database whose name contains "\" in Talend Studio

Connection to a MSSQL database whose name contains "\"

Igor_V — Wed, 28 Jun 2023 14:21:21 GMT

I'm trying to create a database connection on an MSSQL server named SQLINTEG\SQLEDU.

The connection doesn't go through.

If there is no "\" in the server name, then everything is in order.

How correctly to configure a connection to such servers?

anselmopeixoto — Wed, 28 Jun 2023 14:58:51 GMT

Hi @Grapeus Grapeus

Did you try escaping the backward slash with another one?

Like this: "SQLINTEG\\SQLEDU"

Igor_V — Thu, 29 Jun 2023 08:35:52 GMT

Yes, it doesn't work!

Safus — Thu, 29 Jun 2023 13:59:01 GMT

Hi @Grapeus Grapeus

Did you try to escape like this within double brackets : "[SQLINTEG\\SQLEDU]" ?

Igor_V — Fri, 30 Jun 2023 12:02:52 GMT

[SQLINTEG\\SQLEDU] also doesn't work

anselmopeixoto — Fri, 30 Jun 2023 19:23:17 GMT

Hi @Grapeus Grapeus

I believe SQLINTEG refers to the server name while SQLEDU is the instance.

If that's the case and you're using open jTDS jdbc driver, you might succeed with the following approach:

jdbc:jtds:sqlserver://SQLEDU:1433/dbname;instance=SQLEDU

Where "instance=SQLEDU" should be informed on the "Additional parameters" attribute of the connection.

Now if you're using Microsoft JDBC driver, it should work with the following:

jdbc:sqlserver://SQLEDU\\SQLEDU;databaseName=dbname

Or perhaps with

jdbc:sqlserver://SQLEDU/SQLEDU:1433;DatabaseName=database

Igor_V — Mon, 03 Jul 2023 11:51:15 GMT

Hi @anselmopeixoto (Customer)

Yes!!! It work!!! jTDS jdbc driver string correctly connected.

Thank you very much!!! It was a big problem for me!