Remote Desktop for Workstations with private IP addresses

Sometimes we want to access our Windows workstations remotely to be able to see our data. If the workstation is connected to the Internet, doing such is relatively easy in Windows XP with Remote Desktop. Just hit "run" and type "mstsc". Type the ip address and some credentials, and you're done. However, some Internet service providers assign you with a private IP address (e.g. 192.168.0.24). This cannot be seen over the Internet and thus, doesn't allow you to connect to your remote workstation. There is a workaround for this for those who don't know yet. Hamachi is a windows application that allows connectivity through a Virtual Private Network. It's like having your own Local Area Network over the Internet. It's virtually zero configuration so it's relatively easy to use. Click here to download. Once you've installed it, you will be assigned an IP address. You can then create your own network of trusted workstations, from which you add your remote workstation. From here, you can access your remote workstation through the ip address assigned to it by Hamachi, through the same process using remote desktop.

Comments

Using Crystal Reports 10 with C#.net and Firebird

C# express doesn't include a report designer or viewer. Reports however, is very much needed when creating a business software. Since C# express doesn't include a report designer, we need to find other means. One is to use a free report such as MyNeoReport. This however may not work under many circumstances. The other alternative would be to use a proven report engine and designer-Crystal Report. Crystal Report has been used by many developers (in our city). However, using a free programming language and IDE, and a free database is very limiting. Not much information can be gathered on the net either (with regards to reporting as of this writing). Here's a way to use Crystal Reports using Firebird database and C# Express as software development IDE: Pre-requisites: C# Express 2005 EMS SQL Manager 2005 for InterBase & Firebird Lite Crystal Reports 10 Create the following database: Name: TestDB1 Tables: TESTTABLE1 Columns: ID - PK, INTEGER,AUTOINCREMENT DES...

Number to Text in Excel

I was asked today by one of my classmates about converting numeric values to literal values in excel. I thought there was a function for this but I found none. Well I was curious so I looked it up on the web . I've done a little modification here to make it more or less generic (specially when writing in checks). Here's how it's done: Click Tools->Macro->Visual Basic Editor Insert a module Paste the following code: Option Explicit '**************** ' Main Function * '**************** Function SpellNumber(ByVal MyNumber) Dim Temp, WholeNumberText, DecimalText Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Million " Place(4) = " Billion " Place(5) = " Trillion " ' String representation of amount. MyNumber = Trim(Str(MyNumber)) ' Position of decimal pl...

Using Firebird with ASP.net

In my previous post , I was able to connect a firebird 2.0 database to asp.net using controls. The next goal was to connect to a firebird database using the firebird.net engine and using the repeater control. I however, was able to use the firebird.net engine to connect to the firebird database but not to the repeater control. I used the html table tag. I've created a simple asp.net demo displaying the contents of a firebird database on page load. Here are the steps: 1. Things Needed: Firebird 2.0 Server Firebird 2.0 Client Visual Web Developer 2. In Visual Web Developer, create a new ASP.net Website (using C# as the programming language). The project will have a default page named Default.aspx. Make sure that the code is separate from the page (ex. Default.aspx.cs is separate from Default.aspx) 3. On the Website menu, click on Add Reference. 4. Select the Firebird - ADO.net 2.0 Data Provider and click Ok. 5. Add using FirebirdSql.Data.FirebirdClient; to the "using" sec...

RixxTech

Search This Blog