Sunday, July 30, 2006

Munich,so movie

Recreation of the hostage taking at the Munich Olympics and the other terrible things that followed are the substance of this movie starring Eric Bana. Acting is mediocre not withstanding Steven Spielberg, but the movie has a few good shots of some European cities.
My rating(on a scale of 10) is 4.

Friday, July 28, 2006

Sun Studio Creator to SQL 2000...amazingly easy (2004)

Connecting to SQL Server 2000 from Sun JavaTM Studio Creator

This year 2004 article was previously on my password protected site:

It was amazingly simple to connect to a database on a SQL Server 2000 on the local machine to the Sun JavaTM Studio Creator. Connecting the Weblogic Workshop 8.1 application server to an SQL server was not this easy. In fact it was easier than connecting from VB/Visual Interdev to an SQL Server. When you start the Sun Java Studio Creator you will see a number of windows that come up for Project View, Properties, Palette, etc One of these windows is the "Server Navigator". Server Navigator folder structure is shown in the first screen shot.

When installed for the first time, the IDE comes up with its own "Travel" database in the POINT BASE server.

You can add other datasources from other database servers, such as MSSQL, Sybase, Oracle, etc. All that is needed is to right click on the Data Soures node to bring up the following dialogue:

If you click on the Add Source menu item, you will presented with the next dialogue:

Here you can name a data source( "Test Bibilo" ) for example.
You can choose the server type, in this case SQL Server
Next item is the database name, you must know what this should be before hand (If you do not know, open for example Enterprise manager and find by expanding the Databases node.
Next is the host name of the SQL Server, in this case 'localhost'(SQL Server is installed on the local machine)
The next two items are authentication information for the SQL Server, you should get it from your DataBase Manager. Database URL is an information required for the connection and this string is created by the IDE based on the previous selections depending on the type of database chosen This dialogue also shows tehe Driver Class, another piece of key inforamtion needed for making the connection. You may also test this connection before adding to the data sources folder. This is seen in the first screen shot where two datasources TestBiblio and TestPubs have been added in this fashion. Out of the box, this 'Early Access' software connects to the following databases at the indicated ports,

DB2 at port=50000
Oracle at port=1521
Pointbase Bundled at port=9092
SQL Server at port=1433
Sybase at port=5000

Jay Krishnaswamy, June 16, 2004

Monday, July 24, 2006

Compare bitmap files? Kidding!

Save them as *.txt file after opening with Notepad.exe
Then do a string comparison like in:
document.write("These bitmaps are the same: " & txt1==txt2);
Where txt1 and txt2 are bitmap files saved as *.txt files.

Movies I watched

"Secret Window" does grab your attention. Johnny's acting is good. It does look like it borrowed the thrills from 'A beautiful mind'.
My rating [on a scale of 10] 6

The French film, "L'HOMME DU TRAIN". It's good. All of us want to do something other than what we are doing now, in fact pining for it. Excellent ending.
My rating [on a scale of 10] 7

"The Devil Wears Prada" is passable comedy [if it can be called a comedy]. Merryl Streep is OK. Tucci is better.
My rating [on a scale of 10] 4

Friday, July 21, 2006

What about XML Data Island for Netscape and FireFox browsers?

XML Island is IE specific, in fact IE 5.0 and after, specific. For Netscape and FireFox you could blend-in script support as shown in this file Finnigans.htm.
<script type="text/javascript">
var xdoc=document.getElementById("xmlIsland)
<xml id="xmlIsland">
<xtest>Finnigan's wake</xtest>
This should show up in Netscape and FireFox producing an out put which is simply.

Finnigan's Wake

Do you have problems in coding for double quotes?

Try this script. Type it on Notepad and save it as .htm, or .html file. Make sure in the Save dialog you first set the file type to 'All Files'

<TITLE>Double Quotes </TITLE>
document.write("ok" & "<br>")
document.write(chr(34) & "OK" &amp;amp;amp; chr(34) & "<br>")
document.write("Now" & "<br>")
document.write(chr(34) & "" &amp;amp;amp; chr(34) & "," &amp;chr(34) & "" &amp; chr(34)& "," &amp; chr(34) & "" &amp; chr(34)& "<br>")
July 21, 2006<br>
Hello, Double Quotes
When you browse this file with IE you should see:

Thursday, July 20, 2006

Random thoughts on my articles this week

SQL Anywhere 10 is still in Beta and soon it will be released. I think it is a very interesting product. I have worked with verion 9.0, and this version looks lot better.
Let's say I have a database on Oracle 10g XE around which I need to set up a mobile application, a migration of the table to SQL Anywhere would be just what I would be looking for.

XML Islands and ADO will be what I will be writing about next week or so...

This is possible only in ADO.NET 2.0. Too much RAD, I may forget how to code.

Creating a new database in SQL 2005 Server

Creating a new database in SQL 2005 Server

Step-by-step procedure to create a new database

It's very easy to create a SQL 2005 database using the SQL 2005 Server Management Studio. This has not changed very much from SQL Serve except that the GUI has changed somewhat and its architecture is more tightly integrated with the other services and the .NET framework. Let's go directly and create a database, and when you find time, read about it in the BOL [Book on line]. Of course you may send me an email, or look up my other SQL and database articles at:

I assume you have installed the SQL Server and you are the sa. Login and connect to the Database Engine as shown in the next picture.

If login is accepted you will see the next screen. Right click on the database node to reveal the drop-down.

On this menu click on New Database... sub-menu item.

This opens up the next window as shown. You must give a name, the name of your database; keep it simple by associating it with some functionality, like say Address_ Book, Accounting, etc. In fact this is all that is needed to create the database. I created a database called SsisEditor by typing "SsisEditor" in Database name box and clicked OK. Presto the SsisEditor database was created.

The program creates many objects in this database that are needed because the two files created during this process are important files with extensions *.mdf for data and *.ldf for the transaction log (a log for things that gets changed in the database).

Friday, July 14, 2006

Zidane apologizes but does not regret

It does not help France now, but at least he cares for some people. I am not sure whether he apologized by himself, or he was made to, by his manager. Now let's see what our italiano does?

In the mean time despite Copa de Mundo, I have been able to add a few more articles:

On Oracle 10G XE:

Creating an Oracle Web Service Client for a Web Service Created in VS 2005
Developing Applications on Oracle 10g XE: Generating a Report
SQL Script Support in Oracle 10G Express Edition

Exploring Dailogs Controls in VB.NET
Creating a Database Project in VS 2005

Explosion on Mumbai trains costed ~190 lives. The people who ride trains in Mumbai are the guys who carry food to the workers in Bomaby, milk men, daily workers who clean buildings, etc.
What a waste of human life? Misery would only appear ten fold more.

Wednesday, July 05, 2006

ADO with ASP

You may use the following:

I have created a system DSN called 'ForAsp' for your illustration
I have an IIS Server on my machine
I have this page in my root directory:
<%@ Language=vbscript %>

dim conn
set conn=Server.CreateObject("ADODB.Connection") "DSN=ForAsp", "sa", "xxxxxxx"
dim rs
set rs=Server.CreateObject("ADODB.Recordset")
dim sql
sql="Select * from Employees" sql, conn
do while not rs.eof
response.write(rs("LastName") & "<Br>")

I call this file, hodentek.asp
When I browse this file on the local server using this http://localhost/hodentek.asp
I will see one line each, all the last names of employees in the Northwind's Employee table.
This should give some ideas to you.
Hope this helps.

Tuesday, July 04, 2006

June 2006 Articles

New articles written during June 2006
Loading Spread Sheet Data into Oracle 10G XE
Migrating from Oracle 10G XE to SQL Anywhere 10
On Using AccessDataSource Control in VS 2005
Provider Factory in ADO.NET 2.0
On Using ADO's Record Object with URLS
Exporting XML from MS Access 2003
Importing XML into MS Access 2003
A demo using the Wizard Control in ASP.NET 2.0
The Why? and How? of XML Data Islands
Introducing Jasper (SQL Anywhere 10 Beta)

All these articles should appear on one of these sites:

This month was crowded with activities. There was World Cup and I wanted to watch my favorites (the Brazilian team) win, but alas! they did not.
The semi-finals between Italy and Germany was fantastic and there was a big party at Circo Maximo in Rome. How I wish I was there with a glass in my hand and my favorite girl, my wife with me? But anyway, I did put in some work to get the articles going.

Jasper (Sql Anywhere 10 in beta) is real cool.

Flex2 is not in beta anymore. I miss coding with it, because I cannot aford to buy it, just because I fancy it.

Exporting XML from Access 2003 works great, but not importing XML.

I did get this other article on Oracle 10G XE online as well in June. It's about creating a front end program for Oracle 10G XE using none other than MS Access 2003. Well, Oracle 10G XE also has an excellent built-in application tool. But it is always good to know an alternative method. Actually, MS Access 2003 does a good job of it. Read more on this at:
Creating an MS Access 2003 Front End for an Oracle 10g Express Edition Database Protection Status