ASP.NET Discussion Boards

First Prev Next

Re: Connecting To A Database ASP .NET [All Code Included = Long Topic]

eginteractive31-May-09 4:32

eginteractive

31-May-09 4:32

Server Error in '/' Application.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Source Error:

Line 1423:            this.Adapter.SelectCommand = this.CommandCollection[0];
Line 1424:            DataSet1.PositionlistDataTable dataTable = new DataSet1.PositionlistDataTable();
Line 1425:            this.Adapter.Fill(dataTable);
Line 1426:            return dataTable;
Line 1427:        }


Source File: c:\windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\cb8fe185\bde2cb14\App_Code.vkqy43db.0.cs    Line: 1425

Stack Trace:

[SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846887
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +4860189
   System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +90
   System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +376
   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221
   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +4861315
   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +433
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
   System.Data.SqlClient.SqlConnection.Open() +122
   System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +31
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +112
   System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +162
   System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +115
   DataSet1TableAdapters.PositionlistTableAdapter.Getposition() in c:\windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\cb8fe185\bde2cb14\App_Code.vkqy43db.0.cs:1425

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0
   System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +71
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +350
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29
   System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +488
   System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1247
   System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +95
   System.Web.UI.WebControls.ListControl.PerformSelect() +34
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
   System.Web.UI.WebControls.BaseDataBoundControl.OnPreRender(EventArgs e) +22
   System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +18
   System.Web.UI.Control.PreRenderRecursiveInternal() +80
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842


Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082

Re: Connecting To A Database ASP .NET [All Code Included = Long Topic]

Ramesh Swaminathan31-May-09 4:36

Ramesh Swaminathan

31-May-09 4:36

It seems that your application is not able to connect with the SQL server database from within your application.

Check the SQL server connection string in your web.config.

Re: Connecting To A Database ASP .NET [All Code Included = Long Topic]

eginteractive31-May-09 4:38

eginteractive

31-May-09 4:38

<add name="ConnectionString" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|database.mdf;User Instance=true"/>

That's it. I don't know how else to go about doing this. I have MS SQL database support on my hosting, I just don't know how to get it all working. Right now the database is just in the app_data folder.

Re: Connecting To A Database ASP .NET [All Code Included = Long Topic]

Ramesh Swaminathan31-May-09 4:44

Ramesh Swaminathan

31-May-09 4:44

Is your SQL Server database in the App_Data folder of the web application.

You are using Windows Authentication to connect with SQL Server dataqbase.

The ASP.NET application will run under Network Service account in the server. Therefore you need to provide access to the Network Service account to your database.

Re: Connecting To A Database ASP .NET [All Code Included = Long Topic]

eginteractive31-May-09 4:46

eginteractive

31-May-09 4:46

I'm completely confused. I'm new at this whole thing, what do I need to do, in detail, to get it to work?

Basically I am running on a server that I do not own, I just host there. It has Plesk control panel on it, and it allows me to create MS SQL databases and such. No idea.

Re: Connecting To A Database ASP .NET [All Code Included = Long Topic]

Ramesh Swaminathan31-May-09 4:52

Ramesh Swaminathan

31-May-09 4:52

If the server allows you to create SQL Server database,

Which connection details are you using?

The same connection details should be put your web.config file.

Re: Connecting To A Database ASP .NET [All Code Included = Long Topic]

eginteractive31-May-09 4:55

eginteractive

31-May-09 4:55

I don't have any connection details, I have a Plesk control panel, that allows me to create either an MS SQL database, or a MySQL database, all I know is that you create a database, in my case it would be erik_database, and a username, in my case I created it to be simply aspadmin, and that's it.

Re: Connecting To A Database ASP .NET [All Code Included = Long Topic] [modified]

Ramesh Swaminathan31-May-09 5:08

Ramesh Swaminathan

31-May-09 5:08

I assume that you have used SQL Server database in your application.

How do you create SQL server database in the server. Using SQL Management Studio?. if so, then you can see the server name, database name and also you need to enter password.

Assume that erik_database is name of the SQL database and aspadmin is the user name, 'YourServerName' is the server name, 'YourPassword' is the password to be used connect with database, then connection string in your web.config should be as below

<add name="connectionString" connectionString="Database=erik_database;server=YourServerName;Uid=aspadmin;pwd=YourPassowrd" providerName="System.Data.SqlClient"/>

modified on Sunday, May 31, 2009 11:04 AM

Re: Connecting To A Database ASP .NET [All Code Included = Long Topic]

eginteractive31-May-09 5:11

eginteractive

31-May-09 5:11

What is the common port for a MS SQL server?

Re: Connecting To A Database ASP .NET [All Code Included = Long Topic]

Ramesh Swaminathan31-May-09 5:22

Ramesh Swaminathan

31-May-09 5:22

1433

Re: Connecting To A Database ASP .NET [All Code Included = Long Topic]

eginteractive31-May-09 9:45

eginteractive

31-May-09 9:45

I got my apps to connect, but now it's strange because every time I go to my site a username and password dialog shows up, and I can't even login. Odd.

c# retrieve total non-paged memory usage remotely

jw0rd31-May-09 4:03

jw0rd

31-May-09 4:03

Hello,

I'm working on a simple ASP .NET health checker and I've run into a few obstacles.

1) I need to be able to get the full non-paged memory usage from a remote machine (on same network). I've tried using System.Diganostics.Process.NonpagedSystemMemorySize64 however I've come to realize that the kernel's nonpaged usage is going to be missing from that total. Here is a quick sample of what I was doing:

Process[] myprocess = Process.GetProcesses("computername");

foreach (Process p in myprocess)
{
nonpaged += p.NonpagedSystemMemorySize64
}

2) I can overcome that locally by using System.Diagnostics.PerformanceCounter however you can only access the API for that class locally. Is there another class that would suit my needs?

Any help would be appreciated.

when to use state server out procees session and sql server out process session

sunkrajesh31-May-09 3:26

sunkrajesh

31-May-09 3:26

can anyone tell me when to use state server outprocess session and sql server out process session? and also give me some real time scenarios for both of them?

rajesh sunakri

Re: when to use state server out procees session and sql server out process session

Ramesh Swaminathan31-May-09 5:32

Ramesh Swaminathan

31-May-09 5:32

State server session and SQL Serevr session are useful when you deploy your application in web Garden or Web Farm environment.

Web garden is a scenario in which a single server machine has multiple aspnet worker processes running simultaneously. The server should have multiple processor.

Web Farm is a method of hosting a web site in a cluster of servers. The web request to the web application will be handled by multiple servers.

StateServer is faster than SqlServer session. But SQL Server is more reliable and used for mission critical applications.

Check this link[^]

How to create a TAB page in ASP.NET!!

Sr...Frank31-May-09 2:37

Sr...Frank

31-May-09 2:37

Hi Guys,

I have a web page with many controls in ASP.NET and I am showing records to these controls from database.
Now what I am trying to do is I want to create same page with same controls but this new page should be open as a tab page.
Could you please provide me any link or source code which can help me out?
(I am trying to create a TAB page with same controls)

Thanks,
Smile | :)

Re: How to create a TAB page in ASP.NET!!

mrcooll31-May-09 4:26

mrcooll

31-May-09 4:26

u can use ajax or some javascript framework like jquery.
if u need more info tell me!

Re: How to create a TAB page in ASP.NET!!

Ramesh Swaminathan31-May-09 4:34

Ramesh Swaminathan

31-May-09 4:34

Use Ajax Tab control.

Look into this[^]

Detailed exception from webservice while customError mode is "On"

offengenden31-May-09 1:53

offengenden

31-May-09 1:53

In my web application I have a webservice. I'm using this webservice inside this web application. The mode of customError (in web.config) is set to "On". This prevent from me to get detailed exception in client (javascript). My webmethod defined as scriptmethod too. If I turn customError off I start getting the detailed exception. I need to keep stay with customError set to "On", but get detailed exception from webservice instead of general exception with this message: "There was an error processing the request".

Thanks.

Re: Detailed exception from webservice while customError mode is "On"

Mountains2Hike9-Jun-09 8:55

Mountains2Hike

9-Jun-09 8:55

Anyone have an answer for this, I have the same issue.

With customError set to On or RemoteOnly:
When the webservice method throws an error with a detailed error message, then on the error return to javascript, results.get_message() shows the generic message "There was an error processing the request", not the detailed error message.

With customError set to Off:
When the webservice method throws an error with a detailed error message, then on the error return to javascript, results.get_message()shows the detailed error message.

I want the customError to be set to RemoteOnly, but I also want get_message() to have the detailed error message, not the generic one.

Any thoughts, fixes, workarounds would be greatly appreciated.

Re: Detailed exception from webservice while customError mode is "On"

offengenden9-Jun-09 10:06

offengenden

9-Jun-09 10:06

Create a new folder and move there your asmx file (the asmx.cs/asmx.vb will stay in app_code folder). Add a new web.config to your new folder by "Add new item... -> Web Configuration file". Your new web.config will be almost empty. Add a "customError" element as you did it in your main web.config and set it to Off.
That's all.

Re: Detailed exception from webservice while customError mode is "On"

Mountains2Hike9-Jun-09 11:12

Mountains2Hike

9-Jun-09 11:12

perfect. thanks for replying!

Change Crystal Reports CSS Path

Tamimi - Code30-May-09 23:18

Tamimi - Code

30-May-09 23:18

hi:

how can i change the default path (aspnet_client/system_web/2_0_50727....)
for the images and css in the toolbar inside the CrystalReportViewr.
what i want, is to put all those files inside my application.

thank you

When you get mad...THINK twice that the only advice
Tamimi - Code

Re: Change Crystal Reports CSS Path

Ramesh Swaminathan31-May-09 6:29

Ramesh Swaminathan

31-May-09 6:29

Look into this[^].

Re: Change Crystal Reports CSS Path

Tamimi - Code31-May-09 22:10

Tamimi - Code

31-May-09 22:10

thank you

When you get mad...THINK twice that the only advice
Tamimi - Code

Reading & Modifying data grid cell entries

ashutosh_karna30-May-09 12:23

ashutosh_karna

30-May-09 12:23

Hi, I am trying to make a spreadsheet in asp.net wherein, the user can enter some data and I display results for one of my methods( say Average, Standard deviation etc,). Can anybody please guide me how I read data from spreadsheet at runtime & then pass these data as parameter to my methods.
e.g

public static double Sum( double [] data)
{
double sum =0.0;
for(int i=0;i

Last Visit: 31-Dec-99 19:00 Last Update: 29-Nov-23 5:56

Refresh

ᐊ Prev 1...1936 1937 1938 193919401941 1942 1943 1944 1945 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.