ASP.NET

Re: Sql File Connection Error when Web App is Deployed to Remote/Hosting Server (works locally though)

11-Dec-07 16:37

I have an app that connects to a db in the Data Directory for Website Project. I am able to connect to the database fine locally. However, after I uploaded my project to my hosting provider's server and try to process a form that does a sql insert, I receive the following error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure my be caused by the fact that under the default settings SQL server does not allow remote connections. (provider: Sql Network Interfaces, error 26 - Error Locating Server/Instance Specified.

My connection string to the datasource is as such in my webconfig file:

connectionString="DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|DefinaBackEnd.mdf;IntegratedSecurity=True;ConnectTimeout=30;User Instance=True"

and the call to the connecting string is called as such:
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefinaBackEndConnectionString"].ConnectionString);
conn.Open();

Can someone please assist with how to resolve this as this site just looks for a sql db file as opposed to an instance of sql server itself. Thanks to all in advance.

N a v a n e e t h11-Dec-07 16:56

N a v a n e e t h

11-Dec-07 16:56

As the error message say's you need to enable remote connections on SQL 2005. Goto Surface area configuration and choose remote connection tab. Click on allow remote connection and restart the service. For SQL express, check www.connectionstrings.com[^] to get proper connection string.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Re: Sql File Connection Error when Web App is Deployed to Remote/Hosting Server (works locally though)

dboy22111-Dec-07 17:21

Re: Sql File Connection Error when Web App is Deployed to Remote/Hosting Server (works locally though)

11-Dec-07 17:21

Hi,

Is this even the case when trying to connect to an mdf file stored in data directory as opposed to be stored within an instance of sql server? I do not have administrative access to my hosting server (as I use a solution provider to host my site) and just want to make sure that I give him the proper configuration solution.

Venkatesh Mookkan11-Dec-07 16:56

Venkatesh Mookkan

11-Dec-07 16:56

dboy221 wrote:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure my be caused by the fact that under the default settings SQL server does not allow remote connections. (provider: Sql Network Interfaces, error 26 - Error Locating Server/Instance Specified.

This error seems like your Sql Server 2005 is configured to not to access remotely. To setup it do the following:

1. Open SQL Server Management Studio, login with Administrator Userid (Preferably "sa").
2. Right Click the SQL Instance in the Object Explorer and choose the Properties.
3. Properties Dialog would open.Choose Connections in Page List.
4. Check Allow remote connections to this server check box.
5. Click OK.

Thats it.

Regards,
Venkatesh Mookkan.
Software Engineer, India
My: Website | Yahoo Group | Blog Spot

Re: Sql File Connection Error when Web App is Deployed to Remote/Hosting Server (works locally though)

Michael Sync11-Dec-07 17:02

Re: Sql File Connection Error when Web App is Deployed to Remote/Hosting Server (works locally though)

11-Dec-07 17:02

You can check this link ~

http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx[^]

dboy221 wrote:
connectionString="DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|DefinaBackEnd.mdf;IntegratedSecurity=True;ConnectTimeout=30;User Instance=True"

There are two cases for this issues and the solution included in this link.

1. SQL Server 2005 Open SQL Server Configuration Manager. Select "SQL Server 2005 Network Configuration | Protocols for MSSQLSERVER" then enable the protocols you need.

2. You might need to add the custom SQL membership provider since the most of web server doesn't have the SQL express installed locally.

Ref : http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx[^]

Someone said that adding the SQL port 1433 might be solve the problem.

Example ~

connectionString="DataSource=.\SQLEXPRESS:1433;AttachDbFilename=|DataDirectory|DefinaBackEnd.mdf;IntegratedSecurity=True;ConnectTimeout=30;User Instance=True"

Ref : http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx[^]

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

dboy22112-Dec-07 6:11

Re: Sql File Connection Error when Web App is Deployed to Remote/Hosting Server (works locally though)

12-Dec-07 6:11

Hi Michael,

I attempted to modify the the web config file with a the custom SQL membership provider, but still received the error. Are there any other solutions that may assist with this? I have asked my hosting solution provider to look into the issue as well. I know that they have an instance of sql server 2000 on their server, but no express 2005.

Michael Sync12-Dec-07 6:21

Re: Sql File Connection Error when Web App is Deployed to Remote/Hosting Server (works locally though)

12-Dec-07 6:21

dboy221 wrote:
I have asked my hosting solution provider to look into the issue as well

I think this is the best thing. Because the most of hosting providers does have the documentation about how to connect the database in their hosts.. The hosting that I used before never install the database on their webserver. They used to have the seperated database server .....

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

dboy22112-Dec-07 8:01

How to export All records from gridview to excel when paging in gridview

12-Dec-07 8:01

Thanks. My hosting provider explain to me that they actually have an instance of SQL Express 2005 running on a separate server. I'll upload my .mdf file to that server and use the necessary credentials for my connection string.

$unil Dhiman11-Dec-07 14:47

$unil Dhiman

11-Dec-07 14:47

Hi All,
I want to export to Excel from gridview. I have implemented it.
But if there is paging in gridview, it export only the rows on the particular page.
I want to Export All Rows of all pages.
for example I have 50 records and page size is 10. then there will be 5 pages
10 records per page. if I will export from page 1 then only 10 records will be export.
I want to export All 50 records once.

I use this code to Export to excel :
protected void ExportGridView(Control grdView, string strFileName)
{

string strfName = Server.UrlPathEncode(strFileName);

string attachment = "attachment; filename=" + strfName + ".xls";

Response.ClearContent();

Response.Buffer = true;

Response.AddHeader("content-disposition", attachment);

Response.ContentType = "application/unknown";

System.Web.HttpContext.Current.Response.Write("<meta http-equiv=Content-Type content='text/html; charset=utf-8'>");

StringWriter sw = new StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

grdView.RenderControl(htw);

Response.Write(sw.ToString());

Response.End();

}

Plz Help me.

Re: How to export All records from gridview to excel when paging in gridview

Michael Sync11-Dec-07 16:50

Re: How to export All records from gridview to excel when paging in gridview

11-Dec-07 16:50

If you have the dataset that hold all 50 records, you can generate the excel file by using Microsoft Excel object library.

OR

$unil Dhiman wrote:
grdView.RenderControl(htw);

Instead of doing like that, I think you should loop though the dataset that has all 50 records.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

$unil Dhiman11-Dec-07 17:28

$unil Dhiman

11-Dec-07 17:28

Thanks.

Godaddy ?!

sergeyv200211-Dec-07 11:03

sergeyv2002

11-Dec-07 11:03

I have been hosting my web site with godaddy for about 6 month now (shared hosting). Recently, I am experiencing a huge delay when sending emails (45 min or more). I tried contacting their support and this was their response:

Unfortunately, when messages are sent from scripts on a Windows shared hosting account, there should be a 30 minute to an hour delay. I apologize for any inconvenience this may cause. Let us know if we can help you in any other way.

First of all my application is not a script, it is ASP.NET application,
second of all I definitely did not expect that kind of answer.
My application must be able to interact with user via email and that kind of a delay is completely intolerable.
When I called their support I was put on perpetual hold... I am pretty mach fed up with GoDaddy...

Does anyone else have similar issue with GoDaddy.
Can anyone suggest another non expensive reliable host?

Christian Graus11-Dec-07 13:26

Christian Graus

11-Dec-07 13:26

I have found that emails can be pretty slow, I just implimented them last night. One suggestion - use a different mail server to the one they provide. It's their mail server that is the bottleneck, surely ?

sergeyv200211-Dec-07 14:11

sergeyv2002

11-Dec-07 14:11

Hi Chris.
Thanks for reply. It is definitely their mail server.
I thought of installing an email server on my home PC but that means that I'll have to relay my messages through my ISP and when someone looks at the email and discovers that I am using "Rogers" (local provider) it will seem unprofessional.

Do you know any other strategies to tackle this issue? I honestly think to move to another hosting provider. I had way to many issues with GoDaddy.

Christian Graus11-Dec-07 16:43

Christian Graus

11-Dec-07 16:43

How would someone work out what server the email went through, without doing a lot of digging ?

What issues ? We're just starting with them

Michael Sync11-Dec-07 15:38

11-Dec-07 15:38

sergeyv2002 wrote:
Does anyone else have similar issue with GoDaddy.

I heard a lot of people has the problems with GoDaddy.

sergeyv2002 wrote:
Can anyone suggest another non expensive reliable host?

For windows host, I love DiscountASP.NET. Their service is really great.. For Linux host, I'm currently using DreamHost.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

IE Cookie Problem

FinnGrimw11-Dec-07 10:06

FinnGrimw

11-Dec-07 10:06

Hi guys,

I'm having a problem with deleting a cookie in internet explorer. I've got some code that calls the Response.Cookies[CookieName].Expires = DateTime.Now.AddYears(-30); line to try to delete a cookie.

This works fine in Firefox and Safari (haven't tried any others) but it just doesn't work at all in internet explorer 7. I'm really at a loss as to why this is. Any ideas?

I've also tried creating a new cookie with a negative expiration date that has the same name as the old cookie but this doesn't work in IE either (works fine in firefox and safari again).

Thanks

Finn

FinnG -

Re: IE Cookie Problem

Michael Sync11-Dec-07 15:47