webForumDet fria alternativet

Hittar ej felet.

2 svar · 206 visningar · startad av Dino

DinoMedlem sedan sep. 20011 914 inlägg
#1

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
juventus1Medlem sedan dec. 2000399 inlägg
#2

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

DinoMedlem sedan sep. 20011 914 inlägg
#3

Nu funkar det som det skall. Tackar. :)

128 ms totalt · 3 externa anrop · v20260731065814-full.30151723
0 ms — hämta forumlista (cache)
0 ms — hämta statistik (cache)
124 ms — hämta tråd, inlägg och bilagor (db)