Category Archives: Computer – Technical

Topics include: troubleshooting, how to’s and info

Listing out Built in Functions in Python


To retrieve a list of Built in Functions in Python, type:  dir(__builtins__)

You will get the following list

Firefox_Screenshot_2016-01-31T04-16-41.818Z

To understand what each function does, you can type help(fuction_name) to get more details on that function.  Example: help(NameError)

Firefox_Screenshot_2016-01-31T04-20-36.900Z

 

Leave a comment

Filed under Computer - Technical, Python

Import Data from DB2 to SQL Server 2012


Below are steps that you can take to import data from IBMs DB2 database into SQL Server.  I’m using SQL Server 2012 Express edition.

Figuring this out has been one of the more frustrating tasks for me, so I hope this helps others like me.

Step 1.) Download and install DB2 Data Server Runtime Client (9.7 Fix Pack 4). Found in IBMs download page.

Step 2.) Extract the contents of your download to Program Files / IBM

Extract and paste the folder and it's contents under Program Files /IBM

Extract and paste the folder and it’s contents under Program Files /IBM

Step 3.) Open your command prompt (as Administrator).  Navigate to the “bin” folder under that folder you just copied into your directory.

Type db2oreg1 -i then type db2oreg1 -setup

Registering and setting up your DB2 ODBC Driver in Windows

Registering and setting up your DB2 ODBC Driver in Windows

Step 4.) Open up SQL Server Management Studio.  Right click on the database that you want to import DB2 data into

Right click on database name, select Tasks, select Data Import

Right click on database name, select Tasks, select Data Import

Step 5.) Select the proper driver for DB2

Select the DB2 Driver that you need to connect to the database

Select the DB2 Driver that you need to connect to the database

Step 6.) Set the connection properties to your DB2 database

Set DB2 Connection properties and test connection

Set DB2 Connection properties and test connection

Step 7 .)  Proceed with the wizard (Write a query to extract data or copy a table).  I chose to write a query.

Copy a table or write a query

Step 8.) Preview mapping of query or table copy

Destination attribute types based on SQL evaluation of values from query

Destination attribute types based on SQL evaluation of values from query

Step 9). Success!

Successful Transfer from DB2 to SQL Server 2012

If you experience any problems and would like some help, please be as specific as possible with regards to the steps you took to get where you are.

 

Best wishes!

Leave a comment

Filed under Computer - Technical, SQL

org.apache.xml.serializer.ToXMLSAXHandler incompatible with org.apache.xml.serializer.SerializationHandler


If you are creating a BIRT report and you encounter the following error (org.apache.xml.serializer.ToXMLSAXHandler incompatible with org.apache.xml.serializer.SerializationHandler) in relation to a chart in your BIRT report, simply select the ouput format of your Chart to be PNG in BIRT (as opposed to SVG or any other image type that is causing rendering problems.

 

BIRT Chart Output Format

BIRT Chart Output Format

 

Leave a comment

Filed under Computer - Technical

Review of Epson iPrint for Android


Recently I got a Galaxy S3.  I thought it would try to print from it.  Luckily an app was available for my Epson wireless printer.  No wires necessary.  All I needed was to ensure that both my printer and phone are on the network.

Below are some screenshots.

Once your printer is selected, you get a nifty snapshot of the ink levels.

image

Next you go to the initial screen.

image

This app has a built in browser and that is how u print off the web.

image

With your menu button you will ‘ve able to control the color settings, orientation and other things.

image

image

image

image

The app is intuitive and easy to use.  So far I have not had any problems.

Leave a comment

Filed under Computer - Technical, Linux

Add a wireless printer in Virtual Box


This is my scenario.  I am running Ubuntu as my main operating system.  Within Ubuntu I am also running Windows through Virtual Box.

  1. Install the necessary printer drivers to have your printer work with Linux.  (In my case, Epson Stylus NX430 has Linux drivers on their website that made wireless printing possible)
  2. Then install CUPS.  You can install CUPS through Ubuntu’s Software Center
  3. Next, to confirm that CUPS install correctly, go to http://localhost:631.  The following page should appear:
  4. Click on the Administration link and add your printer as a Network Printer.  Allow the “Share printers… ” checkbox to be checked.  Click on the Add a Printer Button.
  5. After clicking the button, CUPS will search for available Network Printers.  The available printer(s) will show up like below
  6. Next go to Windows.  Click on your start Menu and then click on Devices and Printers
  7. In the new Window, click on Add a Printer
  8. When this following screen appears, select the option “Add a network, wireless or Bluetooth printer”
  9. Your printer should show up.  Select it and complete the wizard.  Your new printer will be set as your default printer.

That’s all. Now you can begin printing in Windows.

Leave a comment

Filed under Computer - Technical, Linux

Configure Error: You need boost/bind.hpp from the boost library to run Aleph One


If you are receiving the errors below during your installation of Aleph One (I’m trying to get this on my machine so I can try out Marathon),

checking boost/bind.hpp usability... no
checking boost/bind.hpp presence... no
checking for boost/bind.hpp... no
configure: error: You need boost/bind.hpp from the boost library to run Aleph One

then you can install the dependencies you need by typing:

sudo apt-get install libboost-thread-dev

Happy gaming.

Leave a comment

Filed under Computer - Technical, Linux