Webmaster Forum / ASP / Database Access / September 2006

I have a JS ajax function that calls an ASP page every minute to check
whether a record is free for editing. It is on a PW protected site with a 1
hour timeout. For some reason, when the browser is left open & unused, the
session is not timing out. I'm presuming the ajax call ...

i have a memo field in an access database. the ASP page enters data to this
field just fine.... however the following test (dont ask):
Hello Charlie,
you have no idea who I am but I thought you should know that your wife has

I have a connection string defined in a global.asa file..  Am I
referencing this correctly from this script?
the connection string is defined as application("bureaudb")
<%

We're using SQL-Server2000 as follows...
There is a form at this asp-application where we enter a word with .cz-chars
like this: 'Ohřvače'. All this form, as well as other settings are set to
UTF-8. Output is ok, even in the sql-string we can see the word written

I have an ASP file (shown below) which I call from an HTM page to query a
database table.  It works correctly if I pass it the correct connection
string.  I am trying to make it fail with a proper error message if I change
the UserID value in my connection string to a ...

I am well-versed in Windows Forms but am new to Web Forms with ASP.NET. I  
want to create a simple application that loads all rows of a SQLServer  
table into a DataGrid, then allow the user to filter the rows on-the-fly  
via entry in a TextBox. I have done this in a WinForm ...

how is it possible to show error messages in regards to connection strings?

if i have an ASP page that does INSERT's and SELECT's from an access
database,
what happens if more than 1 web user hits the db at the same time? can it
handle it ok or do i have to do something in my code?

I have a SQL question. If this is the improper board to post this question
on, please let me know where you would suggest I post it.
I have a SALES table with the following schema and structure.
ID      Status     Date

I hate to admit it, but I have never realy used any debugging (not sure
how to actully do it), and now I need to figure out how.  I have a 5MB
access db that I am doing simple stuff with.  it's just a customer db
that I am displaying by a 'date' field.  All has been working well for

hi everyone. i have the following code that pulls a random record from an
access database:
Randomize()
randNum = CInt((oRS.RecordCount - 1) * Rnd)

My web server is running Win2k3 server with IIS 6.0 and all service
packs installed.  the database is on a Windows 2000 Adv. Server machine
running SQL 2000 and all updates installed.
Everything works properly but every 2-6 hours, the web server will

I have a Column in the Table named EMAIL which containd all the email
addresses.
Now I want to create mailto links for the entries of this column.
I used something like this inside the Do while Not objRs.EOF loop.

have an ASP page that generates a random quote from an access db.
i need to include a button that says "next" and when clicked a new quote
should be displayed.
right now theres just a simple <a href> tag that points to the same page.

I am looking for a recommenation on a Database access method (for MS SQL, MSDE), any white paper, some infomation or even some code snipplets  on how to read and write to MS SQL in a pure HTML environment.
Thanks in advance,
Georg
From http://www.developmentnow ...