Below are some different examples of ways to connect via ODBC and via a vb script or php coding to either a SQL Server, MySQL, Oracle, or MSAccess table:

VB Script connecting via ODBC and updating a table in a SQL Server db:

Set WSNet = CreateObject("WScript.Network")
varUserName = WSNet.UserName
Set WSNet = Nothing
Set MyConn = CreateObject("ADODB.Connection")
Set RS = CreateObject("ADODB.Recordset")
'modify the below lines to use/tap into an Oracle or other MySQL driver
MyConn.open = "DRIVER={SQL Server};"_
& "SERVER=SQLSERVER;"_
& "DATABASE=DBName;"_
& "OPTION=35;"
sql_query = "UPDATE dbo.MyTable SET SomeField ='" & "SomeValue" & "' WHERE ID ='" & ID & "'"
' or put whatever SQL code in place of the statement above
'ex: set sql_query = MyConn.Execute("DELETE * from MyTable")
'ex: set sql_query = MyConn.Execute("INSERT INTO MyTable (Field1, Field2) SELECT
MyAccessLinkedOracleTable.Field1, 'MyAccessLinkedOracleTable.Field2
'FROM MyAccessLinkedOracleTable")
MyConn.Execute sql_query
MyConn.Close
Set RS = Nothing


Set MyConn = Nothing

or against an mdb file without opening the actual mdb itself in a VB Script using ADO:

Set WSNet = CreateObject("WScript.Network")
varUserName = WSNet.UserName
Set WSNet = Nothing
Set MyConn = CreateObject("ADODB.Connection")
Set RS = CreateObject("ADODB.Recordset")
MyConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\HelpForOthers\MyMDBFileName.mdb"
Set RS = MyConn.Execute("UPDATE MyTableName SET SomeFieldName ='" & "SomeValue" & "' WHERE ID ='" & SomeID & "'")
' or put whatever SQL code in place of the statement above
'ex: set RS = MyConn.Execute("DELETE * from MyTable")
'ex: set RS = MyConn.Execute("INSERT INTO MyTable (Field1, Field2) SELECT MyAccessLinkedOracleTable.Field1, 'MyAccessLinkedOracleTable.Field2
'FROM MyAccessLinkedOracleTable")
MyConn.Close
Set RS = Nothing
Set MyConn = Nothing
retval = msgbox("Table Updated")

or if you can execute php scripts on the box against the SQL or MySQL server:

<?php
$dsnname = 'MyODBCDSN';
$user = 'sa';
$password = 'password';

$connection = odbc_connect($dsnname, $user, $password);
//Passing IDField value to php script
$IDField = $_REQUEST['IDField'];
$ETime = DATE("m/d/y h:i:s A");
$query = "UPDATE MyTableName SET MyTableName.EndTime = '$ETime' WHERE MyTableName.IDField = '$IDField';";

or
$query = "INSERT INTO MyTableName (IDField, Field1, Field2, Field3, Field4, Field5)
SELECT '$IDField', '$SomeValue1', '$SomeValue2', '$SomeValue3', '$SomeValue4', '$ETime';";

$rs=odbc_exec($connection,$query);
odbc_close($connection);
?>

or another method to connect via a php script using the IP address:

<?php
//Enter IP Address below of SQL Server or MySQL Server
$server = '128.100.100.100';
$database = 'MyDBName';
$user = 'sa';
$password = 'password';
$connection = odbc_connect("Driver={SQL Server Native Client 10.0};Server=$server;Database=$database;", $user, $password);
if (!$connection) {
echo "Connection Failed";
} else {
echo "Connection Made!";
}
?>