Databases
StackOverflow2013
Postsdbo
POWeb.config configuration seems correct. But still can't access database on the hosting server
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWeb.config configuration seems correct. But still can't access database on the hosting server
    primarykey
    data
    text
    <p>I know there is a high possibility of this question being asked by many people. but I'm very confident that I have read most of those questions and still wasn't able to find solution.</p> <p>below are all the steps I have done so far in details in order to deploy my web application on the Godaddy hosting servers:</p> <ul> <li><p>I am using ASP.NET MVC 3 (C#).</p></li> <li><p>I have uploaded and deployed the website on godaddy hosting services.</p></li> <li><p>I have inserted my database by executing the Script I generated from my SSMS into the godaddy MS SQL server database.</p></li> </ul> <p>Finally, according to <a href="http://support.godaddy.com/help/article/3323/locating-your-database-connection-strings" rel="nofollow">this</a> I was able to get my connectionString.</p> <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt; &lt;configuration&gt; &lt;system.web&gt; &lt;compilation debug="true" targetFramework="4.0" /&gt; &lt;/system.web&gt; &lt;connectionStrings&gt; &lt;add name="database-name" connectionString="Data Source=mysource; Initial Catalog=database-name; User ID=userid; Password=password;" providerName="System.Data.SqlClient" /&gt; &lt;/connectionStrings&gt; &lt;/configuration&gt; </code></pre> <p>However, I'm still not able to connect my web application to its database when I try it on the internet. I'm very sure that my connectionString is correct since it's been just copy-pasted from my host service provider.</p> <p>I am pretty sure I have missed something except my webconfig or my connectionString. Is there anything else except web.config file that is critical and has effects on connection?</p> <p>Regards, Amin</p> <p>EDIT:</p> <p>Sorry to not mention earlier. I DID put the correct "name", "Data Source", "Data Source", "User ID" and "Password". I intentionally changed them for security purposes.</p> <p>SECOND EDIT:</p> <p>There is no error when I try to fetch the data in my application.. the response is just simply null from the database. But my tables DOES exist in the database with all the data inside.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmoamzia
    1. USmoamzia
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COjust to check, you DID change the username password combination to your credentials right? :) User ID=userid; Password=password;
      singulars
      1. POWeb.config configuration seems correct. But still can't access database on the hosting server
      1. USbas
    2. CO@user1807954 You should mention the exception message.
      singulars
      1. POWeb.config configuration seems correct. But still can't access database on the hosting server
      1. USMatías Fidemraizer
    3. COWhen you provide no informations, how are we supposed to help you? Provide an exception message, tell us what database framework you're using, what kind of database server do you use?
      singulars
      1. POWeb.config configuration seems correct. But still can't access database on the hosting server
      1. USuser1908061
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload