I have 2 servers. 1 is the webserver and hosts a job management system I am writing in CFMX. the 2nd is the accounts server which hosts our accounts software. All accounts information is stored in an Access database. The software is called Sage.
What I need to do is when a new job is submitted through the job managment system, it needs to submit certain information to sage and then allow sage to allocate it with a job number.
The problem I am having is creating the datasource for the Sage DB. The Administrator only shows local drives. I have mapped the directory as drive S on the webserver but that doesn't show up in the list.
Is there away of submitting information over the network?
Thanks in advance