Well basically no error messages i am using asp.net and connected it to the sql server which works fine and updates from there but the published website which i am using the iis for it when i enter data and hit submit nothing happens it doesn't update sql with
the new inserted data
you've mentioned in one of your post that it works on your end but it does not work after published, it could lots of things
such as database user permission, or web.config needs to have some default line commented some hosting service don't allow these line in web.config, I've seen it with shared hosting at accuwebhosting. Note: it might not be the default lines in web.config but
you should check with hosting service just in case.
Member
8 Points
45 Posts
Need someone that can help me in publishing sql connectivity area
Sep 03, 2018 05:37 AM|ahmadk1990|LINK
Can someone who is expert in this to connect through teamviewer with me and see what is going on and help me fix the connectivity thanks
Star
9141 Points
2797 Posts
Re: Need someone that can help me in publishing sql connectivity area
Sep 04, 2018 02:55 AM|Brando ZWZ|LINK
Hi ahmadk1990,
According to your description, I suggest you could modify the reply with what issue you have faced or what requirement you want.
If you could post more details information, it will be more easily for us to understand your issue and find out the solution.
Best Regards,
Brando
Member
8 Points
45 Posts
Re: Need someone that can help me in publishing sql connectivity area
Sep 04, 2018 03:39 AM|ahmadk1990|LINK
Star
9141 Points
2797 Posts
Re: Need someone that can help me in publishing sql connectivity area
Sep 04, 2018 06:53 AM|Brando ZWZ|LINK
Hi ahmadk1990,
Could you please post the details error message and how you connect to sql? using ADO.NET or EF?
Best Regards,
Brando
Member
8 Points
45 Posts
Re: Need someone that can help me in publishing sql connectivity area
Sep 04, 2018 06:55 AM|ahmadk1990|LINK
Star
9141 Points
2797 Posts
Re: Need someone that can help me in publishing sql connectivity area
Sep 11, 2018 08:13 AM|Brando ZWZ|LINK
Hi ahmadk1990,
According to your description, I suggest you could use sql profile to help you troubleshoot the reason.
I suggest you could use it to check your web application has already passed the query to sql database.
More details about how to use it, you could refer to below article.
https://www.mssqltips.com/sqlservertip/2040/use-sql-server-profiler-to-trace-database-calls-from-third-party-applications/
Best Regards,
Brando
Member
54 Points
151 Posts
Re: Need someone that can help me in publishing sql connectivity area
Sep 11, 2018 11:27 PM|msdevm|LINK
Please post your code in order to better help you
For Instance
Code used to build the app or website ASP.NET (VB or C#)
SQL Connection (Using ADO.NET, OLDB, SqlClient, Entity or ODBC etc.)
take it a look a this for more detail connecting to SQL Database -->https://www.connectionstrings.com/sql-server/
Entity Framework --> https://docs.microsoft.com/en-us/aspnet/entity-framework
you've mentioned in one of your post that it works on your end but it does not work after published, it could lots of things
such as database user permission, or web.config needs to have some default line commented some hosting service don't allow these line in web.config, I've seen it with shared hosting at accuwebhosting. Note: it might not be the default lines in web.config but you should check with hosting service just in case.
Good Luck.