I did it: IronPython reads Oracle 10g!

 No Responses »
Jan 052005
 

Not too big a accomplishment for the experienced .NET-programmer, but since I’m still learning .NET, and ODP.NET and IronPython, I think I did something great. This is the script (don’t be scared):

1
2
3
4
5
6
7
8
9
10
11
12
13
import sys
sys.LoadAssemblyByName('Oracle.DataAccess')
from Oracle.DataAccess import *
from Oracle.DataAccess.Client import *
OraCon = OracleConnection()
OraCon.ConnectionString = 'User Id=scott; Password=tiger; Data Source=ORCL'
OraCon.Open()
OraCmd = OraCon.CreateCommand()
OraCmd.CommandText = 'select ename from emp where deptno = 20'
OraDR = OraCmd.ExecuteReader()
while OraDR.Read():
    print("Employee Name: " + OraDR.GetString(0))
OraCon.Close()

And this is the output:

 Posted by at 23:32

Oracle HTML DB 1.6

 No Responses »
Jan 052005
 

While you’re at the Oracle download pages, have a look at their HTML DB version 1.6. It’s a browser-based development-tool for webapplications; you can view a quicktour here.

Very neat stuff.

 Posted by at 00:25

IronPython connecting to Oracle!

 No Responses »
Jan 042005
 

Okay, so IronPython is a .NET language. Let’s see if we can pull this of: connect to Oracle using the ODP.NET drivers from Oracle.

The first time I opened the connection, I got an ORA-12541, reminding me that I switched the database to manual startup. I started the listener and the database and the second time the connection went okay.

Wow. This is powerfull stuff. And…in realtime. No compiling needed.

 Posted by at 23:24

downTHEMall

 No Responses »
Jan 042005
 

If you use Mozilla Firefox (and why shouldn’t you?!) and you regularly leech content from pages, you should try downTHEMall. It’s a plugin that install in the Tools-menu, and with a page present, you can select downTHEMall. It displays a dialog WHAT you want to download and WHERE you want to save it. After using it, you can also select Turbo-DTA, that uses them same settings as the last time without presenting a dialog.

 Posted by at 17:33

ActivePython not a .NET language?

 No Responses »
Jan 042005
 

I mentioned that ActivePython is a .NET language, as IronPython is. But the command:

>>> from System.Windows.Forms import *

results in an errormessage: Importerror: No module named System.Windows.Forms.

 Posted by at 12:09

Free e-book

 No Responses »
Jan 042005
 

Apress is giving away the ebook “Dissecting a C# Application: Inside SharpDevelop”. And if you don’t want to receive their newsletter, you don’t even need to supply an e-mail-address. The download is split into two parts: the book itself (3.8MByte PDF) and the accompanying source-code (5.9Mbyte ZIP).

 Posted by at 11:27

My first Python “program”

 No Responses »
Jan 042005
 

It sure is a simple language to learn. Thanks to all the people that blogged about it. Very usable language. Simple (and dymanic) semantics. To be used as scripting or as standalone programming language. And IronPython (as well as ActivePython) are .NET languages!

 Posted by at 00:15

Rearranging the house

 No Responses »
Jan 022005
 

Our Christmas-holiday was well spent. We changed the three bedrooms on the first (for the US-people, the second floor, we don’t count groundlevel) floor. The master bedroom looks twice as big now, my computerroom is now half as big, and the guestroom is now in the former computerroom. Now all we have to do is to get rid of the packaging of all the IKEA-stuff we bought! It’s a massive pile of paper now.

 Posted by at 11:49

2005

 No Responses »
Jan 022005
 

A little late, but I wish you all a happy and healthy 2005!

 Posted by at 11:30
 Newer Entries