Did you install the TT software properly on this machine (by using the installer script) or just copy it from another machine?
Is the environment under which the Perl script is running properly setup (by way of <tt_install_dir>/bin/ttenv.sh or similar)?
Does ttIsqlCS work okay and is it able to connect to the same DSN when run under the same environment?
Steps I performed:
1. Installed TT11.2 using setup script onto server51
2. Tarred up the installed directories and untarred the directories onto a development server.
3. Remove TT package from server51
3. Create a software package (tarball) containing both TT files and our application files.
4. Install our tarball back onto server51 from step one.
ttIsqlCS works in the same environment. I even added the environment variables created from ttenv.sh into the perl script itself without any luck.
That is not supported and there are many possibilities for things to go wrong (as you have found). Please re-install TimesTen properly and see if that resolves your problem. If you wish to 'embed' TimesTen with your application then you must deliver the full TimesTen installable package and run the official installer in 'silent' mode (see the Installation Guide for details on hwo to do that). Simply tarring/copying/untarring is not sufficient and will lead to problems in many cases.
This already worked correctly in the past. But I also realize the installation for 11.2 is more involved than TT6.0 and earlier. I'll re-install TT11.2 using the supported method and see what happens.
okay, its CPAN modules working now. The problem was an environment variable was getting changed within a script. Thanks for your responses Chris.
Glad it is working now. I would like to emphasise that the method you are using to clone installations is not supported and will cause problems under some circumstances. I would strongly encourage you to adopt a supported method for silent installation. If you log an SR you will anyway be asked to reproduce the problem using a supported installation method so it is in your interests to do things properly.