FYI, i am using Visual Web Developer Express 2008, and there was SQL Server 2008 included with the install.
BigJ wrote: > I'm having a problem establihing my SqlDataSource connection. Note, > my .mdf file is in the app_Data directory. My original aspx looks as > is: > > <div class="floater"> > <h3>CheckBoxList</h3> > <asp:CheckBoxList > id="CheckBoxList1" > DataSourceId="srcMovies" > DataTextField="Title" > Runat="server" /> > </div> > > <asp:SqlDataSource > id="srcMovies" > ConnectionString="Data Source=.\SQLEXPRESS; > AttachDbFilename=|DataDirectory|MyDatabase.mdf; > Integrated Security=True;User Instance=True" > SelectCommand="SELECT Title FROM Movies" > Runat="server" /> > > > I tried changing the sqlDataSource control to the following: > > <asp:SqlDataSource > id="srcMovies" > ConnectionString="Data Source=.\SQLEXPRESS; > AttachDbFilename=C:\Documents and Settings\Jon\My Documents > \Visual Studio 2008\WebSites\Chapter3\App_Data\MyDatabase.mdf; > Integrated Security=True;User Instance=True" > SelectCommand="SELECT Title FROM Movies" > Runat="server" /> > > However, I'm consistently getting this error...: > > Server Error in '/Chapter3' Application. > A network-related or instance-specific error occurred while > establishing a connection to SQL Server. The server was not found or > was not accessible. Verify that the instance name is correct and that > SQL Server is configured to allow remote connections. (provider: SQL > Network Interfaces, error: 26 - Error Locating Server/Instance > Specified) > Description: An unhandled exception occurred during the execution of > the current web request. Please review the stack trace for more > information about the error and where it originated in the code. > > Exception Details: System.Data.SqlClient.SqlException: A network- > related or instance-specific error occurred while establishing a > connection to SQL Server. The server was not found or was not > accessible. Verify that the instance name is correct and that SQL > Server is configured to allow remote connections. (provider: SQL > Network Interfaces, error: 26 - Error Locating Server/Instance > Specified) > > Source Error: > > An unhandled exception was generated during the execution of the > current web request. Information regarding the origin and location of > the exception can be identified using the exception stack trace below. > > Stack Trace: > > [SqlException (0x80131904): A network-related or instance-specific > error occurred while establishing a connection to SQL Server. The > server was not found or was not accessible. Verify that the instance > name is correct and that SQL Server is configured to allow remote > connections. (provider: SQL Network Interfaces, error: 26 - Error > Locating Server/Instance Specified)] > System.Data.SqlClient.SqlInternalConnection.OnError(SqlException > exception, Boolean breakConnection) +4844759 > > System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject > stateObj) +194 > System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, > SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, > Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean > integratedSecurity, SqlConnection owningObject) +4858065 > > System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo > serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 > timerExpire, SqlConnection owningObject) +90 > > System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String > host, String newPassword, Boolean redirectedUserInstance, > SqlConnection owningObject, SqlConnectionString connectionOptions, > Int64 timerStart) +376 > > System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection > owningObject, SqlConnectionString connectionOptions, String > newPassword, Boolean redirectedUserInstance) +221 > > System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity > identity, SqlConnectionString connectionOptions, Object providerInfo, > String newPassword, SqlConnection owningObject, Boolean > redirectedUserInstance) +189 > > System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions > options, Object poolGroupProviderInfo, DbConnectionPool pool, > DbConnection owningConnection) +4859187 > > System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection > owningConnection, DbConnectionPool pool, DbConnectionOptions options) > +31 > System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection > owningObject) +433 > > System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection > owningObject) +66 > > System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection > owningObject) +499 > > System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection > owningConnection) +65 > > System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection > outerConnection, DbConnectionFactory connectionFactory) +117 > System.Data.SqlClient.SqlConnection.Open() +122 > System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection > connection, ConnectionState& originalState) +31 > System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, > DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String > srcTable, IDbCommand command, CommandBehavior behavior) +112 > System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 > startRecord, Int32 maxRecords, String srcTable, IDbCommand command, > CommandBehavior behavior) +287 > System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String > srcTable) +92 > > System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments > arguments) +1297 > System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) > +95 > System.Web.UI.WebControls.ListControl.PerformSelect() +34 > System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73 > System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() > +82 > > System.Web.UI.WebControls.BaseDataBoundControl.OnPreRender(EventArgs > e) +22 > System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +18 > System.Web.UI.WebControls.CheckBoxList.OnPreRender(EventArgs e) +20 > System.Web.UI.Control.PreRenderRecursiveInternal() +80 > System.Web.UI.Control.PreRenderRecursiveInternal() +171 > System.Web.UI.Control.PreRenderRecursiveInternal() +171 > System.Web.UI.Page.ProcessRequestMain(Boolean > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) > +8 > > > > I was able to get the connection to work before, but then I tried > updating something my SQL settings. Anyhow I must have broke > something so i uninstalled and reinstalled everything, and so far it > has not been working for me. Any suggestions? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/DotNetDevelopment You may subscribe to group Feeds using a RSS Feed Reader to stay upto date using following url <a href="http://feeds.feedburner.com/DotNetDevelopment";> http://feeds.feedburner.com/DotNetDevelopment</a> -~----------~----~----~----~------~----~------~--~---
