scripts

[al_3asel]

Hi all,

I need scripts programmed by java or Visual basic to scan a microsoft access database

If any one can help me !!!!

[buntine]

We need more info.. What exactly do you want the application to do? Scan for what?

Regards.

[al_3asel]

ok
I need this script to connect the ms database which has “ DeviceId”, “DeviceName”, “DeviceLocation”, “MACAddress” , “ RegisteredState” ……etc.
This script should compare through scanning the running devices in our network to the devices existing in the database. The script compares the devices running by its MAC Address and MACAddress in the database. The results of this script are “the device is registered” if the script found the MAC address is equivalent to MACaddress of a device otherwise “ the device is not registered in our network”.
*** note that the MACAddress is primary key in the database

thank you buntine for your reply

[buntine]

Ok, your going to need a working knowlegde of ADO (ActiveX Data Objects), Microsofts answer to format-independant database connectivity. JDBC - Javas equivelent.

www.asp101.com has some good examples.

Also, a basic knowledge of SQL is required, for extracting records from the DB.

The following articles may bge helpful when working out how to get the machines MAC address.

-http://www.dotnet247.com/247reference/msgs/25/127283.aspx
- http://dotnetjunkies.com/WebLog/jonne%20kats/archive/2004/02/26/7988.aspx

Regards,
Andrew Buntine.