I'm getting a error when I open my . aspx in my browser... line 34:
da.Fill(ds, "Assets")
Here's the error and my entire code for this .aspx.vb is below
that ...
I need some clues as to what is causing the error... Thanks!!!

Server Error in '/' Application.
---------------------------------------------------------------------------­-----

Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
informatio

Why another thread? You already had one about this...

slinky wrote:

> I'm getting a error when I open my . aspx in my browser... line 34:
> da.Fill(ds, "Assets")
> Here's the error and my entire code for this .aspx.vb is below
> that ...
> I need some clues as to what is causing the error... Thanks!!!
> 


8< snip


>             cmdSelect.CommandText = _
> "SELECT ([Asset Number], Description, [Serial Number], Mfg, AssetType,
> RDCnumber) FROM Assets"


"Description" is a reserved keyword in Access. Put brackets around it.

-- 
Gran Andersson
_____
http://www.guffa.com

On Aug 10, 9:09 pm, slinky  wrote:

> I'm getting a error when I open my . aspx in my browser... line 34:
> da.Fill(ds, "Assets")
> Here's the error and my entire code for this .aspx.vb is below
> that ...
> I need some clues as to what is causing the error... Thanks!!!
>
> Server Error in '/' Application.
> ---------------------------------------------------------------------------­­-----
>
> Multiple-step OLE DB operation generated errors. Check each OLE DB
> status value, if available. No work was done.
> 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: Multiple-step
> OLE
> DB operation generated errors. Check each OLE DB status value, if
> available. No work was done.
>
> Source Error:
>
> Line 32:             da.SelectCommand = cmdSelect
> Line 33:             da.InsertCommand = cmdInsert
> Line 34:             da.Fill(ds, "Assets")
> Line 35:         End If
> Line 36:     End Sub
>
> Source File: E:\kunden\homepages\26\d190091667\Default5.aspx.vb
> Line: 34
>
> Stack Trace:
>
> [OleDbException (0x80040e21): Multiple-step OLE DB operation
> generated
> errors. Check each OLE DB status value, if available. No work was
> done.]
>
> System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString
> constr, DataSourceW