Databases
StackOverflow2013
Postsdbo
POtrying to find error of the connection string to external sql server
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POtrying to find error of the connection string to external sql server
    primarykey
    data
    text
    <p>iam running asp.mvs web-application. its already hosted and DB is also by same hosting provider. i am trying (already 3 day) to use given <code>connection string</code> for transfering data from DB. here is my method where is my <code>connection string.</code> can you please take a look and see some potential mistake. its very annoing because i cant do this simple thing.</p> <pre><code> /// &lt;summary&gt; /// Gets connection string of Database /// &lt;/summary&gt; /// &lt;returns&gt;connection string of type const&lt;/returns&gt; public static string GetConnectionStringOfDatabase() { try { string cnc = @"data source=OnlineVertrag.mssql.somee.com;workstation id=OnlineVertrag.mssql.somee.com;packet size=4096;user id="xxx";pwd="xxx";persist security info=False;initial catalog=OnlineVertrag"; return cnc; } catch (Exception ex) { bool rethrow = ExceptionHelper.Handle(ex, "Business Logic"); if (rethrow) { throw; } } return null; } public bool CheckIfUserIsActive(string username) { SqlConnection connection = new SqlConnection(SQLDataHelper.GetConnectionStringOfDatabase()); try { connection.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = @"SELECT IsActive " + "FROM Users " + "WHERE Username = @Username"; cmd.Parameters.Add(new SqlParameter("@Username", UserName)); SqlDataReader reader = cmd.ExecuteReader(); bool isActiveValueFromDataBase = false; if (reader.HasRows) { while (reader.Read()) { isActiveValueFromDataBase = Convert.ToBoolean(reader["IsActive"]); if (isActiveValueFromDataBase == true) { return true; } return false; } } reader.Close(); } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USr.r
    1. USr.r
    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
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POtrying to find error of the connection string to external sql server
      1. This table or related slice is empty.
      1. VTModeratorReview
    2. VO
      singulars
      1. POtrying to find error of the connection string to external sql server
      1. This table or related slice is empty.
      1. VTUndeletion
    1. COI'm assuming you open the connection somewhere else, because in the posted code you simply return a connection string. Maybe you need a port number besides the server adress? Have you tried connecting using the server's IP? Check www.connectionstrings.com for some examples.
      singulars
      1. POtrying to find error of the connection string to external sql server
      1. USCMPerez
    2. COiam calling connection string in all methods there i it need.
      singulars
      1. POtrying to find error of the connection string to external sql server
      1. USr.r
    3. COWhat error message do you receive when attempting to connect? What connection information for the server does your hosting provider specify, or what provider do you have? The error messages often contain the problem and hosting providers can often have specific non-default settings from named instances to port numbers.
      singulars
      1. POtrying to find error of the connection string to external sql server
      1. USmatthewnreid
 

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