---
title: "Hittar ej felet."
type: "forum-thread"
url: "https://www.webforum.nu/amne/dotnet/53526-hittar-ej-felet"
topic: ".NET"
topic_url: "https://www.webforum.nu/amne/dotnet"
author: "Dino"
published: "2002-09-17T12:35:16.000Z"
updated: "2002-09-17T16:44:36.000Z"
replies: 2
views: 211
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/dotnet/53526-hittar-ej-felet"
---

# Hittar ej felet.

## #1 — Dino, 2002-09-17T12:35Z

Någon som ser vad som är fel. Har stirrat mig blind.

```
<%@ Page Language="VB" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">

    sub page_load(obj as object, e as eventargs)
        'Skapa koppling
        dim objConn as New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Webbsidor\dot.net\books\aspnet3veckor\data\bank.mdb")
    
        'Öppna kopplingen
        dim objAdapter as New OleDbDataAdapter("SELECT * FROM user", objConn)
    
        'Fyll ett datasetobjekt
        dim objDataSet as New DataSet()
        objAdapter.Fill(objDataSet, "user")
    
        dim objDataview as New DataView(objDataSet.Tables("user"))
    
        'Välj ett dataviewobjekt och bind till serverkontrollen
        MyDataList.DataSource = objDataview
        MyDataList.DataBind()
    end sub

</script>
...
```

Felmeddelande:

```
Syntaxfel i FROM-instruktion. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.OleDb.OleDbException: Syntaxfel i FROM-instruktion.

Source Error: 

Line 13:         'Fyll ett datasetobjekt
Line 14:         dim objDataSet as New DataSet()
Line 15:         objAdapter.Fill(objDataSet, "user")
Line 16:     
Line 17:         dim objDataview as New DataView(objDataSet.Tables("user"))
 
Source File: C:\Webbsidor\dot.net\books\aspnet3veckor\dag8\ovning01_GetDataFromDataBas.aspx    Line: 15 

Stack Trace: 

[OleDbException (0x80040e14): Syntaxfel i FROM-instruktion.]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) +41
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +154
   System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +92
   System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +65
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +112
   System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +57
   System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +5
   System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
   ASP.ovning01_GetDataFromDataBas_aspx.page_load(Object obj, EventArgs e) in C:\Webbsidor\dot.net\books\aspnet3veckor\dag8\ovning01_GetDataFromDataBas.aspx:15
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +29
   System.Web.UI.Page.ProcessRequestMain() +724
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.0.3705.288; ASP.NET Version:1.0.3705.288
```

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

## #2 — juventus1, 2002-09-17T15:33Z

En gissning: user är antagligen reserverat i Access. Prova med \[user\] i din SQL-sats...

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

## #3 — Dino, 2002-09-17T16:44Z

Nu funkar det som det skall.  Tackar. :)

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

---

Tråden på webben: https://www.webforum.nu/amne/dotnet/53526-hittar-ej-felet