Webmaster Forum / ASP / Database Access / March 2007

have an SQL DB which clients access via asp pages through the internet, in
the case of a power outage I need to write that data automatically in the
background to a txt file on their local machine, I would imagine it would
involve a script of some kind.

Using MS SQL 7 - I would like to pass the name of the view to use, and
the cities (in a list)
Here's my SP
CREATE PROCEDURE sp_getcategories_CA

the data that i key-in at my ASP become "undefined" in my database. what the
problem n how to solve it?

Hi Gang
I have a small database application where the user can search
different fields.  They select what they want to search on and enter a
value to search on.  For example

Dim strImgId As String = Request.QueryString("id")
Dim cmd As New SqlCommand("select img_data, img_type from imgdisp where id=" & strImgId)
when i am using this i got an error like incorrect syntax near ="
what i have to do?

I get following error when trying to connect to a MDF file of sql server
express 2005 database:
"Microsoft OLE DB Service Components error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB

Hey guys, I need a bit of quick help.  I have a website that I have been working that worked fine while I was working on it on my computer, but I just tried to publish it now to the server and keep getting an error.  Here is the error that I am getting:
Microsoft OLE DB Provider ...

Simple query, ordered by dDateField desc, cCharField asc, nNumericField asc.
Irrespective of whether I have the "ASC" keywords in there, it's behaving as
though the query is specifying DESC on all three order fields.  This seems
pretty basic, but it doesn't work in either IIS6 or ...

Can I use an XML file like I could a database, ie select, insert, update and
delete from it?
If so, how would one do this via standard ASP calls?
If you can't use SQL-style commands how do you use it for storing info?

i'm getting this error when i run my asp app in windows xp.
Server object, ASP 0177 (0x800401F3)
Invalid class string
/cem/reports/AlwaysRequiredSteps.asp, line 9

Hi. We're getting this error from an ASP app on an XP Pro system,
Server object, ASP 0177 (0x800401F3)
Invalid class string
/working_dbase/mathlab.asp, line 158

Need a little help please.  I've got the below to add records to a
table, but I need to learn how to do updates and deletes.
Could someone give me examples of how to update and delete a record
based on the below?

I'm using ASP for a little database application.  I can't figure out a
simple design for warning the user before doing an update or append.  I need
to check for any other existing records with the same (non-key) data as in
the new or updated record.