---
title: "'80040e14'"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/108300-80040e14"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "M.Cheraghi"
published: "2004-07-31T23:11:58.000Z"
updated: "2004-08-01T00:36:14.000Z"
replies: 2
views: 266
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/108300-80040e14"
---

# '80040e14'

## #1 — M.Cheraghi, 2004-07-31T23:11Z

> Microsoft OLE DB Provider for ODBC Drivers fel '80040e14' 
> 
> \[MySQL\]\[ODBC 3.51 Driver\]\[mysqld-4.0.20a-nt\]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'strSQL' at line 1 
> 
> /status/profil.asp, rad 6

```
<%
username = request.querystring("username")
strSQL = "SELECT * FROM tblUser WHERE username = '"& username &"'"
SET RS = Conn.execute("strSQL")
%>
```

Har kollat igenom koden 45 gånger, jag börjar bli lite hypnotiserad, kan inte hitta något fel, och mig veterligen använder jag inte något reserverad ord? :OO

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

## #2 — solbulle, 2004-08-01T00:32Z

```
SET RS = Conn.execute(strSQL)
```

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

## #3 — M.Cheraghi, 2004-08-01T00:36Z

> **solbulle skrev:**
>
> ```
> SET RS = Conn.execute(strSQL)
> ```

Jag fäller en tår.

Tack bullen! :)

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/108300-80040e14