StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Retrieve Server and Database and Login information

Retrieve Server and Database and Login information

Michael Reese — Wed, 28 Nov 2007 12:11:52 GMT

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

RE: Retrieve Server and Database and Login information

Trent L. Taylor — Wed, 28 Nov 2007 12:11:52 GMT

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:

[codesnippet]

Dim connInfo As New SqlClient.SqlConnectionStringBuilder(DataBasics.DataSources(0).ConnectionString)
Dim msg As String = ""

msg &= connInfo.DataSource & ControlChars.CrLf
msg &= connInfo.InitialCatalog & ControlChars.CrLf
msg &= connInfo.UserID & ControlChars.CrLf
msg &= connInfo.Password & ControlChars.CrLf
msg &= connInfo.IntegratedSecurity.ToString()
MsgBox(msg)[/codesnippet]

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

RE: Retrieve Server and Database and Login information

Michael Reese — Wed, 28 Nov 2007 09:18:15 GMT

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

Thanks much!

RE: Retrieve Server and Database and Login information

Greg McGuffey — Tue, 27 Nov 2007 23:52:51 GMT

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! :D