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.

Majid Kamali · Answer

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: //*************************************************** //***************************************************

Jiteendra Sampathirao · Answer

hi, store the connection string in app settings as use it in ur page like S qlConnection ssqlconn = new S qlConnection(configurationmanaget.appsettings['sqlserver"].Tostring()); hope it help you........

Jiteendra Sampathirao · Answer

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

Majid Kamali · Answer

This is my connection string section: AttachDbFilename=App_Data\Members.mdf; Integrated Security=True;User Instance=True"/> 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.

Praveen kumar Ravindran · Answer

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

Problem with SQL database

gregg 0