Re: -461 error on connect.

Ray O'Hagan wrote: > Hi, > > I have a stored procedure which system() calls one > of our applications. This application itself tries > to connect to the database, but I'm continually getting > a -461 (File Open Error) when I try to connect. Has > anyone come across this before ? The application works > fine if I just run it from the command line, but fails > every time from within the SP. > > Any clues. > > TIA. > > Ray. If it works from command line but not from a system call its has to be path/permissions or environment. Get the system command to display the environment and then check against the command environment. Are you running both as the same user? -- Paul Watson # WF Software Ltd # I don't suffer from stress - Tel: +44 1436 674729 # I'm a carrier. Fax: +44 1436 678693 # www.wfsoftware.co.uk #