Hello everyone!
Is there any easy way to get a list of all known Oracle-Aliases from tnsnames.ora
Either built in in ADO.NET, or from a 3rd party vendor
Please be kind with me, as I'm a total newbie to all this .NET stuff! :-)
TIA,
Holger
Oracle Alias-List from tnsnames.ora
Hot Topic
.NET Development
- Deleted row detached, but still in the DataTable
- Serializable Web service objects
- Dependency on Windows Installer 3.0 limits targets for .NET 2.0
- .NET Compact Framework Size Limitation
- Editor flags valid XSD as error?
- How to set a specific RUNTIME for a library?
- moving a sql default constraint to the datacolumn defaultvalue property
- How to marshal a .NET bool pointer into a C boolean pointer?
- SOAP Exceptions handling Question
- Javascript Single event two action
Oracle Alias-List from tnsnames.ora
Klaus.Lucas
Hi Holger, There is nothing in the ADO.Net Oracle Provider that will allow you to list aliases in TNSNames.ora file. I am not sure if there are other party vendors who do it.
You might be able to parse the file yourself though.
Hope that helps.
Hager Pascal
Well, I found a "OraDirect .NET Data Provider" here: http://crlab.com/oranet/
I'll have to check it out, but from the documentation it does what I want, and more, although for a price.
highflyingflor
Thanks for your answer, although that was not really the answer I hoped for...
Parsing is not the only problem though, first you have to find the right location of it, depending on the Oracler client version and IINM the selected Oracle home...
Is there any other way of accessing Oracle DBs other then ADO.Net Oracle Provider Solutions that include the Alias-Lists
TIA,
Holger