Admin Access to SQLConnection class

[marcmc]

Hey All,

When I log in as admin, i want to be able to set the database properties
(UserName, Password, Database & Server) to be passed to the
SQLClient.SqlConnection class. I have been working with defaults during
development. Now if admin logs in I want to allow them to change the settings
so as they are held from then onwards. This alllows me no not have to change
any code when distributing this App.

So I start with 4 text boxes on my 2nd(Main Form) form - because thewy would
just look out of place on the login or Form3.

I am hard coding these but it's not dynamic and nor practical.
So currantly I set up a Module called dbProps and give it the values from
Form2 TextBoxes mentioned above. This then allows the values to be passed
around the 3 screens.

I toyed with the idea of using a table to hold the connection data but
worked out that I wouldn't be able to connect to it without the values in
that table!! Can I use a trusted connection r something?

The final result is that I do not want "sa", "blank", "DbName" & "SrvName"
to be hard-coded within the app. How do I get around this problem.

[Ken Tucker [MVP]]

Hi,

http://msdn.microsoft.com/library/de...ingstorage.asp

Ken
--------------------------
"marcmc" <ma****@discussions.microsoft.com> wrote in message
news:77**********************************@microsof t.com...
Hey All,

When I log in as admin, i want to be able to set the database properties
(UserName, Password, Database & Server) to be passed to the
SQLClient.SqlConnection class. I have been working with defaults during
development. Now if admin logs in I want to allow them to change the
settings
so as they are held from then onwards. This alllows me no not have to change
any code when distributing this App.

So I start with 4 text boxes on my 2nd(Main Form) form - because thewy would
just look out of place on the login or Form3.

I am hard coding these but it's not dynamic and nor practical.
So currantly I set up a Module called dbProps and give it the values from
Form2 TextBoxes mentioned above. This then allows the values to be passed
around the 3 screens.

I toyed with the idea of using a table to hold the connection data but
worked out that I wouldn't be able to connect to it without the values in
that table!! Can I use a trusted connection r something?

The final result is that I do not want "sa", "blank", "DbName" & "SrvName"
to be hard-coded within the app. How do I get around this problem.

[marcmc]

thanks ken, i will use xml

"Ken Tucker [MVP]" wrote:

Hi,

http://msdn.microsoft.com/library/de...ingstorage.asp

Ken
--------------------------
"marcmc" <ma****@discussions.microsoft.com> wrote in message
news:77**********************************@microsof t.com...
Hey All,

When I log in as admin, i want to be able to set the database properties
(UserName, Password, Database & Server) to be passed to the
SQLClient.SqlConnection class. I have been working with defaults during
development. Now if admin logs in I want to allow them to change the
settings
so as they are held from then onwards. This alllows me no not have to change
any code when distributing this App.

So I start with 4 text boxes on my 2nd(Main Form) form - because thewy would
just look out of place on the login or Form3.

I am hard coding these but it's not dynamic and nor practical.
So currantly I set up a Module called dbProps and give it the values from
Form2 TextBoxes mentioned above. This then allows the values to be passed
around the 3 screens.

I toyed with the idea of using a table to hold the connection data but
worked out that I wouldn't be able to connect to it without the values in
that table!! Can I use a trusted connection r something?

The final result is that I do not want "sa", "blank", "DbName" & "SrvName"
to be hard-coded within the app. How do I get around this problem.