• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 873
  • 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
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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