Scheduled ODBC import

[JimM]

Hello all -

I'm having a difficult time setting up a new Win2k8 64bit server, that I will be running FMPSA v12. I have a number of different ODBC DSN's configured, and all of them function properly when run in the interactive mode: ie I connect to the hosted FM database, and invoke the script that performs the refresh (delete existing records, and reload from corporate datasources); but fail when run as a FMPS scheduled task. There is no definitive error log left, other than the FMPS event which is a error code 1408[Extended error (ODBC)]/. I've tried turning on odbc tracing, but that does not seem to accomplish anything. The server machine, and my local machine have IDENTICAL ODBC definitions, I have also ran the script locally on a client on the server so I know the DSN's are good. These are connections to FoxPro v8 and the drivers are 32 bit. I also tried this with FMPSA 11 just for kicks and got the same results.

Has anyone experienced anything similar? Have any suggestions to resolve the problem?

Thanks in advance for any & all suggestions.

Jim Moore

[JimM]

Found the answer.

For some reason, Servers can only read "server-local" data during script executions, though client machines can read multiple data servers just fine. I moved my data to be imported local and the server side ran fine. I wish that would get fixed. I thought they would have in 12. Oh well.

Jim