Archive

Posts Tagged ‘MS Office’

How to get and install the “Microsoft Office Picture Manager” in Office 2013 and above.

If you are using Microsoft Office 2013 you might have noticed that the new Office suites don’t come with “Microsoft Office Picture Manager” program. Picture Manager was an excellent and small program included in Office suite which used to help users in viewing, editing and managing pictures quickly and easily. It also used to provide a few advanced image editing features such as crop, auto correct, rotate, flip, red-eye removal, resize, etc.
Basically it was a nice piece of program to edit pictures but now its no longer included in Office suite. The reason looks very simple. This program was not updated since Office 2003 version and was looking out-of-date, that’s why Microsoft decided to discontinue its development.
But there are many Office users who are missing this nice little program and want to get it back in newer Office versions.
The idea behind adding this program back is very simple. You’ll use a previous Office suite setup and will customize it to install only Picture Manager program.
If you don’t have a previous Office version, you can use Microsoft SharePoint Designer (SPD) 2010 version to install Picture Manager (it’s absolutely free and doesn’t require any product key to activate). You can download it using following links:
Download Microsoft SharePoint Designer 2010 (32-bit)
Download Microsoft SharePoint Designer 2010 (64-bit)
By the way, it is interesting to note that Picture Manager is not a component of SharePoint Designer 2013.
Here you can find the detailed instructions with screenshots, etc.:
http://www.experts-exchange.com/articles/12697/How-to-Install-Microsoft-Office-Picture-Manager-in-Office-2013.html
The short version is to run the installer, then choose “Customize” instead of “Install Now”, then deselect everything that’s not “Office Tools” => “Microsoft Office Picture Manager”.
That’s should be all 🙂

Advertisements
Categories: MS Windows, OS Tags: ,

How to install ODBC driver for Oracle in Windows 7.

2014-07-28 22 comments

Installation of the ODBC driver in Windows 7 is quite simple but there are a few tricks better to know. Here is a step-by-step instruction how to install the ODBC driver.
First of all, you need to download proper files:
– here is the link for Instant Client Downloads for Microsoft Windows (32-bit), for ODBC, you need instantclient-basic-nt-11.2.0.3.0.zip and instantclient-odbc-nt-11.2.0.3.0.zip files (Oracle 11.2.0.3 version)
– here is the link for Instant Client Downloads for Microsoft Windows (x64), for ODBC, you need instantclient-basic-windows.x64-11.2.0.3.0.zip and instantclient-odbc-windows.x64-11.2.0.3.0.zip files (Oracle 11.2.0.3 version)

Which version to choose – 32-bit or 64-bit?
Well, I think the best way to answer this question is to describe my situation. I need to get data from Oracle to Excel. I have on my PC: Windows 7 – 64-bit version, 64-bit Oracle client already installed but MS Office in 32-bit version. So in my situation I had to choose 32-bit ODBC driver. Generally, you choose ODBC driver version based on tool version, that you use to get data from Oracle database.

Anyway, both downloaded files, you need to unzip to THE SAME folder (for example: c:\oracle\instant_client_11), then add the folder to the PATH environment variable:
screen1
Then add the TNS_ADMIN environment variable indicating the path to the tnsnames.ora file (in my PC it is c:\oracle\11.2.0\CLIENT\network\admin):
screen2
Next, open the command line (Run as administrator) and go to the folder where you unzip ODBC driver, in my case:

cd c:\oracle\instant_client_11

and then – still in cmd, install ODBC:

odbc_install.exe

When successfully, you should get the following info:

Oracle ODBC Driver is installed successfully.

So, right now we can configure ODBC connection: choose Control Panel, then Administrative Tools, then Data Sources (ODBC), then System DNS and then Add, on the list, choose instant_client_11, then Finish and then in the configuration window… wait. You don’t have instant_client_11 on the list. That’s the problem I also had – ODBC driver didn’t appear in ODBC data source.
This is because you use 64-bit ODBC administration panel. If you install 32-bit ODBC driver, you’ll need to use 32-bit ODBC administration panel – run odbcad32.exe from c:\windows\SysWOW64.

So, on the list, choose instant_client_11, then Finish and then in the configuration window add proper data in the Data Source Name, Description, TNS service name (from tnsnames.ora) and User ID.
Then, you can test connection and when everything is correct, save the connection, close ODBC window and enjoy your Oracle data in MS Office tools 🙂