Cant access SQL Server, not errors

I'm trying to set a conection, which I was able to set on excel using the same data

 

DB Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

DB URL: jdbc:sqlserver://DBServer/dbName

The thing is that when I run the node, I get an X with no error data. Is there a way of doing this setting up a DSN on windows?

 

Your syntax is not completely correct. The JDBC-URL for SQLServer is

jdbc:sqlserver://DBServer;databaseName=dbName

See also https://msdn.microsoft.com/en-us/library/ms378428%28v=sql.110%29.aspx

I'm having troubles using that sintax, even though I use

jdbc:sqlserver://DBServer;databaseName=dbName

I'm getting connection timeout (30 seconds), but when using the python source

cnxn = pyodbc.connect('DSN=DBServer;UID=username')

The connection is made without any problem

Ah, I missed the point that you want to use an ODBC datasource pointing to an SQL Server. Using ODBC in Java isn't possible any more because Oracle dropped the support in Java 8. You have to use the JDBC driver using the SQL Server's hostname and the database name. It will also be much faster than using the ODBC datasource.