MY TCP/IP SETUP -  MAY BE YOURS TOO

-
How to convert DBF file to Mysql database file ?

1. There is a program called dbf2Mysqlw32.exe which converts dbf file into sql script file with the extention .sql. The dbf2Mysqlw32.exe can be anywhere. To execute it just type dbf2Mysqlw32 directory\filename.dbf eg dbf2Mysqlw32 c:\ham\callbook.dbf. You will get a file called callbook.sql. This is a script mysql file.

2. To run callbook.sql you must be in Mysql > command. That means you have to enter mysql. My Mysql is in Mysql\bin directory. I invoke Mysql command by typing Mysql.

3. Type Mysql > Source callbook.sql.

Remember to create a table first before running the script. Fields must be the same. You can see the fields name by typing edit callbook.sql.

Good Luck !

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1. For windows XP - use your way to go to control panel. In there open network connections. Icon Local Area Connection appears. Right click - properties  scroll to get TCP/IP. Click properties.

2. You'll a box like the one on the left. In the first box type an IP adress. 192.168.1.(number 1 to say 9) depends on the number of computers you need for networking. Then fill in the subnet mask, default gateway, prefered DNS server and alternate DNS servers as the numbers you see in the figure.

3. When done, click OK.

4. Boot your computer.

Remember to syncronise this IP number with your router IP. What if it is different ? It will only be a problem you are doing port forwarding.

You can refer to old boy Zainal 9M2ZA for info on port forwarding.

 

MY SIMPLE LOGBOOK

My logbook is link to qrz.com database

1. Listen to the calling station.

2. Enter hiscall sign

3. Click the QRZ.Com button

4. To remove the qrz.com's page, just click the  same button again.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

SHARING FILES WITH 2 COMPUTERS USING WINDOWS XP

1 . Make sure both computers mark File and Printer Sharing for Microsoft Networks.Click OK.

2 .Go to My Network Places

3. Click network setup wizard.

4. Go on clicking the next button until you come to this box.

Your computer is connected to the network via a residential gateway. Choose the option button in the center.

Continue to click next until finish.

6. Go back to my network places and click Add network place. Follow the instructions.

FOLDERS TO BE SHARED - RIGHT CLICK THE FOLDER AND CHOOSE SHARING.

Good Luck.