We need to access a Business Objects/Crystal Enterprise Server from our Web application, and are storing connection information in our webconfig file. Rather than several different settings in Web.Config, I created a New Connection string property using standard the standard SQL Server connection string syntax, and used SQLConnectionStringBuild to parse the Crystal connection string. When the username/password is first needed, Initialize is called, and the connection sting is pulled from the config file:
Public Sub Initialize()
Dim CeConnectionString As String
CeConnectionString = ConfigurationManager.ConnectionStrings("CE").ConnectionString Dim connBuilder As New SqlConnectionStringBuilder(g_ceConnString)
g_strDataSource = connBuilder.DataSource
g_ceUsername = connBuilder.UserID
g_cePassword = connBuilder.Password
End Sub