|
pd_it_guy -> how do I? (6/9/2008 16:54:55)
|
We have an Access DB fed by a small test form on the public Internet server. Works exactly as expected. This is eventually to replace an online reporting function.
We now want to build a small web on the Intranet server that goes out to the public server and establishes a connection to that Access DB in order to retrieve and update the posted data, perform analysis, and eventually to send parts of this external data to other internal servers and applications. When I try to set up a database results section is where things are bogging down. It's a NEW database connection, but it is really none of the 4 choices presented. It is an Access DB, just an .mdb file, but unfortunately, it is located on a different server from where the results will be used. The wizard wants the .mdb on the same web, have it be a defined dsn, or have it be an SQL server.
How do I set up this new database connection so I can use the data from the public server on the Intranet server. Do I need to set something up on the Intranet server, like a DSN.
All ideas and direction gratefully appreciated.
|
|
|
|
