I will be using VB.NET and I am not sure how I should setup the environment.
Say I have this in my app.config file.
<add key="EMMainDBConn" value="Data Source=ORACLEDBA; Initial Catalog=EMREPORTING; user id = User; password=Password;"></add>
Now if this was an sql datasource it would go like so?
''create a connection to the financial solutions database if needed
'''' Me.Text = clsRunParms.FullNamefromNetwork()
If _cnnFinSol Is Nothing Then
_cnnFinSol = New System.Data.SqlClient.SqlConnection
_cnnFinSol.ConnectionString = clsRunParms.FinSolMainDBConnString
What type of connection do I use and how do I use it?
I will have to interface with oracle on a linux server. I will need some code to practice with.