Skip to main content

Posts

Showing posts from September, 2015

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

Reveal files in gedit file browser view (Windows)

Use the filter option to show binary files to make the files available. Right + click in the File Browser tab's file listing area Select Filter | Show Binary Gedit , the open source text editor for Gnome , has a view in the side panel to browse the local file system.  It appears that the Windows version of the application has a bug that assumes all files to be binary, even if they carry a .txt filename suffix. The expected behavior is that text and source code files will be listed by default, and that this option will allow items like pictures and executable files to be shown as well.  Setting this flag can serve as a workaround.  Without it, only folders and files without filename suffixes will be shown. Gnome Bugzilla ( 578829 ) File Browser plugin can only show files with no extension on Win32 https://bugzilla.gnome.org/show_bug.cgi?id=578829