I have a solution containing a web service project and a Stratframe Bo project. I am trying to query a SQL view and am getting the following error. This is the first time I have tried calling a Bo from a web service and also the first time I have tried to use View with a BO, any ideas on where to look first? thanks Paul

System.ArgumentException was unhandled by user code
  Message="Format of the initialization string does not conform to specification starting at index 0."
  Source="System.Data"
  StackTrace:
       at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue)
       at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
       at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
       at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
       at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
       at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
       at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value)
       at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
       at System.Data.SqlClient.SqlConnection..ctor(String connectionString)
       at MicroFour.StrataFrame.Data.SqlDataSourceItem.CreateBlankDbConnection()
       at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
       at MicroFour.StrataFrame.Data.SqlDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
       at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(String Statement, OnChangeEventHandler CallBack)
       at MicroFour.StrataFrame.Data.DataLayer.GetDataTable(String Statement, Boolean RegisterNotification)
       at MicroFour.StrataFrame.Business.BusinessLayer.FillDataTable(String SelectStatement)
       at BusinessObjectLibrary.BOOpenAR.FillByOfficeid(String Officeid) in C:\Dot Net Stuff\Action Labor Projects\GreatPlainsReporting\Busobject\BusinessObjectLibrary\BOOpenAR.vb:line 69
       at ActionLabor.main.CreateReport(Int32 index) in S:\_Projects in Development\Paul's Projects\GreatPlainsReporting\Main.aspx.vb:line 40
       at ActionLabor.main.ddlReport_SelectedIndexChanged(Object sender, EventArgs e) in S:\_Projects in Development\Paul's Projects\GreatPlainsReporting\Main.aspx.vb:line 54
       at System.Web.UI.WebControls.ListControl.OnSelectedIndexChanged(EventArgs e)
       at System.Web.UI.WebControls.DropDownList.RaisePostDataChangedEvent()
       at System.Web.UI.WebControls.DropDownList.System.Web.UI.IPostBackDataHandler.RaisePostDataChangedEvent()
       at System.Web.UI.Page.RaiseChangedEvents()
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

It's trying to create the connection object for the database query, and the SqlClientFactory object cannot parse the connection string... so, my guess is that the connection string is just not formatted correctly.  It hasn't reached the point of querying the database for the view, so that's not the problem... I would just check the connection string, first.

Thanks Ben,

I think I know what the issue is.

NP... don't forget if ever need to post a connection string to remove the user/password and host values