[Resolved]][02/03]Problem Retrieving a Connection String from App.Config

[vuyiswamb]

Hi all

i have the Following App.Config file in VB2003 and a Windows Application.

<?xml version="1.0" encoding="utf-8"?>
<configuration>
	<appSettings>
		<!--   User application and configured property settings go here.-->
		<!--   Example: <add key="settingName" value="settingValue"/> -->
		<add key="timer.Enabled" value="True" />
		<add key="timer.Interval" value="1000" />
		<connectionstring>
		<add name = "Tshwane_Train"
		ConnectionString = "login=sa;Password=tfjgssf;Database=Tshwane_Valuations_Train;
		Server=SGIICOR"/>
		</connectionstring>
		
		</appSettings>	
</configuration>

and am Accessing this Connction string from the Vb App, like this

Dim constr As String = Configuration.ConfigurationSettings.AppSettings("Tshwane_Train")

Wheni compile the Application, i get no Errors ,but but when i try to run the application, i mean the Part that will need to Connect to the Database i get the Following Error.

An unhandled exception of type 'System.Configuration.ConfigurationException' occurred in system.dll

Additional information: Unrecognized element

What is Wrong

[Hack]

Have you manually opened the file to ensure ("Tshwane_Train") really does exist?

[vuyiswamb]

yes ,

it shows in the App.Config File i have posted. am i missing Something? , If i write the name in the App.Config file do i have to write it somewhere else again.

Thanks

[riteshjain1982]

replace

<connectionstring>
		<add name = "Tshwane_Train"
		ConnectionString = "login=sa;Password=tfjgssf;Database=Tshwane_Valuations_Train;
		Server=SGIICOR"/>
		</connectionstring>

with

<add name = "Tshwane_Train"
		value= "login=sa;Password=tfjgssf;Database=Tshwane_Valuations_Train;
		Server=SGIICOR"/>

[vuyiswamb]

hi man

Thanks for your help, i have changed the App.Config file to the way you advised like and it looked like this

<configuration>
	<appSettings>
		<!--   User application and configured property settings go here.-->
		<!--   Example: &lt;add key="settingName" value="settingValue"/> -->
		<add key="timer.Enabled" value="True" />
		<add key="timer.Interval" value="1000" />
		<add name = "Tshwane_Train"
		Value= "login=sde;Password=topology;Database=Tshwane_Valuations_Train;
		Server=SGIICORNETGS01"/>
    </appSettings>	
</configuration>

and the Code in my VB is Still the Same

Dim constr As String = Configuration.ConfigurationSettings.AppSettings("Tshwane_Train")

and it Throws an Error that says

An unhandled exception of type 'System.Configuration.ConfigurationException' occurred in system.dll

Additional information: Required attribute 'key' not found

Thanks

[riteshjain1982]

remove additional space....

<add name = "Tshwane_Train"
		Value= "login=sde;Password=topology;Database=Tshwane_Valuations_Train;
		Server=SGIICORNETGS01"/>

should be

<add name="Tshwane_Train"
		value="login=sde;Password=topology;Database=Tshwane_Valuations_Train;
		Server=SGIICORNETGS01"/>

Edit :

<add key="Tshwane_Train"
		value="login=sde;Password=topology;Database=Tshwane_Valuations_Train;
		Server=SGIICORNETGS01"/>

[vuyiswamb]

hi, now my App.Config will look like this

<configuration>
	<appSettings>
		<!--   User application and configured property settings go here.-->
		<!--   Example: &lt;add key="settingName" value="settingValue"/> -->
		<add key="timer.Enabled" value="True" />
		<add key="timer.Interval" value="1000" />
		<add key="Tshwane_Train"
						Value="login=sde;Password=topology;Database=Tshwane_Valuations_Train;
						Server=SGIICORNETGS01"/>
    </appSettings>	
</configuration>

i have removed the Space as Advised and i have this Error

An unhandled exception of type 'System.Configuration.ConfigurationException' occurred in system.dll

Additional information: Required attribute 'key' not found

Thanks

[riteshjain1982]

Value should be

value

(small case)

[vuyiswamb]

Wow thanks man

We are Getting Somewhere now, why does it resfuse the login, Doesnt it treat it like a String, ok, after i fixed that m, i got the Following Error

Additional information: Keyword not supported: 'login'.

Thanks man you are a Star

[riteshjain1982]

change

login

to

user id or uid

it should work

"uid=sde;Password=topology;Database=Tshwane_Valuations_Train;Server=SGIICORNETGS01"

[vuyiswamb]

I would like to take this Chance to Thank you for your Patience and your help. I have Added a Reputation to your Answers. you are not just a Good Developer but a A Good Person. if you Continue with that attitude you will go places , mybe as am talking you are places , because people have seen what you got.

Thanks man

[riteshjain1982]

Glad that worked for you