problem with .aspx.vb code

[slinky]

I'm working on a problem with a form with 6 textboxes and a submit
button for adding data to an Access database.I changed a few things
and got it down to 1 error!. I have a Sub
Page_Load and a Sub btnAdd:
(It still doesn't like the 'SourceVersion' in the Sub Page_Load).
Also
I viewed the .aspx in the browser and got an error which I posted
complete at the bottom of this post). Thanks for any clues... I'm
almost there!!

Imports System.Data
Imports System.Data.Ole Db
Public Class Default5
Inherits System.Web.UI.P age
Private Sub Page_Load(ByVal sender As System.Object, _
ByVal e As System.EventArg s) Handles MyBase.Load
Dim cnn As OleDbConnection = _
New OleDbConnection ("Data Source=(local); " & _
"Initial Catalog=Assets; Integrated Security=SSPI")
Dim ds As DataSet = New DataSet()
Dim da As OleDbDataAdapte r = New OleDbDataAdapte r()
If IsPostBack Then
Dim cmdSelect As OleDbCommand = _
cnn.CreateComma nd()
cmdSelect.Comma ndType = CommandType.Tex t
cmdSelect.Comma ndText = _
"SELECT (Asset Number, Description, Serial_Number, Mfg, Asset Type,
RDCnumber) FROM Assets"
Dim cmdInsert As OleDbCommand = _
cnn.CreateComma nd()
cmdInsert.Comma ndType = CommandType.Tex t
cmdInsert.Comma ndText = _
"INSERT INTO Assets " & _
"(Asset Number, Description, Serial_Number, Mfg, Asset Type,
RDCnumber) " & _
"VALUES(@Asset_ Number, @Description, @Serial_Number, @Mfg,
@AssetType,
@RDCnumber"
cmdInsert.Param eters.Add("@txt Asset_Number",
OleDbType.Doubl e, 12, "Asset_Numb er")
cmdInsert.Param eters.Add("@txt Description",
OleDbType.WChar , 40, "Descriptio n")
cmdInsert.Param eters.Add("@txt Serial_Number",
OleDbType.WChar , 30, "Serial_Number" )
cmdInsert.Param eters.Add("@txt Mfg", OleDbType.WChar , 30,
"Mfg")
cmdInsert.Param eters.Add("@txt AssetType",
OleDbType.WChar ,
30, "AssetType" )
cmdInsert.Param eters.Add("@txt RDCNumber",
OleDbType.WChar ,
30, "RDCnumber" )
Dim SourceVersion As DataRowVersion
SourceVersion = DataRowVersion. Original
da.SelectComman d = cmdSelect
da.InsertComman d = cmdInsert
da.Fill(ds, "Assets")
End If
End Sub
Private Sub btnAdd_Click( _
ByVal sender As System.Object, _
ByVal e As System.EventArg s) Handles btnAdd.Click
Dim ds As DataSet = New DataSet()
Dim da As OleDbDataAdapte r = New OleDbDataAdapte r()
Dim dr As DataRow = ds.Tables("Asse ts").NewRow()
dr(0) = txtAsset_Number .Text
dr(1) = txtDescription. Text
dr(2) = txtSerial_Numbe r.Text
dr(3) = txtMfg.Text
dr(4) = txtAssetType.Te xt
dr(5) = txtRDCnumber.Te xt
ds.Tables("Asse ts").Rows.Add(d r)
da.Update(ds, "Assets")
End Sub
End Class
_______________ ___________
Server Error in '/' Application.
---------------------------------------------------------------------------*-----
An OLE DB Provider was not specified in the ConnectionStrin g. An
example would be, 'Provider=SQLOL EDB;'.
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.Argument Exception: An OLE DB Provider was
not specified in the ConnectionStrin g. An example would be,
'Provider=SQLOL EDB;'.
Source Error:
Line 5: Private Sub Page_Load(ByVal sender As System.Object, _
Line 6: ByVal e As System.EventArg s) Handles MyBase.Load
Line 7: Dim cnn As OleDbConnection = _
Line 8: New OleDbConnection ("Data Source=(local); " & _
Line 9: "Initial Catalog=Assets; Integrated Security=SSPI")
Source File: E:\kunden\homep ages\26\d190091 667\Default5.as px.vb
Line: 7
Stack Trace:
[ArgumentExcepti on: An OLE DB Provider was not specified in the
ConnectionStrin g. An example would be, 'Provider=SQLOL EDB;'.]
System.Data.Ole Db.OleDbConnect ionString.Valid ateProvider(Str ing
progid) +1044303
System.Data.Ole Db.OleDbConnect ionString.Valid ateConnectionSt ring(String
connectionStrin g) +221
System.Data.Ole Db.OleDbConnect ionString..ctor (String
connectionStrin g, Boolean validate) +271
System.Data.Ole Db.OleDbConnect ionFactory.Crea teConnectionOpt ions(String
connectionStrin g, DbConnectionOpt ions previous) +36
System.Data.Pro viderBase.DbCon nectionFactory. GetConnectionPo olGroup(String
connectionStrin g, DbConnectionPoo lGroupOptions poolOptions,
DbConnectionOpt ions& userConnectionO ptions) +125
System.Data.Ole Db.OleDbConnect ion.ConnectionS tring_Set(Strin g
value) +56
System.Data.Ole Db.OleDbConnect ion.set_Connect ionString(Strin g
value) +4
System.Data.Ole Db.OleDbConnect ion..ctor(Strin g connectionStrin g)
+21
Default5.Page_L oad(Object sender, EventArgs e) in E:\kunden
\homepages\26\d 190091667\Defau lt5.aspx.vb:7
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +99
System.Web.UI.C ontrol.LoadRecu rsive() +47
System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint)
+1061

[Mick Walker]

<snip>

>
Imports System.Data
Imports System.Data.Ole Db
Public Class Default5
Inherits System.Web.UI.P age
Private Sub Page_Load(ByVal sender As System.Object, _
ByVal e As System.EventArg s) Handles MyBase.Load
Dim cnn As OleDbConnection = _
New OleDbConnection ("Data Source=(local); " & _
"Initial Catalog=Assets; Integrated Security=SSPI")
Dim ds As DataSet = New DataSet()

</snip>
Try

Dim cnn As OleDbConnection = New
OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=(local);
Initial Catalog=Assets; Integrated Security=SSPI")

But this still wont work, because as far as I can see, you dont set the
path to the access file anywhere.

[slinky]

The database resides in the App_Data folder on my web provider's
server where my website objects reside. Do I need to put the path to
the URL? Thanks!

>
But this still wont work, because as far as I can see, you dont set the
path to the access file anywhere.

[slinky]

I changed the filepath and was able to get it to have no errors. But
when I ran my .aspx file I got the following error shown below my
code. Is the line "If IsPostBack" an issue? Thanks

Imports System.Data
Imports System.Data.Ole Db
Public Class Default5
Inherits System.Web.UI.P age
Private Sub Page_Load(ByVal sender As System.Object, _
ByVal e As System.EventArg s) Handles MyBase.Load
Dim cnn As OleDbConnection = _
New OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;Data
Source=(www.jug gernautical.com \App_Data\Lowes .mdb);" & _
"Initial Catalog=Assets; Integrated Security=SSPI")
Dim ds As DataSet = New DataSet()
Dim da As OleDbDataAdapte r = New OleDbDataAdapte r()
If IsPostBack Then
Dim cmdSelect As OleDbCommand = _
cnn.CreateComma nd()
cmdSelect.Comma ndType = CommandType.Tex t
cmdSelect.Comma ndText = _
"SELECT (Asset Number, Description, Serial_Number, Mfg, Asset Type,
RDCnumber) FROM Assets"
Dim cmdInsert As OleDbCommand = _
cnn.CreateComma nd()
cmdInsert.Comma ndType = CommandType.Tex t
cmdInsert.Comma ndText = _
"INSERT INTO Assets " & _
"(Asset Number, Description, Serial_Number, Mfg, Asset Type,
RDCnumber) " & _
"VALUES(@Asset_ Number, @Description, @Serial_Number, @Mfg, @AssetType,
@RDCnumber"
cmdInsert.Param eters.Add("@txt Asset_Number",
OleDbType.Doubl e, 12, "Asset_Numb er")
cmdInsert.Param eters.Add("@txt Description",
OleDbType.WChar , 40, "Descriptio n")
cmdInsert.Param eters.Add("@txt Serial_Number",
OleDbType.WChar , 30, "Serial_Number" )
cmdInsert.Param eters.Add("@txt Mfg", OleDbType.WChar , 30,
"Mfg")
cmdInsert.Param eters.Add("@txt AssetType", OleDbType.WChar ,
30, "AssetType" )
cmdInsert.Param eters.Add("@txt RDCNumber", OleDbType.WChar ,
30, "RDCnumber" )
Dim SourceVersion As DataRowVersion
SourceVersion = DataRowVersion. Original
da.SelectComman d = cmdSelect
da.InsertComman d = cmdInsert
da.Fill(ds, "Assets")
End If
End Sub
Private Sub btnAdd_Click( _
ByVal sender As System.Object, _
ByVal e As System.EventArg s) Handles btnAdd.Click
Dim ds As DataSet = New DataSet()
Dim da As OleDbDataAdapte r = New OleDbDataAdapte r()
Dim dr As DataRow = ds.Tables("Asse ts").NewRow()
dr(0) = txtAsset_Number .Text
dr(1) = txtDescription. Text
dr(2) = txtSerial_Numbe r.Text
dr(3) = txtMfg.Text
dr(4) = txtAssetType.Te xt
dr(5) = txtRDCnumber.Te xt
ds.Tables("Asse ts").Rows.Add(d r)
da.Update(ds, "Assets")
End Sub
End Class
_______________ _______________ _______________ _______________ ___
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.Ole Db.OleDbExcepti on: Multiple-step OLE
DB operation generated errors. Check each OLE DB status value, if
available. No work was done.

Source Error:

Line 33: da.SelectComman d = cmdSelect
Line 34: da.InsertComman d = cmdInsert
Line 35: da.Fill(ds, "Assets")
Line 36: End If
Line 37: End Sub

Source File: E:\kunden\homep ages\26\d190091 667\Default5.as px.vb
Line: 35

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.Ole Db.OleDbService sWrapper.GetDat aSource(OleDbCo nnectionString
constr, DataSourceWrapp er& datasrcWrapper) +209

System.Data.Ole Db.OleDbConnect ionInternal..ct or(OleDbConnect ionString
constr, OleDbConnection connection) +118

System.Data.Ole Db.OleDbConnect ionFactory.Crea teConnection(Db ConnectionOptio ns
options, Object poolGroupProvid erInfo, DbConnectionPoo l pool,
DbConnection owningObject) +53

System.Data.Pro viderBase.DbCon nectionFactory. CreateNonPooled Connection(DbCo nnection
owningConnectio n, DbConnectionPoo lGroup poolGroup) +27

System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnectio n) +47

System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry) +105
System.Data.Ole Db.OleDbConnect ion.Open() +37
System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +137
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String
srcTable) +83
Default5.Page_L oad(Object sender, EventArgs e) in E:\kunden
\homepages\26\d 190091667\Defau lt5.aspx.vb:35
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +99
System.Web.UI.C ontrol.LoadRecu rsive() +47
System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint)
+1061
_______________ _______________ _

On Aug 8, 6:09 am, Mick Walker <materiali...@p rivacy.netwrote :

<snip>

Imports System.Data
Imports System.Data.Ole Db
Public Class Default5
Inherits System.Web.UI.P age
Private Sub Page_Load(ByVal sender As System.Object, _
ByVal e As System.EventArg s) Handles MyBase.Load
Dim cnn As OleDbConnection = _
New OleDbConnection ("Data Source=(local); " & _
"Initial Catalog=Assets; Integrated Security=SSPI")
Dim ds As DataSet = New DataSet()

</snip>
Try

Dim cnn As OleDbConnection = New
OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=(local);
Initial Catalog=Assets; Integrated Security=SSPI")

But this still wont work, because as far as I can see, you dont set the
path to the access file anywhere.

[Mick Walker]

slinky wrote:

I changed the filepath and was able to get it to have no errors. But
when I ran my .aspx file I got the following error shown below my
code. Is the line "If IsPostBack" an issue? Thanks

>

Use Server.MapPath or try the reletive path to the data file.

[slinky]

I've used Server.MapPath with reading an XML file into a dataset, but
am unsure how to phrase it for an Access Database. What I used for XML
was:

Using ds As New DataSet()
ds.ReadXml(Serv er.MapPath("blo g.xml"))

So I'm unsure where to go from here. Here's what I'm coming up with
for the Connection for Page_Load:

New OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;Data
Source=(Server. MapPath\App_Dat a\Lowes.mdb);" & _
"Initial Catalog=Assets; Integrated Security=SSPI")

But do I need to do anything in the code for btnADD ?

Private Sub btnAdd_Click( _
ByVal sender As System.Object, _
ByVal e As System.EventArg s) Handles btnAdd.Click
Dim ds As DataSet = New DataSet()
Dim da As OleDbDataAdapte r = New OleDbDataAdapte r()
Dim dr As DataRow = ds.Tables("Asse ts").NewRow()
dr(0) = txtAsset_Number .Text
dr(1) = txtDescription. Text
dr(2) = txtSerial_Numbe r.Text
dr(3) = txtMfg.Text
dr(4) = txtAssetType.Te xt
dr(5) = txtRDCnumber.Te xt
ds.Tables("Asse ts").Rows.Add(d r)
da.Update(ds, "Assets")
End Sub

I get no errors till I view in browser:
Source Error:

Line 33: da.SelectComman d = cmdSelect
Line 34: da.InsertComman d = cmdInsert
Line 35: da.Fill(ds, "Assets")
Line 36: End If
Line 37: End Sub

Line 35 is flagged in the browser as a problem.

On Aug 8, 9:43 am, Mick Walker <materiali...@p rivacy.netwrote :

slinky wrote:

I changed the filepath and was able to get it to have no errors. But
when I ran my .aspx file I got the following error shown below my
code. Is the line "If IsPostBack" an issue? Thanks

Use Server.MapPath or try the reletive path to the data file.

[=?ISO-8859-1?Q?G=F6ran_Andersson?=]

slinky wrote:

I've used Server.MapPath with reading an XML file into a dataset, but
am unsure how to phrase it for an Access Database. What I used for XML
was:

Using ds As New DataSet()
ds.ReadXml(Serv er.MapPath("blo g.xml"))

So I'm unsure where to go from here. Here's what I'm coming up with
for the Connection for Page_Load:

New OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;Data
Source=(Server. MapPath\App_Dat a\Lowes.mdb);" & _
"Initial Catalog=Assets; Integrated Security=SSPI")

Server.MapPath is a method, not a folder. It turns a virtual path into a
physical path, so you supply it with a virtual path. A virtual path uses
/, not \.

Use this to get the physical path to the database file:

Server.MapPath( "~/App_Data/Lowes.mdb")

Concatenate this into the connection string.

But do I need to do anything in the code for btnADD ?

Private Sub btnAdd_Click( _
ByVal sender As System.Object, _
ByVal e As System.EventArg s) Handles btnAdd.Click
Dim ds As DataSet = New DataSet()
Dim da As OleDbDataAdapte r = New OleDbDataAdapte r()
Dim dr As DataRow = ds.Tables("Asse ts").NewRow()
dr(0) = txtAsset_Number .Text
dr(1) = txtDescription. Text
dr(2) = txtSerial_Numbe r.Text
dr(3) = txtMfg.Text
dr(4) = txtAssetType.Te xt
dr(5) = txtRDCnumber.Te xt
ds.Tables("Asse ts").Rows.Add(d r)
da.Update(ds, "Assets")
End Sub

You need to supply a database connection to the DataAdapter, otherwise
it doesn't know what to update.

I get no errors till I view in browser:
Source Error:

Line 33: da.SelectComman d = cmdSelect
Line 34: da.InsertComman d = cmdInsert
Line 35: da.Fill(ds, "Assets")
Line 36: End If
Line 37: End Sub

Line 35 is flagged in the browser as a problem.

What "problem"? You should include the error message.

--
Göran Andersson
_____
http://www.guffa.com

[slinky]

I put this into my doce for the Page_Load and the btnAdd:

Dim cnn As OleDbConnection = _
New OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;Data
Source=Server.M apPath(~/App_Data/Lowes.mdb));" & _
"Initial Catalog=Assets; Integrated Security=SSPI")

I get no errors till I launch the browser and here's the complete
message.
I see below what I believe to be the physical path on my provider's
server:

E:\kunden\homep ages\26\d190091 667\Default5.as px.vb

The actual URL to access my site to the page 'Default5.aspx (not the
module) is:
www.juggernautical.com/default5.aspx

_______________ _______________ _______________ _______________ _______________ _______________ ____

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.Ole Db.OleDbExcepti on: Multiple-step OLE
DB operation generated errors. Check each OLE DB status value, if
available. No work was done.

Source Error:

Line 33: da.SelectComman d = cmdSelect
Line 34: da.InsertComman d = cmdInsert
Line 35: da.Fill(ds, "Assets") <<< This line
is in Red on screen
Line 36: End If
Line 37: End Sub

Source File: E:\kunden\homep ages\26\d190091 667\Default5.as px.vb
Line: 35

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.Ole Db.OleDbService sWrapper.GetDat aSource(OleDbCo nnectionString
constr, DataSourceWrapp er& datasrcWrapper) +209

System.Data.Ole Db.OleDbConnect ionInternal..ct or(OleDbConnect ionString
constr, OleDbConnection connection) +118

System.Data.Ole Db.OleDbConnect ionFactory.Crea teConnection(Db ConnectionOptio ns
options, Object poolGroupProvid erInfo, DbConnectionPoo l pool,
DbConnection owningObject) +53

System.Data.Pro viderBase.DbCon nectionFactory. CreateNonPooled Connection(DbCo nnection
owningConnectio n, DbConnectionPoo lGroup poolGroup) +27

System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnectio n) +47

System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry) +105
System.Data.Ole Db.OleDbConnect ion.Open() +37
System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +137
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String
srcTable) +83
Default5.Page_L oad(Object sender, EventArgs e) in E:\kunden
\homepages\26\d 190091667\Defau lt5.aspx.vb:35
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +99
System.Web.UI.C ontrol.LoadRecu rsive() +47
System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint)
+1061

>
What "problem"? You should include the error message.

--
Göran Andersson
_____http://www.guffa.com- Hide quoted text -

- Show quoted text -

[=?ISO-8859-1?Q?G=F6ran_Andersson?=]

slinky wrote:

I put this into my doce for the Page_Load and the btnAdd:

Dim cnn As OleDbConnection = _
New OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;Data
Source=Server.M apPath(~/App_Data/Lowes.mdb));" & _
"Initial Catalog=Assets; Integrated Security=SSPI")

I get no errors till I launch the browser and here's the complete
message.
I see below what I believe to be the physical path on my provider's
server:

E:\kunden\homep ages\26\d190091 667\Default5.as px.vb

The actual URL to access my site to the page 'Default5.aspx (not the
module) is:
www.juggernautical.com/default5.aspx

_______________ _______________ _______________ _______________ _______________ _______________ ____

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.

Your select query is incorrect. If you have spaces in your field names,
you have to encode the names in brackets.

"SELECT ([Asset Number], Description, Serial_Number, Mfg, [Asset Type],
RDCnumber) FROM Assets"

--
Göran Andersson
_____
http://www.guffa.com

[slinky]

OK I double checked and corrected any incident of misspelling or
brackets missing and corrected those. But still the browser brings up
this: (And I know nothing about
reading a stack)

Also, do I have this syntaxed correctly (ignore the '& _'s as they are
just from reformat on paste)?:

New OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;Data
Source=Server.M apPath(~/App_Data/Lowes.mdb));" & _
"Initial Catalog=Assets; Integrated Security=SSPI")
_______________ _______________ _______________ ______
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.Ole Db.OleDbExcepti on: Multiple-step OLE
DB operation generated errors. Check each OLE DB status value, if
available. No work was done.

Source Error:
Line 33: da.SelectComman d = cmdSelect
Line 34: da.InsertComman d = cmdInsert
Line 35: da.Fill(ds, "Assets")
Line 36: End If
Line 37: End Sub
Source File: E:\kunden\homep ages\26\d190091 667\Default5.as px.vb
Line: 35

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.Ole Db.OleDbService sWrapper.GetDat aSource(OleDbCo nnectionString
constr, DataSourceWrapp er& datasrcWrapper) +209

System.Data.Ole Db.OleDbConnect ionInternal..ct or(OleDbConnect ionString
constr, OleDbConnection connection) +118

System.Data.Ole Db.OleDbConnect ionFactory.Crea teConnection(Db ConnectionOptio ns
options, Object poolGroupProvid erInfo, DbConnectionPoo l pool,
DbConnection owningObject) +53

System.Data.Pro viderBase.DbCon nectionFactory. CreateNonPooled Connection(DbCo nnection
owningConnectio n, DbConnectionPoo lGroup poolGroup) +27

System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnectio n) +47

System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry) +105
System.Data.Ole Db.OleDbConnect ion.Open() +37
System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +137
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String
srcTable) +83
Default5.Page_L oad(Object sender, EventArgs e) in E:\kunden
\homepages\26\d 190091667\Defau lt5.aspx.vb:35
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +99
System.Web.UI.C ontrol.LoadRecu rsive() +47
System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint)
+1061

>
Your select query is incorrect. If you have spaces in your field names,
you have to encode the names in brackets.

"SELECT ([Asset Number], Description, Serial_Number, Mfg, [Asset Type],
RDCnumber) FROM Assets"

--
Göran Andersson
_____http://www.guffa.com- Hide quoted text -

- Show quoted text -