I have a package that adds oracle odbc connections.
The odbc connections is added without any problems (through registry keys) but the dropdownlist TNS Service Name in the Oracle ODBC Driver Configuration only shows junk characters. It should be content from tnsnames.ora in that list.

We have tnsnames.ora centrally stored on a network location pointing to it through a registry key named TNS_ADMIN.

When doing a tnsping everything works fine, actually everything seems to be working.....applications runs fine.

The question is why there is junk characters in the system dsn? Where can the error be, in the oracle package, the package that adds odbc connection or something else with the system itself?

If tnsnames.ora is placed locally in the oracle installation folder the list is populated by the content of the file, but this is not a choice for us....we dont want this file to be stored locally.

Anyone who have had this problem?


ps. i dont know if this really is a relevant subject for this forum since i feel it might not have anything to do with the msi-files at all. But right now I just stuck.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
Hi Polka:

Have you tried this installation on any other machine besides the one that you are using? Correct me if I am wrong do you want to move tnsnames.ora to a network location or you dont want this during the setup? Because I had a similar situtation long back where my client asked me to move the file to a network location. So to overcome I developed a Wise Script, that used to call the oracle setup with customl.rsp file in a silent mode and in the end used to copy the tnsnames.ora file to the network location.

Please clarify...
Answered 02/27/2007 by: wiseapp
Second Degree Green Belt

Please log in to comment
Answer this question or Comment on this question for clarity