pls advise me. HELP pls...

on the 1st opening of my web page it uses the membership control of asp.net
for logging on. sometimes it takes time to logon and worse is, it will
encounter sql server error. that can be resolved by just restarting that
specific page and it will be alright, it will logon normally. this only issue happens only on the first opening of the logon page.

i have read a certain article and it says there that on the first time
you access the sql server, sometimes the sql server needs a little more
time communicating back and forth.

how can i make my log-on page wait a little longer till it communicates
or finishes communicating to the sql server

im afraid that this may happen once i deploy my web project. i am
expecting over 100 users and they might save to the database all
together. will i encounter problem on this particular

i am using ASP.NET 2.0 and SQLExpress for this project. pls advise me.
BIG THANKS.

Answer this question

pls advise me. HELP pls...

brk
just a question....

my web project is using SQL Express2005 and ASP.NET and C#.
my web hosting company only have MSsql2000. would there beany conflict with regards to my database im sorry if i sound dumb. im a newbie to this.
thanks
xnpa555
can I implement the membership control (provided by ASP.NET) on MSDE i can try migrating from SQLEXxpress to MSDE but im not sure if membership control works on that MSDE. sorry if i really sound dumb. im a newbie.
Kalle B
SQL Express datafile have a different storage structure than the SQL2k files. YOu can't do that. If you want transfer the database to the SQL2k you have to do scripting of the objects to transfer the data to the prior SQL2k5 databases.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
Lusty_Learner
No, you are sure right, but as of my experiences as a developer I would rather rely on the same system (even on the same SP level) than using a more sophisticated version of the database. But you are right that in case you don`t use any other stuff like doing standard DML there should be no problem.

HTH, Jens Suessmeyer.

---
http://www.sqlsever2005.de
--

DragonVic

Jens Suessmeyer wrote:
Hi,

what sort of error do you get s If you are getting a commandTimeout error you can set the commandTimeout property in your application a bit higher to achieve that the command can have a bit more time to execute.

HTH;, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

thanks Jens. that is exactly what i need. thanks a lot man!

andrea loleo
Hi,

what sort of error do you get s If you are getting a commandTimeout error you can set the commandTimeout property in your application a bit higher to achieve that the command can have a bit more time to execute.

HTH;, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
Martin Stein
i am only using one mdf file and my asp.net program just deals with the common add, edit, delete transactions. would these transactions differ from version to version of MSSQL

honestly i did not think there would be a problem coz these transactions are very common. pls correct me if i am wrong.
bongolas
Hi,

if you hosting company only supports MSDE or MSSQL 2000, I would not use SQL Server Express as a basis of development. I would rather use 2000, because you won't have any problem transfering the database from your development pc to the hosting company.

HTH, jens Suessmeyer.

---
http://www.sqlserver2005.de
---
mikeonbike
Hi,

habe a look here:

http://aspnet.4guysfromrolla.com/articles/120705-1.aspx

"Use the ASP.NET SQL Server Registration Tool (aspnet_regsql.exe) command-line tool (use this tool to implement the schema in a SQL Server 2000 or 2005 database) "

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
asmo
i just installed MSDE. i tried attaching my mdf file (created by SQL Express) to the MSDE but i got this error message:

"An error occured when attaching the database"

i attached that mdf file to the SQL Express and i encountered no problem at all. is this the problem you are talking abt Jens do you think i will encounter the same problem with my hosting company

thanks a lot for your time Jens.
pls advise me. HELP pls...

Answer this question