|
| | | 
StrataFrame User
 
Group: StrataFrame Users
Last Login: Yesterday @ 4:29:41 PM
Posts: 367, Visits: 2,446 |
| | 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)
|
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: 12/02/2008 4:42:46 PM
Posts: 2,686, Visits: 1,890 |
| 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.
www.bungie.net |
| |
| | |
StrataFrame User
Group: StrataFrame Users
Last Login: Yesterday @ 4:29:41 PM
Posts: 367, Visits: 2,446 |
| | Thanks Ben, I think I know what the issue is. |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: 12/02/2008 4:42:46 PM
Posts: 2,686, Visits: 1,890 |
| NP... don't forget if ever need to post a connection string to remove the user/password and host values 
www.bungie.net |
| |
|
|