That is what I tried first but had same issues. Then read in the documentation that for ado.net .net provider , times ten needs to use a different version of OCI then why ships with the times ten distribution eg see following . Thanks for help
ODP.NET support for TimesTen depends on Oracle Call Interface (OCI) support for TimesTen. Specifically, an OCI version included with Oracle Database 11.2 releases is required. The current ODP.NET release must not, and will not, use the OCI version included with TimesTen, which is under the tt_install_dir\ttoracle_home directory, where tt_install_dir is the TimesTen installation root directory. (There is no issue, however, in using the TimesTen version of OCI for OCI or Pro*C/C++ programs that do not use ODP.NET. Refer to "TimesTen Support for Oracle Call Interface" and "TimesTen Support for Oracle Pro*C/C++ Precompiler" in Oracle TimesTen In-Memory Database C Developer's Guide for information on those programming interfaces.
Documentation says that ODP.NET uses personal libraries (OCI for instance), but in some cases you can configure ODP for using TimesTen libraries (see ID 1479921.1 for example).
Regarding your question, could you please check the TNS_ADMIN variable in your environment.
Additionally, could you please post the steps you've done.