This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Testing connection to Oracle
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 16, 2008
02:20 PM
Testing connection to Oracle
Hi!
I made a .net assembly that I call from my Installscript project. It is supposed to try to connect to an Oracle and SQL Server databases with the user-provided parameters.
With SQL Server, all is fine. However, for Oracle, I get a "TNS: could not resolve service name" error.
I checked my TNSNames.ora file and the server i'm trying to connect to is there.
I tried my connection string with SQLPlus and it worked.
I also called the same .net assembly with a test .net application and all is fine there too.
The .net assembly is OK since i'm able to connect with an SQL Server database through it from InstallShield.
What could be the problem?
Thanks!
I made a .net assembly that I call from my Installscript project. It is supposed to try to connect to an Oracle and SQL Server databases with the user-provided parameters.
With SQL Server, all is fine. However, for Oracle, I get a "TNS: could not resolve service name" error.
I checked my TNSNames.ora file and the server i'm trying to connect to is there.
I tried my connection string with SQLPlus and it worked.
I also called the same .net assembly with a test .net application and all is fine there too.
The .net assembly is OK since i'm able to connect with an SQL Server database through it from InstallShield.
What could be the problem?
Thanks!
(4) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 16, 2008
04:14 PM
Do you have Oralce Client software installed on your machine? If not, you can get Oracle 10g Instant Client from http://www.oracle.com/technology/tech/oci/instantclient/index.html.
Hope that helps.
Hope that helps.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 16, 2008
06:00 PM
Yes, I have the standard Oracle client installed, not the Instant Client. If I hadn't my .net test app wouldn't work either.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 17, 2008
10:37 AM
Any idea? :confused:
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 17, 2008
12:15 PM
If you are using an Oracle 10g Client software, try an URL string in the format of "//host: [port] [/service name]" instead of a TNS name, and see if it works. The following is an example of what you would type to connect to a specified remote oracle machine:
//sch01jsmithrxp.macrovision.com:1521/ORCL
//sch01jsmithrxp.macrovision.com:1521/ORCL