ASP.NET

ASP.Net Site not allowing multiple logins.

5-Jan-09 0:18

ellllllllie wrote:
Can i create a web application setup

Yes you can Create a Web SetUp Project .
Have a look[^]

cheers,
Abhijit

Paramhans Dubey4-Jan-09 22:03

Paramhans Dubey

4-Jan-09 22:03

Hi Experts,

I have a web site in ASP.Net with Sql Server 2000 as DB. My problem is that the web application is not allowing concurrent logins to it. Once a user logs into the site starts some process, the database get locked and other user can not get access to the site. For the first user it works fine but other concurrent connections it gives me following error message:

"{"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interface..."<br />

I don't know whats the reason for this. I think I am missing some settings in my server.

I have used following connection string

"Data Source=MyServer; Initial Catalog=MyDb; User ID=un; Password=123456; MultipleActiveResultSets=True; pooling=true"<br />

Can anyone help me out. Its very urgent.
__________________

Regards,
Paramhans Dubey.

Abhijit Jana4-Jan-09 22:11

4-Jan-09 22:11

Check you code . Are you using Conn.Dispose() any where of your application ?

cheers,
Abhijit

Paramhans Dubey4-Jan-09 22:15

Paramhans Dubey

4-Jan-09 22:15

Hi Abhijit,

Thanx For your reply. answer is No. I have not used Conn.dispose() anywhere in my code.

Abhijit Jana5-Jan-09 0:22

5-Jan-09 0:22

I think This[^] link will may help you out .

cheers,
Abhijit

Paddy Boyd5-Jan-09 2:13

Paddy Boyd

5-Jan-09 2:13

Have you looked to see if anything is locked in your database after the first user has logged in?

Sundar_R5-Jan-09 5:56

Sundar_R

5-Jan-09 5:56

Are you able to connect to the DB server via Query analyzer or through remote desktop.
Think you dont have rights to connect to the server.

Paramhans Dubey5-Jan-09 19:00

Paramhans Dubey

5-Jan-09 19:00

Yes i am able to connect to database using query analyzer.

Fill CheckBox From database in Asp.net C#

Sundar_R5-Jan-09 21:37

Sundar_R

5-Jan-09 21:37

Then the problem is in the transaction that you are using.
Where is the transaction being controlled ? is it in the business layer or at the SQL level ?
Have you closed all the transactions properly ?
Have a look at the activity monitor, filter by the database and check.

mayankb_074-Jan-09 21:39

mayankb_07

4-Jan-09 21:39

1, How fill CheckBox
2, CheckBox value get it from database
3, as per database value (true/false). checkbox wil checked or unchecked
4, checkbox are in grideview

Re: Fill CheckBox From database in Asp.net C#

Abhijit Jana4-Jan-09 21:53

4-Jan-09 21:53

mayankb_07 wrote:
1, How fill CheckBox

CheckBox1.Text="Your Text"

mayankb_07 wrote:
2, CheckBox value get it from database
3, as per database value (true/false). checkbox wil checked or unchecked

Read Value from database

if(CheckedTrue())
   {
     CheckBox1.Checked=True;
   }

Note : CheckTrue() Will return true and false based on your database value. You need to implement that. Smile | :)

mayankb_07 wrote:
4, checkbox are in grideview

Use TemplateField in Gridview

Hope this will helps to resolves all of your query .

cheers,
Abhijit

sms scheduling

meghamaharshi4-Jan-09 21:26

meghamaharshi

4-Jan-09 21:26

How to send sms on particular date like on birthday etc in asp.net..

Brij4-Jan-09 21:54

Brij

4-Jan-09 21:54

Can you bit detail about you requirement?

Cheers!!
Brij

Abhijit Jana4-Jan-09 22:03

4-Jan-09 22:03

meghamaharshi wrote:
How to send sms on particular date like on birthday etc in asp.net

Here is
Codeproject Article 1[^]
Code project Article 2[^]
and
Many More[^]

cheers,
Abhijit

meghamaharshi4-Jan-09 22:41

meghamaharshi

4-Jan-09 22:41

Thanks for reply..i already use webservice for sending sms..but now i want to send sms on specified date time whether your application is running or not..sms should be sent..

N a v a n e e t h5-Jan-09 0:21

N a v a n e e t h

5-Jan-09 0:21

Write a console application and schedule it using windows scheduler.

Navaneeth

How to use google | Ask smart questions

meghamaharshi5-Jan-09 2:15

meghamaharshi

5-Jan-09 2:15

Thanks for reply..plz would you tell me in some detail..