Data Access/ASP question

TheMSsForum.com: The Microsoft Software Forum

Dear All

I have created a calendar asp page using vbScript that
loads data from a SQL database. It highlights the date I
have data. Everything works well, however I have one
question about the data access procedure and one about
erasing the array.

I load the data for the current month into an array after
opening a connection with the database and then close the
connection. If the user then selects the next month,
another connection is opened and the values loaded into an
array. Like above the connection is closed. Is this the
best way to approach it when I will have hundreds of users
accessing the SQL Server database at the same time?

Current Month >> Opens connection >> Fills Array >>
Displays results >> Closes Connection.
Next Month >> Opens connection >> Fills Array >> Displays
results >> Closes Connection.

If I create the connection to the database and fill the
array with data in the Header of the HTML page and display
the contents of the array in the Body of the page, where
do I erase the array, or do I even need to?

Thanks again and I appreciate your help.

Alastair MacFarlane
Top

Data Access/ASP question by Alastair

Alastair
Wed Sep 17 06:19:40 CDT 2003

Please ignore this question. It has been posted twice to
the server in error
>-----Original Message-----
>Dear All
>
>I have created a calendar asp page using vbScript that
>loads data from a SQL database. It highlights the date I
>have data. Everything works well, however I have one
>question about the data access procedure and one about
>erasing the array.
>
>I load the data for the current month into an array after
>opening a connection with the database and then close the
>connection. If the user then selects the next month,
>another connection is opened and the values loaded into
an
>array. Like above the connection is closed. Is this the
>best way to approach it when I will have hundreds of
users
>accessing the SQL Server database at the same time?
>
>Current Month >> Opens connection >> Fills Array >>
>Displays results >> Closes Connection.
>Next Month >> Opens connection >> Fills Array >> Displays
>results >> Closes Connection.
>
>If I create the connection to the database and fill the
>array with data in the Header of the HTML page and
display
>the contents of the array in the Body of the page, where
>do I erase the array, or do I even need to?
>
>Thanks again and I appreciate your help.
>
>Alastair MacFarlane
>
>.
>
Top