Deleting info from Database...

jasmine5544 · December 2nd, 2003, 03:31 PM

I have this code I have been working with, however I TOTALLY don't understand the Conn.open part of this. I have tried doing what the book I have says, and peoples suggestions but don't understand what the heck. What am I missing? :(

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>

<%
    Set Conn = Server.CreateObject("ADODB.Connection")
    Conn.Open "tblMain"
    strDelete = "DELETE FROM tblMain WHERE strID = " & Request("strID")
    Conn.Execute(strDelete)
    Conn.Close

%>

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">
Redirecting ... Please Wait
<% 'redirect main page
        response.redirect "admin_main.asp"
%>
<body>
</body>
</html>

Imar · December 2nd, 2003, 03:43 PM

Hi there,

What you're missing is a connection string. You should use the Open method and pass it a connection string, so it knows what database to access. Right now, it looks like you're trying to pass it the name of the table, which is not going to work.

Take a look at the following pages:

http://support.microsoft.com:80/supp...NoWebContent=1

http://msdn.microsoft.com/library/de...asp?frame=true

Once you understand a bit more about how connections work, and how you should pass a connection string to the Open method, take a look here for a more up-to-date connection string (the one mentioned in the first article is out-dated):

http://www.able-consulting.com/MDAC/...orMicrosoftJet

HtH,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.