Below are the code for read tnsname.ora file(tns name) in vb.net. Through below functions you can get the information of the tns.
//Declare namespace
Imports System
Imports System.Collections.Generic
Imports System.Text.RegularExpressions
Imports System.IO
Public Class ReadTNS
//Function for Load TNS Name
Public Function LoadTNSNames() As List(Of String)
Dim DBNamesCollection As New List(Of String)()
Dim regPattern As String = "[\n][\s]*[^\(][a-zA-Z0-9_.]+[\s]*"
Dim tnsNamesOraFilePath As String = GetPathToTNSNamesFile()
If Not tnsNamesOraFilePath.Equals("") Then
' Verify file exists
Dim tnsNamesOraFile As New FileInfo(tnsNamesOraFilePath)
If tnsNamesOraFile.Exists Then
If tnsNamesOraFile.Length > 0 Then
'read tnsnames.ora file
Dim tnsNamesContents As String = File.ReadAllText(tnsNamesOraFile.FullName)
Dim numMatches As Integer = Regex.Matches(tnsNamesContents, regPattern).Count
Dim col As MatchCollection = Regex.Matches(tnsNamesContents, regPattern)
For Each match As Match In col
Dim m As String = match.ToString()
m = m.Trim()
DBNamesCollection.Add(m.ToUpper())
Next
End If
End If
End If
Return DBNamesCollection
End Function
//Function for Get path of TNS File
Private Shared Function GetPathToTNSNamesFile() As String
Dim systemPath As String = Environment.GetEnvironmentVariable("Path")
Dim reg As New Regex("[a-zA-Z]:\\[a-zA-Z0-9\\]*(oracle|app)[a-zA-Z0-9_.\\]*(?=bin)")
Dim col As MatchCollection = reg.Matches(systemPath)
Dim subpath As String = "network\ADMIN\tnsnames.ora"
For Each match As Match In col
Dim path As String = match.ToString() & subpath
If File.Exists(path) Then
Return path
End If
Next
Return String.Empty
End Function
End Class
thank you!
ReplyDeleteMost welcome.
DeleteBig data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. big data projects for students But it’s not the amount of data that’s important.Project Center in Chennai
DeleteSpring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Corporate TRaining Spring Framework the authors explore the idea of using Java in Big Data platforms.
Spring Training in Chennai
The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training
You are the best. Thanks a lot.
ReplyDeleteMost welcome, can i do any help to you.
DeleteHi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a .Net developer learn from Dot Net Training in Chennai. or learn thru Dot Net Training in Chennai. Nowadays Dot Net has tons of job opportunities on various vertical industry.
ReplyDeleteor Javascript Training in Chennai. Nowadays JavaScript has tons of job opportunities on various vertical industry.
Thanks a lot very much for the high quality and results-oriented help. I won’t think twice to endorse your blog post to anybody who wants and needs support about this area.
ReplyDeletejava training in bangalore
java training in bangalore
Only here are good game slots the casino best Come to us and get your winnings.
ReplyDeleteQuite interesting to read ur blog.Thats good to learn new concept.Thanks to share.
ReplyDeleteapple mobile service centre in chennai
iphone service centre chennai
apple service center near me
lenovo service center in chennai
lenovo mobile service center in chennai
Oh, that's Great Post Thanks for sharing with us.
ReplyDeleteThis Big Data Hadoop Training in Pune Platform helped me to learn advanced concepts of all the trending technologies out there in the current IT market. really worth trying them.
ReplyDeletePretty blog, so many ideas in a single site, thanks for the informative article, keep updating more article.
Digital Marketing Training in Chennai
Digital Marketing Training in Chennai
Digital Marketing Training in Bangalore
Digital Marketing Training in Coimbatore
Content Writing Company in Delhi
ReplyDeleteContent Writing Services in Delhi
Mobile App Development Company Delhi
PPC Company in Delhi
PPC Company in India
ReplyDeleteTop engineering colleges in India
Nice infromation
ReplyDeleteSelenium Training In Chennai
Selenium course in chennai
Selenium Training
Selenium Training institute In Chennai
Best Selenium Training in chennai
Selenium Training In Chennai
Rpa Training in Chennai
ReplyDeleteRpa Course in Chennai
Rpa training institute in Chennai
Best Rpa Course in Chennai
uipath Training in Chennai
Blue prism training in Chennai
Data Science Training In Chennai
Data Science Course In Chennai
Data Science Training institute In Chennai
Best Data Science Training In Chennai
Python Training In Chennai
ReplyDeletePython course In Chennai
Protractor Training in Chennai
jmeter training in chennai
Loadrunner training in chennai
Brilliant article. The information I have been searching precisely. It helped me a lot, thanks. Keep coming with more such informative article. Would love to follow them.
ReplyDeleteDigital Marketing Training Course in Chennai | Digital Marketing Training Course in Anna Nagar | Digital Marketing Training Course in OMR | Digital Marketing Training Course in Porur | Digital Marketing Training Course in Tambaram | Digital Marketing Training Course in Velachery
Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.
ReplyDeleteAngular JS Training in Chennai | Certification | Online Training Course | Angular JS Training in Bangalore | Certification | Online Training Course | Angular JS Training in Hyderabad | Certification | Online Training Course | Angular JS Training in Coimbatore | Certification | Online Training Course | Angular JS Training | Certification | Angular JS Online Training Course
Interesting blog which attracted me more.Spend a worthful time.keep updating more.
ReplyDeleteangular js training in chennai
angular js training in tambaram
full stack training in chennai
full stack training in tambaram
php training in chennai
php training in tambaram
photoshop training in chennai
photoshop training in tambaram
I am glad it is helpful. Hopefully I will be able to release a newer version this month with some updates and improvements.
ReplyDeleteoracle training in chennai
oracle training in velachery
oracle dba training in chennai
oracle dba training in velachery
ccna training in chennai
ccna training in velachery
seo training in chennai
seo training in velachery
Usually I never comment on blogs but your article is so convincing that I never stop myself to say something about it. You’re doing a great job Man, Keep it up.
ReplyDeleteangular js training in chennai
angular js training in annanagar
full stack training in chennai
full stack training in annanagar
php training in chennai
php training in annanagar
photoshop training in chennai
photoshop training in annanagar
Brilliant article. The information I have been searching precisely. It helped me a lot, thanks. Keep coming with more such informative article. Would love to follow them...
ReplyDeletehardware and networking training in chennai
hardware and networking training in omr
xamarin training in chennai
xamarin training in omr
ios training in chennai
ios training in omr
iot training in chennai
iot training in omr
Excellent post, From this post i got more detailed information,
ReplyDeleteThanks to share with us,
web designing training in chennai
web designing training in porur
digital marketing training in chennai
digital marketing training in porur
rpa training in chennai
rpa training in porur
tally training in chennai
tally training in porur