Server not yet open error.....ODBC

[robmason10]

Trying to run a report from another machine that works fine on my machine.

Firstly I get ODBC ERROR:[Microsoft][ODBC Visiual FoxPro Driver] cannot open file c:\temp\7ac30002.tmp

then I get server is not yet open.

suggestions please?

Thanks

 

[bjrollet]

Not sure, but have you tried the SetLogonInfo method before you tried to open the report?

 

[robmason10]

Found out that it was profile related - we had a corrupt profile that would not allow write access to c:\temp - causing the problem when the querey was initially ran. Go there in the end - thanks anyway