Oracle SQL Developer supports SQL Server via jTDS driver

Pardon the confusion with all the freely flung usage of the term SQL coupled with the vaguely descriptive "developer" and "server" terms. This article describes the requirements for getting Oracle's SQL Developer client to work with Microsoft's SQL Server database manager.

SQL Developer supports connections to SQL Server, but in spite of Microsoft providing its own JDBC driver, SQL Developer will only work with the jTDS driver. Download that and point SQL Developer to it via:

Tools | Preferences…
Database | Third Party JDBC Drivers

Point SQL Developer to the jTDS driver to use with SQL Server.

If connections are being made from the Windows version and Windows authentication will be necessary, then the ntlmauth.dll library will need to be copied into the JDK directory:

Copy from

PATH_TO_JTDS\jtds-VERSION\PLATFORM\SSO\ntlmauth.dll

Copy to

JAVA_JDK_DIRETORY\jre\bin\ntlmauth.dll

Comments

Skype Now Supports Emergency Calls In the US

With the latest round of updates to Skype , it was noticed today that the instant messaging and VoIP phone service now supports emergency calling in the United States. The release notes for the most recent update to the Android version of Skype indicated that the service now allows calls to be made to US emergency calling systems via 911. Telephony services like Skype, Google Voice , and Vonage typically don't offer this emergency calling ability without some sort of intermediate step like deferring to the phone's default dialer, as is the case with Voice, or setting up a physical address location ahead of time which is how Vonage handles it. The indication is that Skype will handle the 911 calls natively, but when verifying with an account that does not have a Skype phone number assigned to it, it was found that the instructions in the FAQ explaining how to turn on emergency calling are not accurate. Emergency calling support in Skype for the United States Interestingly, th...

Allow Windows authentication using SQL Server driver with DBeaver

DBeaver will allow Microsoft Windows single sign on access when connecting to Microsoft SQL Server using the SQL Server driver (rather than jTDS ). From the driver properties settings, set the integratedSecurity flag to true . Open the Connection configuration panel and choose the Driver properties section. Set the integratedSecurity flag to true . A subtle, but important step is to not provide username and password credentials to the connection.

Edit CUPS Configuration File To Re-assign Network Address

The printers.conf file can be edited to change the network address a printer uses. This can be useful to fix situations in which the printer in question has a new IP address, but the local system is trying to use the previous address. Shutdown the CUPS server Change the network address Restart the CUPS server sudo systemctl stop cups sudo nano /etc/cups/printers.conf sudo systemctl start cups NOTE The editor used in the example is nano for the sake of those who may be less comfortable in the command-line. With nano, once the change has been made, use Control + O to save the changes, and then Control + X to quit the editor. Ideally, this process would not be necessary. Instead, once a printer is added, it will always be reachable at the address it was assigned when it was added to the system. In practice, things like power outages, or breaks in network connectivity, may be enough for the DHCP server to issue a new IP address. A tip when making the address cha...

Orsburn (Static Content)

Search This Blog