Oracle connection works in VB debug mode but not in EXE
479179Dec 27 2005 — edited Nov 25 2006I have a small VB 6 app that writes to an oracle database on a unix server. Oracle 10g is installed on my pc. System DSN is set up in ODBC and corresponds to an entry in the tnsnames.ora file (to the best of my limited oracle knowledge..)
The connection to the database works fine in debug bug. Test Connection of that DSN works as well. But when I build and execute the EXE file it returns : "TNS:could not resolve the connect identifier specified"
What is different about the process of running an EXE that could cause this failure?