using Excel as datasource for OPC server with OPC Datahub

i asked myself how to get rid of manual report using MS Word currently being used by Operation team. i figured out that using Excel - we can export the data live to OPC server using OPC Datahub.

Datahub uses DDE feature of Excel and export it to OPC format.

Dell R200 w/ Redhat Enterprise Linux 5.3 + Virtualbox

fyi, this is my kernel on RHEL 5..

[root@anwar ~]# cd /usr/src/kernels

[root@anwar kernels]# ls

2.6.18-128.el5-x86_64

- i downloaded RPM from Sun website.. for latest Vbox 3.0.6 r51260
- either extract the RPM by double clicking or using rpm -ivh command
- u get error asking u to re-run vboxdrv setup

no problem

- update kernel headers first

yum install SDL kernel-devel kernel-headers

- just accept whatever being installed / asked to be installed

yum groupinstall "Development Tools"

- make sure all ok

yum groupinstall "Development Libraries"

- make sure all ok

yum install unifdef rpm-build

- make sure all ok

now can start recompile Vbox kernel module...

[root@anwar dindon]# /etc/init.d/vboxdrv setup

Stopping VirtualBox kernel module                          [  OK  ]

Recompiling VirtualBox kernel module                       [  OK  ]

Starting VirtualBox kernel module                          [  OK  ]

now Virtualbox ready w/ your solid Redhat Enterprise 5.3 :)

Samba SMB config file for 172.20.200 NAS

Dell tower AMD server powered by Ubuntu 8.04 Server edition..

location = /etc/samba/smb.conf

[share-admin]
path = /home/share
browsable = yes
public = yes
writable = yes
guest ok = yes
guest only = yes
security = share
guest account = nobody
hosts allow = 172.20.1.7

[share-public]
path = /home/share
browsable = yes
public = yes
guest ok = yes
guest only = yes
security = share
guest account = nobody
writable = no

Samba SMB config file for 172.20.202 NAS

powered by Ubuntu Server 8.04

this is the settings i use for /etc/samba/smb.conf

[share-admin]
path = /media/hdd2/share
browsable = yes
public = yes
writable = yes
guest ok = yes
guest only = yes
hosts allow = 192.168.0.100, 172.20.1.7, 172.20.1.91, 172.20.1.203
security = share
guest account = nobody

[share-public]
path = /media/hdd2/share
browsable = yes
public = yes
guest ok = yes
guest only = yes
security = share
guest account = nobody