Webmaster Forum / ASP / Database Access / April 2004

the application i'm working on stores user_ids as a session variable.  many
stored procedures throughout the application accept this user_id as a
parameter.  the problem is that often times a user's session will expire
without them knowing it (like if they left their browser open ...

Hi, im running windows 2000 and sql server 2000
I have added a job to my database on a 5 minute run schedule.
The TSQL statement you can find below
DELETE FROM online

Hi Ng,
i'm a nebie to ASP so please be kind  ,-)
I'd like to access (read and write data) from asp on (IIS if this Information is
needed) MS SQLServer 2000 installed Databased.

In evaluating asp and an Access database as a way to
store user data from an Authorware training piece, I ran
across this article:
"For performance and reliability reasons, it is strongly

I have a question for you, it involves IIS and database connections.
When I got hired, we were using an asp include file with database functions
and would open and close the database connection multiple times in 1 script.
Common sense dictated we should only open the connection ...

I am using MS SQL for my ASP application and have several 'comments' fields.
Obviously in these fields users are going to enter invalid characters and
when they try to submit they will receive an error message. How can I deal
with these invalid characters so the information they are ...

My Authorware training piece sends user scores to a
Microsoft Access database through an .asp page.  In
opening the connection to the database, I use this code:
function OpenConn()

The application I have to maintain uses dynamical views. I have the
following code:
  oOrgDbConn.BeginTrans
  DropStr = "DROP VIEW MV_22_"

We upgraded to IIS 6.0 along with Windows Server 2003 and
all of our Access Databases are not working. I believe
the connections are not working because you can open them
in access. These are access XP. Any ideas, We upgraded

I'm gonna ask this in a different way to see if it gets a different
response.
I am building a page that queries two access tables. It is in fact two
quiries in one as I want to do this.

I created a report by access and i would like call this
report bye asp page.
Somebody could help me?
Thanks a lot.

I have an access table with fields including a Memo field. When I try to
update that table using ASP page (using OLEDB for ODBC driver) the record
after the update command is updated alright. But the memo field in the
recordset after updation does not contain the value from the ...

I am receiving the following message in a routine which logs the transaction
before registering a new user. It fails on the open instruction
a.. Error Type:
ADODB.Recordset (0x800A0BB9)

Actually I am new to ASP, I will be thankful so much if anyone could help
I have an Access2000 Database, I have Listing.html that has links to several
ASP Pages, I pass a variable to ASP, And according to variable value I open
the database and get its value

If poss, could you please answer the following queries:
1) Is there any way in Access 2000 that I can get the DB schema out?
Ideally its for point 2 below, but just so that I can print it out to see
what I've created/structured would be nice.