ASP.NET

21-Mar-08 16:54

We have articles on this site. Sounds like you're looking to write one ?

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Database Engines

Mohammad A Gdeisat21-Mar-08 12:37

21-Mar-08 12:37

Hi,

I am new to ASP .NET and I am creating an e-exam website for a customer, the customer will have at most 50 students taking an exam simultanously.

I want to create a Microsoft Jet (Access) database (.mdb), but I know that Access database format is not designed to be used in websites where concurrency is an issue.

The question is:
Can Microsoft Access database files bear the load of 50 students submitting their answers almost at the same time or do I need an SQL server database? I don't know but I think that 50 users is a very small load even for this kind of database.

Any answers?

Thanks Poke tongue | ;-P

And ever has it been that love knows not its own depth until the hour of separation

Christian Graus21-Mar-08 12:54

21-Mar-08 12:54

Mohammad A Gdeisat wrote:
I am new to ASP .NET and I am creating an e-exam website for a customer

It's only a matter of time before the backlash starts because of people who take on clients in technologies they are new to.

I would say go with SQL Server. According to google[^], 10 is the limit for the Jet engine, even across different apps. That doesn't mean that you can even have 10 concurrent users for an Access DB, let alone 50.

Mohammad A Gdeisat21-Mar-08 12:57

21-Mar-08 12:57

Ok, now my client wants to install the website on his own server (in the school). The server is running Windows XP.

Does my client need to install any applications (other than IIS) to make the website work with SQL server database?

Thanks Smile | :)

And ever has it been that love knows not its own depth until the hour of separation

Christian Graus21-Mar-08 13:02

21-Mar-08 13:02

I recommend reaing this[^].

No, he doesn't need anyting else, but for 50 users, he's going to have to buy SQL Server, I believe that's more than the Express Edition will support.

Mohammad A Gdeisat21-Mar-08 13:12

21-Mar-08 13:12

I just have one more question about the same issue.

I don't want my client to buy SQL server (if possible), so I would suggest myself to place the code that tries to connect to the database in a loop that checks whether the connection has succeeded or not, if it succeeds then it will update the database, if not, then it will try to connect again and again until it succeeds and then update the database, and so on.

Does this solve part of the issue or is it a BAD solution?

Thanks Smile | :)

And ever has it been that love knows not its own depth until the hour of separation

Christian Graus21-Mar-08 13:22

21-Mar-08 13:22

I guess it depends. He's probably paying you little enough that if you can handle the work, writing some sort of caching that does the DB updates when the DB is free, may be a viable solution. It's a hack tho. You still will be using a tool that's not suited to the task, when 50 students make a request that takes some time, if they all have to wait their turn, you risk web pages timing out, and your app breaking.

Brady Kelly21-Mar-08 23:43

Brady Kelly

21-Mar-08 23:43

Only 2 out of our 190 client sites use full SQL Server. There are no more connection limits on 2005, just CPU and RAM, so for a standard DB, without additional services, there is nothing wrong with Express for 50 users.

Paul Conrad21-Mar-08 13:16

21-Mar-08 13:16

Christian Graus wrote:
only a matter of time before the backlash starts because of people who take on clients in technologies they are new to

Yep.

Christian Graus wrote:
10 concurrent users for an Access DB, let alone 50

A client of mine uses Access with about 10-15 concurrent and I've warned them about consequences of overloading the database. They want to add a few more people, and we'll see Roll eyes | :rolleyes:

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Paul Conrad21-Mar-08 13:14

21-Mar-08 13:14

Why not use SQL Server 2005? Access may run into trouble with more than 10 concurrent users.

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Mohammad A Gdeisat21-Mar-08 13:18

21-Mar-08 13:18

My client will install the website in his local server that runs WinXP, and I don't think that he will buy SQL server. He wants to run the application only in his local network, and I guess that the application is too small to deserve buying SQL server..

I would support your comment if my clien wants to install the website on a public web server because he will have to pay nothing, but buying SQL server for this application for which he paid me $1400 is not an option. Smile | :)

Thanks

And ever has it been that love knows not its own depth until the hour of separation

Christian Graus21-Mar-08 13:24

21-Mar-08 13:24

Mohammad A Gdeisat wrote:
for which he paid me $1400

OK then....

MySQL is always an option and there are other DBs out there. MySQL may even be free ( check the license ), because he's a non commercial user.

Paul Conrad21-Mar-08 13:27

21-Mar-08 13:27

Go with SQL Server 2005 Express edition. Works better than Access...

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Christian Graus21-Mar-08 13:33

21-Mar-08 13:33

I think the express edition has a pretty low number of concurrent users, too.

No[^], that was the previous edition. Live and learn. So, I agree, that's probably the best option.

Mohammad A Gdeisat21-Mar-08 13:37

21-Mar-08 13:37

Yes, Thanks.

But if I develop my application using Microsoft SQL Sever (not express edition), and my user tries to run it under the Express edition, will he be able to get it to work? are those similar products compatabile?

I am asking because I have SQL server installed on my computer, so should I uninstall it, then install the Express edition to make the application compatible with the express edition?

Thanks Smile | :)

And ever has it been that love knows not its own depth until the hour of separation

Paul Conrad21-Mar-08 13:42

21-Mar-08 13:42

Mohammad A Gdeisat wrote:
I have SQL server installed on my computer, so should I uninstall it, then install the Express edition

No. They should both be able to run side-by-side. The instance name for the SQL Server 2005 Express should be something different than SQL Server. You might want to look at FirebirdSQL, as well.

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Unrecognized element 'membership' [modified]

N a v a n e e t h21-Mar-08 20:17

N a v a n e e t h

21-Mar-08 20:17

I suggest you to use MySQL. It's proven the performance and can access many concurrent connection. It can be downloaded from MySQL site freely. Download MySQL connector for .NET also. I use MySQL with many projects which I have, it works really well.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

amistry_petlad21-Mar-08 9:33

amistry_petlad

21-Mar-08 9:33

Hi !
I have found the solution from the Google and put the things under system.web in web.config file but still it show the same error

Unrecognized element 'membership'

I have found the solution from the below link for
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx[^]

But although its not working

I really appreciated if someone can help me thanks in adv.

modified on Friday, March 21, 2008 4:20 PM

Re: Unrecognized element 'membership'

pmarfleet21-Mar-08 11:01

pmarfleet

21-Mar-08 11:01

Have you placed the membership section in the right place? It needs to be a child item of system.web.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

[Message Deleted]

amistry_petlad21-Mar-08 11:27

amistry_petlad

21-Mar-08 11:27

[Message Deleted]

Re: Unrecognized element 'membership'

pmarfleet21-Mar-08 11:53

pmarfleet

21-Mar-08 11:53

<blockquote class="FQ"><div class="FQA">amistry_petlad wrote:</div><compilation debug="true"></compilation></blockquote>

You haven't closed the compilation tag.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: Unrecognized element 'membership'

amistry_petlad21-Mar-08 14:38

amistry_petlad

21-Mar-08 14:38

Oh that not an issue i have sent you the partial code ..the prob. is something different..
The web.config is almost ok.. According to me ..

Error: Update requires a valid UpdateCommand when passed DataRow collection with modified rows.

MattMN21-Mar-08 6:27

MattMN

21-Mar-08 6:27

I get the error "Update requires a valid UpdateCommand when passed DataRow collection with modified rows." on the line adap.Update (ds,"Config"). Everything else works fine. Here is the rest of the code for that section. If anyone can help me to correct this message when I try to update the database that would be great.

sub btnUploadTheFile_Click (sender As Object, e As EventArgs)<br />
dim strFileNameOnServer<br />
dim strBaseLocation<br />
strFileNameOnServer = txtServername.Value<br />
strBaseLocation = Server.MapPath("")<br />
  if strFileNameOnServer ="" then<br />
 txtOutput.InnerHtml = "Error - a file name must be specified."<br />
 return<br />
end if<br />
    try <br />
dim imageUrl as string<br />
Dim connect As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= "& Server.mappath("matt.mdb") & ""<br />
Dim conn as New OleDbConnection(connect)<br />
dim adap as OleDbDataAdapter<br />
Dim ds as New Dataset<br />
adap= New OleDbDataAdapter ("SELECT * FROM Config",conn)<br />
adap.Fill (ds,"Config")<br />
dim de as datarow<br />
ds.Tables("Config").Rows(0)("Logo") = txtServername.Value<br />
response.Write (ds.Tables("Config").Rows(0)("Logo")) <br />
adap.Update (ds,"Config")<br />
imageurl=(ds.Tables("Config").Rows(0)("Logo")) <br />
Image1.ImageUrl = imageurl<br />
conn.close()<br />
      uplTheFile.PostedFile.SaveAs(strBaseLocation+"\"+strFileNameOnServer)<br />
      txtOutput.InnerHtml = "File <b>"  + strBaseLocation+"\"+strFileNameOnServer+"</b> uploaded successfully"<br />
    catch ex as exception <br />
  txtOutput.InnerHtml = "Error saving <b>" + strBaseLocation+"\"+strFileNameOnServer+"</b><br>"+ ex.message    <br />
end try<br />
end if<br />
end sub

Re: Error: Update requires a valid UpdateCommand when passed DataRow collection with modified rows.

Paul Conrad21-Mar-08 8:17