Archive for the “Programming” Category

.NET (C#), PHP

Oracle apex 3.1

I’ve been asked many times if there is possible to install Oracle Application Express on Express Edition of 10g database, both of them being free products. The answer is YES, and the procedure is quite simple, as very well indicated on Oracle website

The steps would be: Read the rest of this entry »

Tags: , , , , , , , ,

Comments 3 Comments »

SQL Developer 1.5.1

Starting with 9th of June, a new version of SQL Developer was launched. This is more a patchset to previous version, solving a significant number of bugs.
I am very happy that the “Bug 6994152: ORACLE_HOME environment variable sometimes has an adverse affect on migrations” was solved, this being a very frequent topic on the migration forum. Now there is no need to create the .CMD file to overwrite ORACLE_HOME.
Another useful and very demanded feature is auto-expand of the connections list when open the tool.
Read the rest of this entry »

Tags: , , ,

Comments No Comments »

Did you ever want to check a website as it was 1 year ago for example? I do want, because lots of websites that I initially developed were redesigned during the years and it was nice to find my work in the archive.
How it’s working? It’s a search engine that takes a snapshot of every website on a regular basis, normally every month.
Where? At: http://web.archive.org

Lots of people are asking me about MPMCostumes.com. They decided to remake the website with their initial partners, even that with my platform they sold more than 20K USD in a few months. Unfortunately on http://web.archive.org the images and flash animations do not appear, but you still can check it as it was 2 years ago.

Tags: , ,

Comments No Comments »

Web 2.0 is everywhere, lot of people pretend that they are developing web 2.0 applications, but not all of them succeed. I will not make a review here, but just want to unveil some tools that will help building web 2.0 web sites.

1. The fundamental of web 2.0 is Ajax, which is no more than reloading just parts of the page via JavaScript without reloading the whole page. In order to use Ajax on-the-fly you need to use Prototype JavaScript Framework. Prototype also Read the rest of this entry »

Comments 1 Comment »

Ionut recently showed me a very nice place to download IT books. I personally found lots of very useful ones to use. Check this out:
http://www.xpressionsz.com

Enjoy.

Comments No Comments »

I wrote a lot how to install loopback adapter, how to set the ip address (either manual or automatically), how to add an entry to hosts file (either manual or automatically). Now let’s add all together into a single script.
The script will do the following:

  • call DevCon to install Microsoft Loopback Adapter (you need to download DevCon and save it in the same folder as the script)
  • set the IP address and mask for the recently installed loopback adapter
  • dinamically read from Windows folder the hosts file
  • dinamically read the hostname
  • add a new entry to the hosts file with the supplied IP address and hostname
  • ping the hostname and check if the supplied IP address is responded
  • MOST IMPORTANT: everything is dynamic and automatic. You don’t need to edit the script before each install. Just run it!

You can download this script here: Read the rest of this entry »

Tags: , , , , ,

Comments 3 Comments »

As a common practice all the servers have fixed IP address. Because not all Oracle Databases are installed directly on servers, but on laptops or different machines, it’s very probable that you have DHCP-provided IP address.
If you have DHCP IP address, your full computer name may vary, because different domain is added to computer name. Once the name can be mylaptop.oracle.com, the next day the name can be mylaptop.myhomenetwork.ro and so on.
The problem is when you want to install Oracle Database Enterprise Manager (web-based administration tool), because the installer is creating a folder on the disk have the name based on fully computer name. If you change the network the Enterprise Manager will not work, because it will not find a folder based on the actual computer name.
Enterprise Manager is not crucial , it’s just an interface, so if you don’t want to install it your database will work the same and you will configure the database through SQL*Plus or SQL Developer or Toad or what third party admin you want.
Read the rest of this entry »

Tags: , , , , ,

Comments 1 Comment »

What do you need to know before configuring Loopback Adapter?

  • do not set the gateway because you can screw you internet connection
  • do not set DNS because you really don’t need it
  • do not set 127.0.0.1 or 192.168.0.1 or addresses from the same class as your internet connection address

The addresses that I’m using most of the time are 10.10.10.10 and 192.168.100.100, both with 255.255.255.0 as mask.

Let’s see how can we set the IP address from the command line.

Solution 1
=======

Netsh.exe is a tool installed with Windows 2000, XP and 2003 Server. Read the rest of this entry »

Tags: , ,

Comments 7 Comments »

Because lots of applications (including Oracle Database) require Microsoft Loopback Adapter installed if you have DHCP-enabled machine, I tried to find a solution to automatize the installation of this dummy device.
Lots of attendees that I had on my workshops are configuring the loopback adapter with strange IP’s, gateways and the most common result is malfunctioning of the internet connection.

First of all we need a command prompt utility that will act the same way as Device Manager. Microsoft has an utility like this called DevCon (probably from Device Console), but for some strange reasons it is not redistributable, so you need to download it from their site.
DevCon’s description is http://support.microsoft.com/kb/311272 and download link is this.
Read the rest of this entry »

Tags: , ,

Comments 3 Comments »

1. Windows 2000
2. Windows XP
3. Windows 2003
4. Windows Vista

1. Windows 2000

Click Start, point to Settings, click Control Panel, and then double-click Add/Remove Hardware.
Click Add/Troubleshoot a device, and then click Next.
Click Add a new device, and then click Next.
Click No, I want to select the hardware from a list, and then click Next.
Click Network adapters, and then click Next.
In the Manufacturers box, click Microsoft.
In the Network Adapter box, click Microsoft Loopback Adapter, and then click Next.
Click Finish.

Read the rest of this entry »

Tags: , ,

Comments 2 Comments »