DBeaver ODBC connections

user_2000301 0
Viewed 4531

I'm trying to connect to an ODBC data source from a Mac using DBeaver. I can't seem to find a way to set up an ODBC connection in DBeaver. Is it not supported? (JDBC is supported)

I'm trying to use the FreeTDS driver to connect to a MSSQL server. This server is on a different domain than the Mac so it cannot use Windows Authentication and hence the need to use an ODBC connection. I'm able to connect from the Mac using tsql which comes with FreeTDS.

unixodbc dbeaver odbc macos
1 Answers

It appears that DBeaver no longer supports ODBC connections, probably due to the fact that the JDBC-ODBC Bridge was removed from Java 8. However, in many cases the jTDS driver should suffice for connections to SQL Server instances from non-Windows machines. For example, in order to connect to a SQL Server instance using the Windows credentials for GORD-HP\dr.evil we can create a jTDS connection

enter image description here

enter the relevant information, noting that

  1. the "Authentication" type is NTLM, and
  2. the "User name" is just dr.evil

enter image description here

switch to the "Driver properties" tab and enter the DOMAIN

enter image description here

That should work, provided that the SQL Server instance has not disabled NTLM authentication.

user_21443900
Related