Wednesday, May 21, 2008

How can I access my desktop/laptop from another computer?

Before you can access your computer remotely[[it is assumed that the computers are connected or networked] you need to enable it. The figure shows how you may do it in the SYSTEM folder [Remote tab]in the Control Panel (Windows XP). Place a check mark for Allow users to connect remotely to this computer.

This is a neat way to work with two computers at the same time from one set of keyboard, mouse and monitor. You can copy and paste from most files, especially if they use the same program. For example you can copy contents of Notepad from one computer[this is the local] and paste it into the other [this is the remote]. It helps you to keep the monitor display color different so that you don't get confused between the local and the remote.

Added: May 22 2008

Additionally you may also need to enable this in the firewall as an exception as shown in the next figure. By default this is not enabled. Place a check mark for the Remote Desktop and click OK.

Once enabled you go to the other computer and establish a remote connection as described in

Sunday, May 18, 2008

How do I connect to an Oracle 10G XE database from Visual Studio 2008?

The following code should help you in opening a connection to Oracle from VS2008. You need to know the connection string. For USERID and PASSWORD you should use what is appropriate for your database.

With OracleConnection you can do lot more than just making a conneciton.

Friday, May 9, 2008

How do you change computer time on a remote computer?

One way to change the time settings on a remote computer is to go to " All Programs-->Accessories--> Communications--> Remote Desk Top" on your computer[assuming you are using Windows XP (tested here), but may work with other Windows OS] and log on to the remote computer. When successful you can change the time just like you change time in your local machine.

Thursday, May 8, 2008

ActiveX Script Task to access a Report on a Report Server in SSIS 2008

The following ActiveX Script used in an ActiveX Script task can can display a web page in the IIS web server. However the task may fail. This is one of identified bugs.

Function Main()

Set oIE = CreateObject("internetExplorer.Application")oIE.navigate "http://localhost/SilverLight/TestSilverLight.htm"
oIE.Visible = true
end function

To display a Report deployed to a Report Server (Sql Server 2008) the following script can be used. Notice the processing instructions in addition to the URL of the report,

Function Main()

Set oIE = CreateObject("internetExplorer.Application")oIE.navigate "http://hodentek2:8080/ReportServer/Pages/ReportViewer.aspx?%2fRSProject%2fpubsAuthors&rs:Command=Render"
oIE.Visible = true
end function

Make sure the Report Services is running.

The task completes but the task fails. Opa!

Here are the Execution Results:

Saturday, May 3, 2008

This blog is for providing help

I often get emails asking for help and in most of the cases I respond. Sometimes I have the answers, sometimes I try to simulate the problem and find answers, and sometimes I cannot. I do feel that the answers should be shared with others who are looking for the very same questions.

I blog on my Hodentek site on things I feel I should be concerned about, on things I constantly think about, and also regarding my writings. It does take time and effort to write and I sincerely hope someone can benefit.

Jayaram Krishnaswamy
Plainsboro, NJ
May 3, 2008