Actually there is an easier way if you do not want to parse it yourself.  You can pass the connection string into the SqlConnectionStringBuilder class and it will parse the string for you into properties:

Greg's solution is always a good workaround though if this doesn't give you what you need.

Yeah, I was hoping that I would not have to go that route!

Thanks much!

The connection string is usually a set of key=value pairs, delimited by semi-colons. So, a bit of string manipulation will get you there. Just use the Split function on semi-colons first, then split on each pair on using '='. Either just test each as you go or you could add them to a dictionary, so you could then just access each value by its key.



Hope that makes sense!

I can get the connectioninfo from;

MicroFour.StrataFrame.Data.DataLayer.DataSources.Item(0).ConnectionString.ToString

However, I How can I separedly retrieve the following from my SF project?

Server Name

Database Name

Server Login

Thanks