---
title: "Hjälp!!! Databas"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/39022-hjälp-databas"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "Erx"
published: "2002-03-05T16:46:52.000Z"
updated: "2002-03-05T18:05:14.000Z"
replies: 6
views: 277
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/asp/39022-hjälp-databas"
---

# Hjälp!!! Databas

## #1 — Erx, 2002-03-05T16:46Z

Vad är fel?
\<%
Set Connect = Server.CreateObject("ADODB.Connection")
Set RecSet = Server.CreateObject("ADODB.Recordset")
Conn.Open "Driver={Microsoft Access Driver (\*.mdb)}; DBQ="& Server.MapPath("db/users.mdb")
ost = "Select \* From prylz Where ID = '" & Request.Querystring("id") & "'"
RecSet.Open ost, Connect, adOpenStatic, adLockOptimistic
RecSet("klicks") = RecSet("klicks") + 1
RecSet.Update
Response.Redirect RecSet("url")
Conn.Close
Set Conn = nothing
%\>

felmedelande:

Technical Information (for support personnel)

Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/community/prylut.asp, line 14

Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) 

Page:
GET /community/prylut.asp 

Time:
den 5 mars 2002, 17:44:16 

More information:
Microsoft Support

Permalänk: https://www.webforum.nu/p/39022

## #2 — Rinaldo, 2002-03-05T16:49Z

Du har blandat ihop Conn och Connect lite grann.

Så här ska det se ut.

```
<% 
Set Connect = Server.CreateObject("ADODB.Connection") 
Set RecSet = Server.CreateObject("ADODB.Recordset") 
Connect.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="& Server.MapPath("db/users.mdb") 
ost = "Select * From prylz Where ID = '" & Request.Querystring("id") & "'" 
RecSet.Open ost, Connect, adOpenStatic, adLockOptimistic 
RecSet("klicks") = RecSet("klicks") + 1 
RecSet.Update 
Response.Redirect RecSet("url") 
Connect.Close 
Set Connect = nothing 
%>
```

Permalänk: https://www.webforum.nu/p/617061

## #3 — Erx, 2002-03-05T17:52Z

Det funkar inte ändå... samma felmedelande...

Permalänk: https://www.webforum.nu/p/617100

## #4 — Erx, 2002-03-05T17:54Z

Fwlmedelandet skulle vara:
Technical Information (for support personnel)

Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/community/prylut.asp, line 16

Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) 

Page:
GET /community/prylut.asp 

Time:
den 5 mars 2002, 18:52:01 

More information:
Microsoft Support

Permalänk: https://www.webforum.nu/p/617101

## #5 — Rinaldo, 2002-03-05T18:03Z

Och vilken är rad nr 16?

Permalänk: https://www.webforum.nu/p/617102

## #6 — @nders, 2002-03-05T18:03Z

Du använder ado-konstanter när du öppnar ditt recordset. Har du inkluderat adovbs på sidan?

Annars kan du använda siffervärdena direkt. Jag är osäker, men 3 kan vara rätt för både adOpenStatic och adLockOptimistic, men mycket osäker är jag. :)

```
RecSet.Open ost, Connect, 3, 3
```

Mvh,

Permalänk: https://www.webforum.nu/p/617103

## #7 — LarsG, 2002-03-05T18:05Z

Du har inte definierat konstantera adLockOptimistic etc.

```
<% 
Set Connect = Server.CreateObject("ADODB.Connection") 
Set RecSet = Server.CreateObject("ADODB.Recordset") 
Connect.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="& Server.MapPath("db/users.mdb") 
ost = "Select * From prylz Where ID = '" & Request.Querystring("id") & "'" 
RecSet.Open ost, Connect, 3, 3 
RecSet("klicks") = RecSet("klicks") + 1 
RecSet.Update 
Response.Redirect RecSet("url") 
Connect.Close 
Set Connect = nothing 
%>
```

eller ännu bättre är att du struntar i recordset

```
<% 
Set Connect = Server.CreateObject("ADODB.Connection") 
Connect.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="& Server.MapPath("db/users.mdb") 
ost = "update prylz set klicks = klicks + 1 Where ID = '" & Request.Querystring("id") & "'" 
connect.execute ost,,128
Connect.Close 
Set Connect = nothing 
Response.Redirect RecSet("url") 
%>
```

Permalänk: https://www.webforum.nu/p/617104

---

Tråden på webben: https://www.webforum.nu/amne/asp/39022-hjälp-databas