locked
Need someone that can help me in publishing sql connectivity area RRS feed

  • Question

  • User805223751 posted

    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

    Monday, September 3, 2018 5:37 AM

All replies

  • User283571144 posted

    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

    Tuesday, September 4, 2018 2:55 AM
  • User805223751 posted
    Hello brando I have actually posted on another thread my problem but so far no solution it was about that my published website doesn't connect to sql
    Tuesday, September 4, 2018 3:39 AM
  • User283571144 posted

    Hi ahmadk1990,

    Could you please post the details error message and how you connect to sql? using ADO.NET or EF?

    Best Regards,

    Brando

    Tuesday, September 4, 2018 6:53 AM
  • User805223751 posted
    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
    Tuesday, September 4, 2018 6:55 AM
  • User283571144 posted

    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

    Tuesday, September 11, 2018 8:13 AM
  • User1266736465 posted

    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.

    Tuesday, September 11, 2018 11:27 PM