Thursday, January 16, 2014

Connect to SQL Server Using Oracle SQL Developer

Step 1. Get the JDBC driver for MS SQL : If you don't already have one, download a JDBC driver for MS-SQL. I use the jTDS driver, which is open-source Java. It doesn't matter where you place it, but remember where.

First you need to get the right driver. You can find it here: http://sourceforge.net/projects/jtds/files/jtds/1.2.5/jtds-1.2.5-dist.zip/download
NOTE: For SQL Developer 4.0EA3 and SQL Developer Data Modeler 4.0 (production) you now need jtds-1.3.1. Get it here: http://sourceforge.net/projects/jtds/files/

Step 2. Load the JDBC driver : As explained in Oracle's tutorial, under Preferences, scroll down to Database and Third Party JDBC Drivers. Once you load the jtds-1.2 jar file you should see both SQL Server and it's aging uncle Sybase added to your list of options when creating a new database connection (You get Oracle and Access by default).

Step 3. Set up your new database connection : Now you can create a new MS SQL database connection the same you would an Oracle connection. The only difference is that you need to select the SQLServer tab instead of Oracle. If you don't see that tab, then something went wrong - either you got the wrong jar file or it didn't load correctly.

Wednesday, January 8, 2014

Fix for ‘JFolder::create: Could not create directory’ Error

This error occurs when you move from one host to another host. It is because when we move a Joomla site from one server to another server, the log & tmp functions present in the configuration.php file contains the directory path where you had previously installed Joomla i.e. on the old server.

Unlike other Errors, the fix for this error is pretty Simple. Follow the steps below to fix it.

1) Goto your Hosting panel >> File Manager >> Select your Domain/Sub-Domain and then open the configuration.php file.
2) Find var $log_path, it will contain the Directory path of your Old Server. Just replace the whole line with the code var $log_path = './logs';
3) Find var $tmp_path, it will also have the Directory path of your Old Server. Replace the whole line with the code var $tmp_path = './tmp';

Thursday, January 2, 2014

Install RabbitVCS via PPA

RabbitVCS is a set of graphical tools for accessing the version control software that you use. It supports Subversion and git and is similar to TortoiseVCS found on Windows.

Ubuntu 12.04 provides RabbitVCS in the standard repositories but this is version 0.13 which does not have support for GNOME 3 and so does not provide nautilus integration or gEdit integration.

In order to install the later 0.15 version of RabbitVCS you will need to add the RabbitVCS ppa.

Install RabbitVCS via PPA:

The RabbitVCS PPA supports Ubuntu 13.04, Ubuntu 12.04, Ubuntu 12.10, Ubuntu 11.10, Ubuntu 10.04 and their derivatives, such as Linux Mint and Elementary OS.

Press Ctrl+Alt+T on your keyboard to open terminal. When it opens run commands to add the PPA:

sudo add-apt-repository ppa:rabbitvcs/ppa

Then update system package lists via:

sudo apt-get update

Install the packages:

sudo apt-get install rabbitvcs-nautilus3 rabbitvcs-thunar rabbitvcs-gedit rabbitvcs-cli