Problem SQLServerDriver server name contains comma

Asked Sep 26 '22 at 14:55

Active Sep 26 '22 at 15:02

Viewed 65 times

I am trying to connect a SQL server and for this I am using the driver provided by microsoft com.microsoft.sqlserver.jdbc.SQLServerDriver Now they changed the connection by adding a comma to it and I can no longer create the connection, does anyone know how to make the drive take the literal connection? Or for these cases I have to make a special configuration.

The server name is: 200.100.100.17,6058

The same so far I can connect from Sql Server Management Studio but not from java, I have the connection String like this

jdbc:sqlserver://200.100.100.17,6058;databaseName=FinancialPortfolio

edited Sep 26 '22 at 15:02

asked Sep 26 '22 at 14:55

Israel Gonzalez

`200.100.100.17,50748` is not server name, it is server ip address and port – Iłya Bursov Sep 26 '22 at 15:00
Try `200.100.100.17:6058` instead. JDBC wants a `:` for port number – squillman Sep 26 '22 at 15:03
6058 is not a port, is part of server name – Israel Gonzalez Sep 26 '22 at 15:03
@IsraelGonzalez No, that's an IP address / port combination. It's not a server name. It can be entered in the servername parameter, but it's not a server name. – squillman Sep 26 '22 at 15:04
I would actually find the host name and use that – g00se Sep 26 '22 at 15:05
but, my string connection add dbc:sqlserver://200.100.100.17:6058;databaseName=FinancialPortfolio and not working, ¿is my string connection wrong? – Israel Gonzalez Sep 26 '22 at 15:16
Assuming that missing the `j` at the start is a typo in your comment, what is the exact error message you get? – squillman Sep 26 '22 at 15:16
java.lang.RuntimeException: Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept jdbcUrl, java jdbc:sqlserver://200.100.100.17:6058;databaseName=FinancialPortfolio – Israel Gonzalez Sep 26 '22 at 15:21
1

That's *not* the exact error message ;) A paraphrase is not going to help. What is the hostname? – g00se Sep 26 '22 at 15:22

Problem SQLServerDriver server name contains comma

0 Answers0