Our network has added an off-site location about 2 miles away. Using compiled
v95, a VPN connection, and a terminal server. The database remains on Drive Y
on our in-house server and I thought all the processing actually occurs there.
Nothing goes to each computer except screen shots. Response is pretty good.
Reports all follow the same process : complete data, create PDF, check/store
it, then print it. Works every day at our in-house network. Going off-site we
can't get the PDF file back to our Network Drive Y for storage:
1. Here is my code to create the file name:
SET VAR vCurrDir TEXT = ((CVAL('CurrDir'))+'\PDFs\')
SET VAR vStDate TEXT = (sstrip(((CTXT(.#DATE))),'/'))
SET VAR vStTime TEXT = (sstrip(((CTXT(.#TIME))),':'))
SET VAR vDateTime TEXT = (.vStDate+'_'+.vStTime)
SET VAR vRep TEXT = ReportName
SET VAR vRepTitle TEXT = ((CTXT(.vZID))+'_'+.vRep+'_'+.vDateTime+'.PDF')
SET VAR vFileName TEXT = (.vCurrDir + .vRepTitle)
>From here it goes through a standard PDF process stored in a table and driven
>by variables adjusted for each report.
On the Network, CurrDir is 'Y:' while on my development machines CurrDir is
'C:'. There is no C:\PDFs\ directory on the off-site computer. Normally the
process creates a PDF on 'vCurrDir' and the user can decide to keep it or erase
it. How can I make sure off-site '.vCurrDir' returns to server 'Y:\PDFs\? Is
there something special about VPN connection terminology we are missing?
Tom Frederick
President/CEO
Elm City Center
1314 W Walnut
Jacksonville, IL 62650
W- 217-245-9504
F - 217-245-2350
E - [email protected]