>I've got a product that is supposed to take legacy COBOL code and port it into a COBOL/CGI project suitable for Internet. It does this quite well. The problem is having the application find the data. As long as I am in development mode, it uses my mappings and finds the data files with no problem. As soon as I move the app to the test server, it can't. Even with a drive (share) mapped to the data server.
>
>ANY ideas would be appreciated since this project is one of the Big Boss's pets and he wanted it done two weeks ago.
Have you tried using UNCs rather than mapped drives? (this assumes VFP 5.0)
You can also create a drive mapping on the fly using API calls from VFP 3 or 5:
,pre>
DECLARE INTEGER WNetAddConnection IN Win32API ;
STRING cRemoteUNC, ;
STRING cPassword, ;
STRING cLocalDrive
* password and UNC should be null (CHR(0)) terminated, drive letter should be drive letter +':'
IF WNetAddConnection( cUNCToMap, cPasswordToUse, cDriveLetterToMap) = 0
* It worked
ELSE
* It failed
ENDIF