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:

In ordrer to enable TCP/IP you have to do a few steps:
Read the rest of this entry »
Tags: howto, jtds, sql developer, sql server, tcp/ip
10 Comments »
Best 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: 10g, download, Jaunty Jackalope, Linux, oracle, XE
20 Comments »
Posted by: Andrei in Linux
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.

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: Jaunty Jackalope, Linux, ubuntu server, webmin
37 Comments »
Total Commander – File Manager – I am using it since version 3, ~10 year ago. Simply not replaceable.

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: download, free, tips, tools
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.”

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: download, jdbc, oracle, sql developer
2 Comments »
Posted by: Andrei in Linux
Upgrading 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: 9.04, bunutu, Jaunty Jackalope, Linux, upgrade
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: 10g, 11g, jtds, oracle, sql developer, sql server
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: bancuri, macedonia, muntenegru
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: budapest, embraer, europa, Impresii de calatorie, malev, orase, skopje, zagreb
4 Comments »
|