webservice asmx example not working hosting area and no error (jquery datatables , asmx, AJAX,C#)

Question

User-840896699 posted

I found a basic webservice asmx example ( c# and sql stored prosedure jquery datatables and webservice) and applicated- called getstudent-
It works via Visualstudio publish and there is no problem when publising in my localhost.

Visual studio --> url : "StudentService.asmx/GetStudents" ok
localhost ---> url: "localhost/test/StudentService.asmx/GetStudents" ok

I tried several url like url: "http://www.myhost.com/StudentService.asmx/GetStudents",
but when publising in my hosting area (internet) there is no error , only shows the coulums.

I think there is a mistake StudentService.asmx 's url.

Please help me.

Regards

Answer 1

User-330142929 posted

Hi,
It seems that your function returns some result that queried in your database. Please pay attention to the connections string. Because the machine hosting the service has changed, our connection string needs to use a specific username and password to connect to the database. The integrated security is no longer valid. This may be the cause of the inconsistent returned result.
Feel free to let me know if there is anything I can help with.
Best Regards
Abraham