web.config

kobra007 · Jan 18, 2009

I'm trying to connect my database with Visual Developer 2008 Express Edition but it doesn't work.
my web.config connection sting was:

<add name="InfoConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\InfoDatabase.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />

and now I did it like this:

<add name="InfoConnectionString" connectionString="Data Source=tcp:sql2k801.discountasp.net;Initial Catalog=SQL2008_586730_aspdb;User ID=SQL2008_586730_aspdb_user;Password=password;" providerName="System.Data.SqlClient" /> What's the problem??

Bruce · Jan 19, 2009

what is the error?

Bruce

DiscountASP.NET
www.DiscountASP.NET

kobra007 · Jan 19, 2009

the error is:

System.Data.SqlClient.SqlException was unhandled by user code
Message="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: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)"
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060
Class=20
LineNumber=0
Number=10060
Server=""
State=0
StackTrace:
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments)
at System.Web.UI.WebControls.SqlDataSource.Select(DataSourceSelectArguments arguments)
at _ClientPage.questionsList_SelectedIndexChanged(Object sender, EventArgs e) in c:\Users\Servsmart\Documents\livemall-lb\ClientPage.master.cs:line 574
at _ClientPage.Help_Load(Object sender, EventArgs e) in c:\Users\Servsmart\Documents\livemall-lb\ClientPage.master.cs:line 341
at _ClientPage.Page_Load(Object sender, EventArgs e) in c:\Users\Servsmart\Documents\livemall-lb\ClientPage.master.cs:line 331
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
InnerException:

Bruce · Jan 20, 2009

i assumed you are getting this error on your home computer. I would check to make sure that your network or ISP allows port 1433 to go through.

Bruce

DiscountASP.NET
www.DiscountASP.NET

wisemx · Jan 21, 2009

Hi,
Looks like you need someone to look over your sites code.
This is going to be difficult to help you post after post but I'm guessing it's a code page data conn.
Salute,
Mark

Technical Evangelist for DiscountASP.NET

Find ASP.NET code samples with my Dev Coop search tools below.
Google
Microsoft

DiscountASP.NET Technical Webcasts:
http://www.iis7test.com/webcasts/

My Microsoft Technical Blogs
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

kobra007 · Jan 21, 2009

you can check the error go to http://www.livemall-lb.com/LiveMall.aspx

kobra007 · Jan 23, 2009

well can u give me a code to get something from a connection please.

wisemx · Jan 24, 2009

...Sure, an entire web.config? If so, version 2 or 3.5? (IIS6/IIS7)
Please be specific.
Salute,
Mark

Technical Evangelist for DiscountASP.NET

Find ASP.NET code samples with my Dev Coop search tools below.
Google
Microsoft

DiscountASP.NET Technical Webcasts:
http://www.iis7test.com/webcasts/

My Microsoft Technical Blogs
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

wisemx · Jan 26, 2009

Hi,
I'm not an employee of DASP and do not have access to your site code but here is an updated IIS7 web.config with SMTP and example SQL settings:

<configuration>
<configSections>
<sectionGroupname='system.web.extensions'type='System.Web.Configuration.SystemWebExtensionsSectionGroup,System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'>
<sectionGroupname='scripting'type='System.Web.Configuration.ScriptingSectionGroup,System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'>
<sectionname='scriptResourceHandler'type='System.Web.Configuration.ScriptingScriptResourceHandlerSection,System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'requirePermission='false'allowDefinition='MachineToApplication'/>
<sectionGroupname='webServices'type='System.Web.Configuration.ScriptingWebServicesSectionGroup,System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'>
<sectionname='jsonSerialization'type='System.Web.Configuration.ScriptingJsonSerializationSection,System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'requirePermission='false'allowDefinition='Everywhere'/>
<sectionname='profileService'type='System.Web.Configuration.ScriptingProfileServiceSection,System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'requirePermission='false'allowDefinition='MachineToApplication'/>
<sectionname='authenticationService'type='System.Web.Configuration.ScriptingAuthenticationServiceSection,System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'requirePermission='false'allowDefinition='MachineToApplication'/>
<sectionname='roleService'type='System.Web.Configuration.ScriptingRoleServiceSection,System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'requirePermission='false'allowDefinition='MachineToApplication'/>
</sectionGroup>
</sectionGroup>
</sectionGroup>
</configSections>
<system.net>
<mailSettings>
<smtp>
<networkhost='localhost'port='25'/>
</smtp>
</mailSettings>
</system.net>
<system.web.extensions>
<scripting>
<webServices>
<authenticationServiceenabled='true'requireSSL='false'/>
<profileServiceenabled='true'/>
<roleServiceenabled='true'/>
</webServices>
<scriptResourceHandlerenableCompression='true'enableCaching='true'/>
</scripting>
</system.web.extensions>
<appSettings/>
<connectionStrings>
<clear/>
<removename='LocalSqlServer'/>
<addname='LocalSqlServer'connectionString='DataSource=tcp:sql.discountasp.net;InitialCatalog=SQL_user;UserID=SQL_user;Password=password'providerName='System.Data.SqlClient'/>
<removename='userConnString'/>
<addname='userConnString'connectionString='DataSource=tcp:sql.discountasp.net;InitialCatalog=SQL_user;UserID=SQL_user;Password=password'providerName='System.Data.SqlClient'/>
</connectionStrings>
<system.web>
<anonymousIdentificationenabled='true'/>
<authenticationmode='None'/>
<pagestheme='main01'compilationMode='Auto'maintainScrollPositionOnPostBack='true'enableSessionState='ReadOnly'enableViewStateMac='false'enableEventValidation='false'>
<controls>
<addtagPrefix='asp'namespace='System.Web.UI'assembly='System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'/>
<addtagPrefix='asp'namespace='System.Web.UI.WebControls'assembly='System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'/>
</controls>
</pages>
<compilationdebug='false'>
<assemblies>
<addassembly='System.Core,Version=3.5.0.0,Culture=neutral,PublicKeyToken=B77A5C561934E089'/>
<addassembly='System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'/>
<addassembly='System.Data.DataSetExtensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=B77A5C561934E089'/>
<addassembly='System.Xml.Linq,Version=3.5.0.0,Culture=neutral,PublicKeyToken=B77A5C561934E089'/>
<addassembly='System.Web.DynamicData,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'/>
<addassembly='System.Web.Routing,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'/>
<addassembly='System.Web.Abstractions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'/>
<addassembly='System.ComponentModel.DataAnnotations,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'/>
<addassembly='System.Data.Linq,Version=3.5.0.0,Culture=neutral,PublicKeyToken=B77A5C561934E089'/>
<addassembly='System.Data.Entity,Version=3.5.0.0,Culture=neutral,PublicKeyToken=B77A5C561934E089'/></assemblies>
</compilation>
<siteMapenabled='true'>
<providers>
<clear/>
<addsiteMapFile='Web.sitemap'name='AspNetXmlSiteMapProvider'type='System.Web.XmlSiteMapProvider'securityTrimmingEnabled='false'/>
</providers>
</siteMap>
<httpHandlers>
<removeverb='*'path='*.asmx'/>
<addverb='*'path='*.asmx'validate='false'type='System.Web.Script.Services.ScriptHandlerFactory,System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'/>
<addverb='*'path='*_AppService.axd'validate='false'type='System.Web.Script.Services.ScriptHandlerFactory,System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'/>
<addverb='GET,HEAD'path='ScriptResource.axd'type='System.Web.Handlers.ScriptResourceHandler,System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'validate='false'/>
</httpHandlers>
<httpModules>
<addname='ScriptModule'type='System.Web.Handlers.ScriptModule,System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'/>
</httpModules>
</system.web>
<system.codedom>
<compilers>
<compilerlanguage='c#;cs;csharp'extension='.cs'warningLevel='4'type='Microsoft.CSharp.CSharpCodeProvider,System,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b77a5c561934e089'>
<providerOptionname='CompilerVersion'value='v3.5'/>
<providerOptionname='WarnAsError'value='false'/>
</compiler>
<compilerlanguage='vb;vbs;visualbasic;vbscript'extension='.vb'warningLevel='4'type='Microsoft.VisualBasic.VBCodeProvider,System,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b77a5c561934e089'>
<providerOptionname='CompilerVersion'value='v3.5'/>
<providerOptionname='OptionInfer'value='true'/>
<providerOptionname='WarnAsError'value='false'/>
</compiler>
</compilers>
</system.codedom>
<system.webServer>
<validationvalidateIntegratedModeConfiguration='false'/>
<modules>
<removename='ScriptModule'/>
<addname='ScriptModule'preCondition='managedHandler'type='System.Web.Handlers.ScriptModule,System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'/>
</modules>
<handlers>
<removename='WebServiceHandlerFactory-Integrated'/>
<removename='ScriptHandlerFactory'/>
<removename='ScriptHandlerFactoryAppServices'/>
<removename='ScriptResource'/>
<addname='Reserved-ReportViewerWebControl-axd'path='Reserved.ReportViewerWebControl.axd'verb='*'type='Microsoft.Reporting.WebForms.HttpHandler'resourceType='Unspecified'preCondition='integratedMode'/>
<addname='ScriptHandlerFactory'verb='*'path='*.asmx'preCondition='integratedMode'type='System.Web.Script.Services.ScriptHandlerFactory,System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'/>
<addname='ScriptHandlerFactoryAppServices'verb='*'path='*_AppService.axd'preCondition='integratedMode'type='System.Web.Script.Services.ScriptHandlerFactory,System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'/>
<addname='ScriptResource'preCondition='integratedMode'verb='GET,HEAD'path='ScriptResource.axd'type='System.Web.Handlers.ScriptResourceHandler,System.Web.Extensions,Version=3.5.0.0,Culture=neutral,PublicKeyToken=31BF3856AD364E35'/>
</handlers>
<directoryBrowseenabled='false'/>
<httpProtocol>
<customHeaders>
<clear/>
<addname='X-UA-Compatible'value='IE=EmulateIE7'/>
</customHeaders>
</httpProtocol>
</system.webServer>
<runtime>
<assemblyBindingxmlns='urn:schemas-microsoft-com:asm.v1'>
<dependentAssembly>
<assemblyIdentityname='System.Web.Extensions'publicKeyToken='31bf3856ad364e35'/>

</dependentAssembly>
<dependentAssembly>
<assemblyIdentityname='System.Web.Extensions.Design'publicKeyToken='31bf3856ad364e35'/>

</dependentAssembly>
</assemblyBinding>
</runtime>
<system.serviceModel>

<serviceBehaviors>

<serviceMetadatahttpGetEnabled='true'/>
<serviceDebugincludeExceptionDetailInFaults='false'/>
</behavior>
</serviceBehaviors>
</behaviors>
<services>
<servicebehaviorConfiguration='ServiceBehavior'name='Service'>
<endpointaddress=''binding='wsHttpBinding'contract='IService'>
<identity>
<dnsvalue='localhost'/>
</identity>
</endpoint>
<endpointaddress='mex'binding='mexHttpBinding'contract='IMetadataExchange'/>
</service>
</services>
</system.serviceModel>
</configuration>
</CODE>

Technical Evangelist for DiscountASP.NET

Find ASP.NET code samples with my Dev Coop search tools below.
Google
Microsoft

DiscountASP.NET Technical Webcasts:
http://www.iis7test.com/webcasts/

My Microsoft Technical Blogs
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx
Click to expand...

kobra007 · Jan 26, 2009

IIS7, version 3.5

yes man web.config and if you can check my website www.livemall-lb.com/LiveMall.aspx and figure out the problem, this is the code:

ConnectionStringSettings helpString = ConfigurationManager.ConnectionStrings["InfoConnectionString"];

SqlDataSource helpSource = new SqlDataSource(helpString.ConnectionString, "SELECT Question, Answer FROM Help ORDER BY Question");

IEnumerable helpID = helpSource.Select(DataSourceSelectArguments.Empty); // The error occures here

foreach (DataRowView row in helpID)

{

if (row["Question"].ToString().Contains(questionsList.SelectedValue))

answerText.Text = row["Answer"].ToString();

}

thx so much

wisemx · Jan 27, 2009

Hi,
You can not connect to the MDF on your server you must use the Attach feature in either SQL Server 2005 or 2008.
Please see Video #8: www.iis7test.com/webcasts/
Salute,
Mark

Technical Evangelist for DiscountASP.NET

Find ASP.NET code samples with my Dev Coop search tools below.
Google
Microsoft

DiscountASP.NET Technical Webcasts:
http://www.iis7test.com/webcasts/

My Microsoft Technical Blogs
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

kobra007 · Jan 27, 2009

no man this is not the problem, i know how to use the .mdf upload tools, but the problem is when working with a local database my website works correctly.

but when connecting to discountasp.net database it give me an error!!!!!

if someone can help me please it's very important.

kobra007 · Jan 27, 2009

thx man so much my web.config is correct, so the problem is from the above code.

can you please correct it to me.

when i connect to a local database (.mdf) it works, when connection to my discountasp.net database it gave me the error above

wisemx · Jan 28, 2009

Hi,
If you want me to try and figure this out for you by taking a look at your site code PM me with your Control Panel login info.
Other than that I can't offer much help with this. (Actually none of us can unless we take a look for you.)
Salute,
Mark

Technical Evangelist for DiscountASP.NET

Find ASP.NET code samples with my Dev Coop search tools below.
Google
Microsoft

DiscountASP.NET Technical Webcasts:
http://www.iis7test.com/webcasts/

My Microsoft Technical Blogs
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

Log in or Sign up

web.config

kobra007

Bruce DiscountASP.NET Staff

kobra007

Bruce DiscountASP.NET Staff

wisemx

kobra007

kobra007

wisemx

wisemx

kobra007

wisemx

kobra007

kobra007

wisemx

Share This Page

web.config

Bruce DiscountASP.NET Staff

Bruce DiscountASP.NET Staff

Share This Page

Useful Searches