I want to have a variable in wich I will store a date.
this variable should be stored in a DataBase, because I want it to be in all my website pages and I don't want it to be erased after the web host starts over (that marks out application variables).
The real problem here isn't were to store it, cause that's gotta be in a DB (I think), but how to store it.
I don't want to make a whole table with one feild in it only for one row, thats total waste of place on my host.
We have a site running on w2k, IIS5.0. The problem is that the site intermittently stops working and returns the error "Not enough storage is available to complete this
operation.". This is only for ASP pages. HTML pages are served fine. Restarting the services gets the site working for a few minutes.
There is no problem with space on any drives.The size of the paging file seems fine.
The registry size is fine.I have tried everything I can think of. It is not page
specific. Even just renaming a plain html file to a .ASP extension causes the error.
I'm copying an office automation script from NT4 to w2k, and have as far is
can be certain replicated all the settings correct, but at the point where
the word.application object tries to create a new document using a specific
template, I get either this error or one about incorrect file paths.
I've been through dcomconfig, and have tried both interactive and launching
user as the identity for word, but even with all the correct settings from
the kb articles, and setting modify rights to temp and winnt/temp, cannot
get beyond these errors.
This script works fine via the NT4 box its moving off, and the only
difference of any value with the w2k box is that integrated authentication
is being used on the new box.
I am using vb dll in my asp page. In that dll i am creating word documents (its like a mail merge sort of application). But when i call the dll in my asp page it gives me the below error.
Microsoft Word (0x800A175D)
Could not open macro storage.
/welcome/generatedoc.asp, line 57
Code:
a = welcome.GenerateWelcomeLetter (cstr(qry),cstr(template_filename), cstr(save_filename))
I'm developing web surveys where users logon to a web survey and answer up
to about 50 questions, one after the other, shown only one question at a
time. The answers are saved in a database.
A fellow developer and I are discussing when is the best time to save the
answers. We have two approaches in mind:
Approach 1:
After each question is answered, the answer is saved in the database.
Sessions are only used to store the User ID.
Approach 2:
After each question is answered, the answer is saved in a session variable.
When the user has finished the entire survey, all the answers are saved at
once in the database. Also, if the user logs out, or if the session times
out, the answers answered so far are all saved in the database at once.
The amount of actual data sent to the database is the same in both
approaches, but Approach 1 have much more frequent calls to the DB, thus
creating an overhead of opening and closing connections. I'm not sure how
significant that is. On the oter hand, Approach 2 store a lot of data in
sessions. I'm not sure how bad a thing that is.
Which approach is better and for what reasons? I'd be happy to supply more
information if needed.
1) I need to build an admin page that allows me to browse to the file that I
want stored in SQL Server 2000 in an image field, have it uploaded to the
server, and then stored in the db. I see this done all the time, so I don't
think this part is too hard, but I'm not sure how to get the image into the
db.
2) I want to display the image within a web page, so I would want to pull
the image out of the db, place it on my web server in a certain location,
and then reference the file in the HTML. How do I do that?