I am currently trying to find the cause of an error in some code that I did not write. This code was developed as a way to run an Oracle DB lookup to simplify data entry into a Kofax Ascent Capture system. I am not a coder myself so I am struggling to find the real issue. They have a working system on Windows XP that uses this same dll, and they have recently upgraded some workstations to Windows 7 64-bit. They have installed the 32-bit Oracle client, and named the DSN the same name as it was in XP. A dll for the lookup gets registered on the system called "FieldLookup", and I have some error catching set up in the validation script to tell me on what line the error happens. The error is specified on line 368, and when I go to this line I see this: "oFieldLookup.Init"
There are two errors that are accompanied that say "ERROR [Oracle][Ora]ORA-12
154: TNS: could not resolve the connect identifier specified
Error [IM006][Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed"
I have opened the dll in Visual Studio, and I can see the Init in the FieldLookup.dll, but I don't know how to open this to see what it does to figure out if there is something in it that is configured incorrectly or what.
I am referencing this article because it seems like it could be the solution. I believe that I found the Oracle home directory, but the tnsnames.ora file and the others that that the article speaks of is not in it. Could that be the whole problem? I just don't know enough about Oracle to know if that is what I need to resolve this error.
Any help is appreciated.