[thelist] database connection across different IP's

[Anthony Baratta]

Paul...

Just to add a bit of clarification:

If they are using Access as their DB backend, you won't be able to query
the DB from the remote web server like you can with MS SQL or mySQL. Access
does not have a "listener" to interface with the DB.

However, you can use any Windows box (preferably Win2K or higher, server or
desktop) to automate a data push to your remote web server. Since the local
Windows box would have ODBC access to the Access DB, you can use a VBS
program to query the Access DB, compile your data, format it for transfer,
then push it to the remote web server.

You can communicate with the remote web server from the local Windows Box
via an admin script (perl, php, et.al) or via ODBC directly to the mySQL
Database.

Either way, you are going to need to establish the automated updates from
within the "local" network and shove them to the remote web server.
--
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."