Webmaster Forum / ASP / Database Access / August 2007

I apologize if this is a double post. I tried earlier and it didn't
appear to post.
I'm passing data to a stored procedure in SQL Server 2000 and am
having trouble with the date parameters. If I pass a date it works. If

I have a form on a site where users submit some data. I have had a problem
with someone submitting garbage data, I can delete it but would like to stop
it. I started capturing IP addresses using the code below to write the IP to
the access db where the other data goes. I have ...

I want to invoke the Execute method of a Command to obtain a record set, then
reuse that record set twice. A rough code outline appears below. It appears
that the record set return from Command.Execute is non-rewindable, however;
upon attempting the second "MoveFirst" I get this ...

I am trying to retrieve values from a query in a list box. However, it is
giving me no recordset. Although I get recordset when I query this access
database. Any help for resolution on this is appreciated. Thanks
CODE:

I cant run asp.net web application
project.. error is windows authentication is not set..
my os is windowsXP
help me plzzz

Hi, I am currently trying to get back into ASP and have begun looking at an
old webpage I developed some years ago, it was fully functional back in 2002
and I had it up and running with no problems. I have just recently bought a
new PC with Windows Vista Home Premium on it and ...

Hi,
I got stuck with GridView control while binding it from a datatable. As my
requirement is i want to show my grid in "Group By" passion. Suppose i have
feilds like Order,OrderDetails,OrderDate and i want to Group this by

I am making a ASP.NET application that connects to a database.
I want to distrtibute this to my customers that may have different Windows
OS, so my installer must handle different windows versions.
In my installer I am using the following SQL statement to enable ASP.NET to

For the life of me I cannot get the following stored procedure to return a
value in a classic asp vbscript page. Can someone please help a poor soul?
Here is the SP that returns the next order number available for use:
CREATE  PROCEDURE ap_GetOrderNumber2

I have an access database with a field of "OLE Object" that has
bitmaps. I'm trying to output these bitmaps to an ASP page viewed in a
webbrowser.
This is how I'm attempting to do this now:

I am familiar with the SqlCommand object available in .NET (VBScript or C#)
which provides a powerful security feature by using a template in conjunction
with SqlParameters. I have been searching without success to determine
whether classic ASP with VBScript  has something ...

We are moving to SQL2k5 & attempting to utilize mirrored databases. I gave a
connection string to our developers to use in the ASP (classic) pages:
"Provider=SQLNCLI;Server=10.0.0.1;Failover Partner=10.0.0.2;Initial
Catalog=dbName;UID=SQL User Name;Pwd=Password;"

(Further to "24hrs static content".....many thanks)
Currently our web site is pulling all pages from a database, dependent on
querystrings.
I wish to set up different system:

Greetings, folks.
Hoping someone here can give me even a half-informed (or at least
well-argued) opinion on which route to take for better performance (or
indeed if there actually will be any difference) between these two options;