• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 854
  • Last Modified:

How do i resolve this error: ORA-00162 external dbid length, from my visual studio 2003 application?

Hello experts I am getting this error from my visual studio 2003 applicaiton: ORA-00162 external dbid length.  I am connecting to our databases from a global tns file.  The simple solution is to just change the tnsentry to a shorter name, but they are not willing to do that.  I found a site that explains I am using an older System.Data.OracleClient.dll assembly.  I have been looking for a new version that resolves this issue but I cannot find it.  Where can I find this version System.Data.Oracleclient 1.0.3300.0?  And can i use it with Microsoft Visual studio 2003?
0
tentavarious
Asked:
tentavarious
  • 4
  • 3
1 Solution
 
Sachintana DissanayakeSenior Web DeveloperCommented:
0
 
tentavariousAuthor Commented:
yeah, i found that after I posted this question.  I was able to resolve that issue by changing the length of the tns name.  The problem I have now is that my boss will not let me change the name.  All the names have to be the same I can't make a new entry for just my app so I need another work around, and i cant seem to find the download i need for the older OracleClient version
0
 
Sachintana DissanayakeSenior Web DeveloperCommented:
Try here to download oracle client that you need.
http://www.nodevice.com/dll/System_Data_OracleClient_dll/item16666.html
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
tentavariousAuthor Commented:
Yep found that link as well, it wants me to install a seperate application that runs a registry scan.  I really dont want to do that, plus since I am running a newer version of the oracleclient I dont think it will work, it should detect that I am running the correct version.
0
 
Sachintana DissanayakeSenior Web DeveloperCommented:
You can add this assembly as a dll reference to your project.
I do not think, you need to register it.
0
 
tentavariousAuthor Commented:
K, clicked the download version and it was the same 1 I already have.
0
 
tentavariousAuthor Commented:
Yeah, the download installs the version i already have, i cant find version 1.0.3300.0, which i believe was packaged with .net version 1.0.  I was thinking of just using odp.net but I cant find the install for that either.  This is becoming a pain.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now