|
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
And ever has it been that love knows not its own depth until the hour of separation
|
|
|
|
|
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.
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 )
|
|
|
|
|
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
And ever has it been that love knows not its own depth until the hour of separation
|
|
|
|
|
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.
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 )
|
|
|
|
|
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.
|
|
|
|
|
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
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
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
|
|
|
|
|
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.
Thanks
And ever has it been that love knows not its own depth until the hour of separation
|
|
|
|
|
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.
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 )
|
|
|
|
|
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
|
|
|
|
|
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.
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 )
|
|
|
|
|
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
And ever has it been that love knows not its own depth until the hour of separation
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
<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
|
|
|
|
|
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 ..
|
|
|
|
|
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
|
|
|
|
|
Where is your UPDATE command?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
I'm probably missing it. I thought the update line I put in, which is causing the error, just sent the updated information back to the database. I guess I'm missing a step. Could you or someone show me the code to do this update to the database? Thanks.
|
|
|
|
|
Is there any way to make the gridview column autosize.I mean it the cell contains 100 characters , then the cell should itself adjust the text in one line
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
you can not do this because in any column the records in each row has not fixed size. some contains 5 characters and some contains 55 characters.
so if you want to auto size the columns then your column will be expands more worthless,
for ex: there are 10 rows in grid. 9 columns have 20 characters & 10th column has 90 characters than the layout of grid will not shows in regular manner.
so, instead of these you have to set wrap property to the columns and give some fixed width by approximation of column name.
for column of id there is no need to give size as same as other columns like details column.
|
|
|
|
|
How to pass the parameters of @dbName, @LogicalName, @ToServer
to job dynamically using stored procedure?
|
|
|
|