Bus Object Error With SQL View

Paul Chase — Thu, 24 Aug 2006 16:23:23 GMT

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)

RE: Bus Object Error With SQL View

StrataFrame Team — Thu, 24 Aug 2006 16:23:23 GMT

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

RE: Bus Object Error With SQL View

Paul Chase — Thu, 24 Aug 2006 16:22:27 GMT

Thanks Ben,

I think I know what the issue is.

RE: Bus Object Error With SQL View

StrataFrame Team — Thu, 24 Aug 2006 16:14:32 GMT

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.

StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Bus Object Error With SQL View

Bus Object Error With SQL View

RE: Bus Object Error With SQL View

RE: Bus Object Error With SQL View

RE: Bus Object Error With SQL View