I have problems to compile any sp with Teradata 13 Express and VS Express 2008 sp1. Compilation of a trivial procedure
Replace procedure RETAIL.sp_T() begin declare job char(12); end;
fails with *** Failure 5547 Internal Error: Can not find mt.exe
The routine exists in Windows SDK, that is installed with VS Express. Adding the directory to the path variable does not help.
When I use diagnostic spldebug on for session, I can find, beside souce c code, other 5 files in the directory C:\ProgramData\Teradata\Tdat\tdconfig\TDSPTemp with following suffixes .clist, .mds, .olist, .req, .uni. No object file was created.
The problem is the same for both Win 7 RC and Win XP sp3.
I am afraid this is DR 135079 which may not have a 13.0 fix yet. I have made an inquiry about it. "Because of having semicolon in middle, it is not finding mt.exe file." Could be a VS2005 issue only, not sure at this time.
Thank you for the reply. It would be nice to know which Ms VS / VC++ /Windows sdk work beside old VC++6 whis has compatibility problems on Windows 7. Will Teradata intend to ocasionally update the Express editions? Express 12 seems to have the same version that was published about a year ago.
Before I took on my current role in China, I used to manage Teradata database porting programs on the Windows platform and the MS compiler question is one that I get from time to time. Generally speaking, Teradata database supports every MS compiler out there and we put people's time to make sure that our database work with both paid and free versions. Paid versions include every version of MS Visual Studio. Free versions include MS Visual Studio Express (32-bit windows) and MS Windows SDK that includes a free compiler. In the recent versions of Windows SDK, there seems to be several issues with MS either not including key compiler executables in their SDK installer or including older versions of the compiler executables. If you run into these issues, you can copy over the correct executable from the paid versions of MS visual studio. The compilers for both paid and free versions are essentially the same.