Archive for May, 2009

On SQL Server 2005 Express Edition (I don’t know how’s on full version, never had a license for it) the default connection model is through named pipes and TCP/IP is disabled.

If you want to connect to it from Oracle SQL Developer using jTDS driver it will throw a generic connection failure, as he is trying just TCP/IP. The error looks like this:
2009-05-31_1408

In ordrer to enable TCP/IP you have to do a few steps:
Read the rest of this entry »

Tags: , , , ,

Comments 10 Comments »

xe_logoBest way to have a easy to access XE database and APEX on top of it is to put them on a Ubuntu Server virtual machine that I start just when I need.

Installation of 10g Express Edition should not take more than 10 minutes and the steps are below:

1. Prepare the swap space
If you have less than 1GB memory run the following commands to create swap space:

$ sudo dd if=/dev/zero of=/swpfs1 bs=1M count=1000
$ sudo mkswap /swpfs1
$ sudo swapon /swpfs1

Read the rest of this entry »

Tags: , , , , ,

Comments 20 Comments »

I am a big fan of Ubuntu Server. It’s exactly what you need for a server, no fancy UI, just services.
Dealing with all the text configuration files can be a time consuming task and there is something that can help a lot. It’s called Webmin and it is a web interface for configuring your linux box.
figure1

You need to install first some perl-related libraries required by webmin:

sudo apt-get install perl libnet-ssleay-perl openssl libauthen-pam-perl libpam-runtime libio-pty-perl libmd5-perl

Read the rest of this entry »

Tags: , , ,

Comments 37 Comments »

Total Commander – File Manager – I am using it since version 3, ~10 year ago. Simply not replaceable.
wcmdbig

Pidgin – Instant Messaging – Single client for all protocols, including Oracle internal one.

Launchy – Application Launcher – just press ALT+Space and write a few letters from app name to start it

MPlayer – Movie Player – no GUI, just console, very quick, no need to install codecs. Some issues with external monitor.

Firefox – of course, user since version 0.9 Beta

Dropbox – File Sync – simple sync of some folders between laptops or laptop and desktop. As a bonus files are stored online and you get revisions history

Google Mail – Personal Email – lot of space, even bought extra. Can also use it to read other POP3 accounts, all in a single interface.

Google Reader – RSS reader – the best RSS reader

Google Calendar – Calendar – simple to use, simple to share, to sync. Can also use it to read other calendars.

TripIt – Booking Manager – just forward all the travel plans to Tripit and you’ll have your itinerary ready, published as a web calendar, links to online check-in and other usefull stuff.

Related posts:
%RELATEDPOSTS%

Tags: , , ,

Comments No Comments »

Trying to connect to SQL Server 2000 or 2005 from Oracle SQL Developer having Windows Authentication enabled on SQL Server will fail with:
“I/O Error: SSO Failed: Native SSPI Library not loaded. Check the java.library.path system property.”
sqldev_winauth

The solution is simple: place a dll called NTLMAUTH.DLL (NT authentication) in your system path and restart SQL Developer. Windows/System32 is always a wise choice.

Where to get this DLL? It is shipped with JTDS here.

Is there another option? Yes, enable SQL Server authentication.

Related posts:
%RELATEDPOSTS%

Tags: , , ,

Comments 2 Comments »

ubuntu-serverUpgrading the Server version of Ubuntu 8.10 to the latest one, 9.04 is not a big deal as I read here.

I did it in 10 minutes as following:
1. Install update-manager-core if it is not already installed:

sudo apt-get install update-manager-core

2. Launch the upgrade tool:

sudo do-release-upgrade

3. Follow the on-screen instructions.

Good luck,
Andrei

Related posts:
%RELATEDPOSTS%

Tags: , , , ,

Comments No Comments »

I’ve been told that there is no way to connect to a SQL Server 2005 named instance from SQL Developer. That’s not necessary true, but it’s strange.

A bit of background information: SQL Developer is connecting to SQL Server through JTDS opensource driver. The driver said that it cannot support named instances. On the other hand, in the connection string, there is a syntax for named instance, like “instance=your_instance“.
Read the rest of this entry »

Tags: , , , , ,

Comments 3 Comments »

In Macedonia toata lumea face misto de muntenegreni ca ar fi puturosi. incerc sa imi reamintesc cateva din zecile de bancuri cu ei pe care mi le-au zis partenerii azi:

– ce face un muntenegrean dupa ce se scoala?
– sta un pic pe scaun sa isi traga sufletul dupa somn

Au facut ei un referendum si au stabilit ca Miercurea e zi lucratoare, Joia se odinesc dupa munca, Vinerea se odihnesc inainte de weekend, Sambata si Duminica e weekend, Luni se odihnesc dupa weekend si Marti se pregatesc de munca. Intrebari?
– O sa lucram fiecare miercuri?
Read the rest of this entry »

Tags: , ,

Comments No Comments »

Trebuia sa ajung la Skopje, Macedonia pentru un workshop. Nefiind o destinatie prea la moda am gasit (cam) singura varianta de zbor prin Budapesta.

Plecarea la 10:40 de la noi, sosirea la 15:10 ora locala (CET) in Skopje. Elegant si as fi avut si posibilitatea sa vad finala UEFA, ca doar nu m-am uitat ca prostul la o gramada de meciuri sa pierd finala…

Ei bine, cum ziceam, as fi avut posibilitatea. Am ajuns in aeroport pe la 9 si pe panou mare “BUDAPEST – CANCELLED”….. fuck!
Ma duc repejor la ghiseu, mai patisem si asteptam o rerutare.
Cocoana Malev: “Aaa, sunteti domnul care merge la Skopje! Imi pare rau, tocmai incercam sa gasim o solutie de rerutare prin Istanbul, dar aveti connection time 10 minute, nu merge. Imi pare rau, nu avem nici o solutie, veniti maine dimineata”.
Eu ma tineam tare: “Doamna, nu suntem la alimentara cu azi n-avem, veniti maine… n-are rost sa va descriu pe larg motivele dar maine dimineata eu trebuie sa fiu in Skopje”.
Cocoana: “Va cred, imi pare rau, n-avem ce face”.
Read the rest of this entry »

Tags: , , , , , , ,

Comments 4 Comments »