Installed the corresponding (32 or 64 bit) Oracle ODP .NET (ODAC) 220.127.116.11 for WindowsI have downloaded ODAC112012,if i tried to install the components i am getting the below error
You do* have TNS_ADMIN environment variable set and that it _points to the directory that contains your TNSNAMES.ORA file_Where i can see this TNS_ADMIN environment variable set.
933663 wrote:What exact install command did you use? Did the target directory already exist? Were any errors reported?
I downloaded Xcopy and installed but there are no component being installed.
I'm having Oracle TNSNAMES.ORA and TimesTen's TNSNAMES.ORA where do i modify here in Oracle ORA file or in TimesTen ORA file.The TimesTen one. You do not need to have separate TNSNAMES.ORA files as long as you use different TNS names for Oracle and TimesTen connections.
You can view environment variables from a command prompt by using the SET command. Environment variables can also be set using the SET command or from Advanced System Settings (right click on My Computer, choose Properties then Advanced System Settings). Variables set from a command prompt affect only things launched from that command prompt. Variables set at the system or user level affect everything on the system or everything for that user.You do* have TNS_ADMIN environment variable set and that it _points to the directory that contains your TNSNAMES.ORA file_Where i can see this TNS_ADMIN environment variable set.
1. Does your code do any other database operations other than execute inserts?I have individual .CS file for each operation once i finish my Insert i will do other operations it may be Select/Update/Delete it is all having in different .CS files
2. Is there any other concurrent activity on the TimsTen database while your test is running?As of now there is no concurrent activity while i run my test.
3. Why are you still preparing the INSERT statement inside the loop? Does the problem disappear of you move the prepare to outside the loop (like it should be)?As i was trying in different way one of the way of my code is like that we can have even outside no problem
4. The 'Command' object that you are using must have been 'created' from some kind of connection object. How exactly does your code do that? What is the scope of the connection object?It must remain in scope and not get closed/garbage collected while the Command objects are still needed.