Problem with SQL database

Question

Hi.
I have a SQL server database in my App_Data folder and I can connect it via my site on localhost, but when I upload my site to host, it does not respond to request.
Actually, I created an ajax page and a HttpHandler to manage ajax requests. It works fine on my computer but does not word on host.
What's the problem?
* host supports my asp.net and sql server version.

Answer 1

These are ajax calls:

//***************************************************
if(obj.selectedIndex == 1)
                    xmlhttp.open("GET", "kadr.gmdfdb", true);
                else if(obj.selectedIndex == 2)
                    xmlhttp.open("GET", "cls1.gmdfdb", true);
                else if(obj.selectedIndex == 3)
                    xmlhttp.open("GET", "cls2.gmdfdb", true);
                else if(obj.selectedIndex == 4)
                    xmlhttp.open("GET", "cls3.gmdfdb", true);
                else if(obj.selectedIndex == 5)
                    xmlhttp.open("GET", "cls4.gmdfdb", true);
                xmlhttp.send();
//***************************************************
* obj is a HTML select element.

As you can see files have strange format. I created a HttpHandler to create proper response correspond to each file name with this file format. Web.Config for HttpHandler:

//***************************************************
<add verb="*" path="*.gmdfdb" type="Nokhbegan.GetMembersDataFromDataBase"/>
//***************************************************

Answer 2

hi,
store the connection string in app settings as

<appsettings>
<add key="sqlserver" Value"your connection_string">
</appsettings>

use it in ur page like

SqlConnection ssqlconn = new SqlConnection(configurationmanaget.appsettings['sqlserver"].Tostring());

hope it help you........

Answer 3

I think the the problem with Ajax calls....

Answer 4

This is my connection string section:
<connectionStrings>
      <add name="MembersConStr" connectionString="Data Source=.\SQLEXPRESS;
           AttachDbFilename=App_Data\Members.mdf;
           Integrated Security=True;User Instance=True"/>
</connectionStrings>

I used |DataDirectory| instead of App_Data in connection string, but did not work again.
Should I change Data Source or Connection string?
I think connection string is right (at least AttachedDbFileName section) because, I created that database via visual studio and copy that connection string into my program.

Answer 5

HI

        First of all u verify the connection string is correct or not and then

u go to web config file and check the connections