I'm getting the error "5600: Error Creating UDF/XSP/UDM/UDT: no compiler available" in SQL Assistant when trying to create a UDF.
I've got Visual Studio 2005 installed on a Windows 2003 SP1 Server. I've set the environment variables for command line Visual C. I've successfully compiled a small c program via the command line. Any ideas why Teradata doesn't recognise the compiler? Does it only work with VS 2003?