myConnection.Op en() Error

[SOlva]

This is the code that I am running can anyone help me
understand why I get the following error

An unhandled exception of
type 'System.Data.Ol eDb.OleDbExcept ion' occurred in
system.data.dll


' IMport Data and Oledb namespaces
Imports System.Data
Imports System.Data.Ole Db

Public Class Form1
Inherits System.Windows. Forms.Form
Dim myConnection As OleDbConnection = New _
OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;
database = c:\concord.mdb" )
Dim myDataAdapter As New OleDbDataAdapte r()
Dim myDataSet As DataSet = New DataSet()
Private Sub Form1_Load(ByVa l sender As System.Object,
ByVal e As System.EventArg s) Handles MyBase.Load
' Set the SelectCommand properties
myDataAdapter.S electCommand = New OleDbCommand()
myDataAdapter.S electCommand.Co nnection =
myConnection
myDataAdapter.S electCommand.Co mmandText = _
"SELECT CustNum, WorkPhone, Alt Phone,
Firstname, LastName, Address, Address1, City,
StateOrProvince " & _
"FROM customer " & _
"ORDER BY LastName, LastName"
myDataAdapter.S electCommand.Co mmandType =
CommandType.Tex t

' OPen the database connection
myConnection.Op en()
'Now execute the command
myDataAdapter.S electCommand.Ex ecuteNonQuery()
' Fill DataSet object with data
myDataAdapter.F ill(myDataSet, "customers" )

'Close the database connection
myConnection.Cl ose()
' Set the dataGrid properties to bind it to our
data
grdCustomerInfo .DataSource = myDataSet
grdCustomerInfo .DataMember = "customers"
End Sub
End Class

[William Ryan]

Which line is crashing? Verify that the file Exists first... If
File.Exists("C: \concord.mdb") then if it does, make sure you that you have
persmissions to the file and to the database... If you have a username and
password, make sure you include the rest of the connectionstrin g.
http://www.connectionstrings.com . If that doesn't fix it, put a breakpoint
next to your commandtext once it's completed and make sure you can fire it
against Access itself without ADO.NET. If you could tell me where the
exception is being raised, it'd help a lot in diagnosing it.

HTH,

Bill

"SOlva" <an*******@disc ussions.microso ft.com> wrote in message
news:07******** *************** *****@phx.gbl.. .

This is the code that I am running can anyone help me
understand why I get the following error

An unhandled exception of
type 'System.Data.Ol eDb.OleDbExcept ion' occurred in
system.data.dll


' IMport Data and Oledb namespaces
Imports System.Data
Imports System.Data.Ole Db

Public Class Form1
Inherits System.Windows. Forms.Form
Dim myConnection As OleDbConnection = New _
OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;
database = c:\concord.mdb" )
Dim myDataAdapter As New OleDbDataAdapte r()
Dim myDataSet As DataSet = New DataSet()
Private Sub Form1_Load(ByVa l sender As System.Object,
ByVal e As System.EventArg s) Handles MyBase.Load
' Set the SelectCommand properties
myDataAdapter.S electCommand = New OleDbCommand()
myDataAdapter.S electCommand.Co nnection =
myConnection
myDataAdapter.S electCommand.Co mmandText = _
"SELECT CustNum, WorkPhone, Alt Phone,
Firstname, LastName, Address, Address1, City,
StateOrProvince " & _
"FROM customer " & _
"ORDER BY LastName, LastName"
myDataAdapter.S electCommand.Co mmandType =
CommandType.Tex t

' OPen the database connection
myConnection.Op en()
'Now execute the command
myDataAdapter.S electCommand.Ex ecuteNonQuery()
' Fill DataSet object with data
myDataAdapter.F ill(myDataSet, "customers" )

'Close the database connection
myConnection.Cl ose()
' Set the dataGrid properties to bind it to our
data
grdCustomerInfo .DataSource = myDataSet
grdCustomerInfo .DataMember = "customers"
End Sub
End Class

it is happening a t myConnecyion.Op en()

-----Original Message-----
Which line is crashing? Verify that the file Exists first... IfFile.Exists("C :\concord.mdb") then if it does, make sure you that you havepersmissions to the file and to the database... If you have a username andpassword, make sure you include the rest of the connectionstrin g.http://www.connectionstrings.com . If that doesn't fix it, put a breakpointnext to your commandtext once it's completed and make sure you can fire itagainst Access itself without ADO.NET. If you could tell me where theexception is being raised, it'd help a lot in diagnosing it.
HTH,

Bill

"SOlva" <an*******@disc ussions.microso ft.com> wrote in messagenews:07******* *************** ******@phx.gbl. ..

This is the code that I am running can anyone help me
understand why I get the following error

An unhandled exception of
type 'System.Data.Ol eDb.OleDbExcept ion' occurred in
system.data.dll


' IMport Data and Oledb namespaces
Imports System.Data
Imports System.Data.Ole Db

Public Class Form1
Inherits System.Windows. Forms.Form
Dim myConnection As OleDbConnection = New _
OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0; database = c:\concord.mdb" )
Dim myDataAdapter As New OleDbDataAdapte r()
Dim myDataSet As DataSet = New DataSet()
Private Sub Form1_Load(ByVa l sender As System.Object,
ByVal e As System.EventArg s) Handles MyBase.Load
' Set the SelectCommand properties
myDataAdapter.S electCommand = New OleDbCommand()
myDataAdapter.S electCommand.Co nnection =
myConnection
myDataAdapter.S electCommand.Co mmandText = _
"SELECT CustNum, WorkPhone, Alt Phone,
Firstname, LastName, Address, Address1, City,
StateOrProvince " & _
"FROM customer " & _
"ORDER BY LastName, LastName"
myDataAdapter.S electCommand.Co mmandType =
CommandType.Tex t

' OPen the database connection
myConnection.Op en()
'Now execute the command
myDataAdapter.S electCommand.Ex ecuteNonQuery()
' Fill DataSet object with data
myDataAdapter.F ill(myDataSet, "customers" )

'Close the database connection
myConnection.Cl ose()
' Set the dataGrid properties to bind it to our
data
grdCustomerInfo .DataSource = myDataSet
grdCustomerInfo .DataMember = "customers"
End Sub
End Class

.

I got passed that error now it is saying the same thing at
the myDataAdapter.S electCommand.Ex ecuteNonQuery() . Any
ideas I also sent you an email.

-----Original Message-----
Which line is crashing? Verify that the file Exists first... IfFile.Exists("C :\concord.mdb") then if it does, make sure you that you havepersmissions to the file and to the database... If you have a username andpassword, make sure you include the rest of the connectionstrin g.http://www.connectionstrings.com . If that doesn't fix it, put a breakpointnext to your commandtext once it's completed and make sure you can fire itagainst Access itself without ADO.NET. If you could tell me where theexception is being raised, it'd help a lot in diagnosing it.
HTH,

Bill

"SOlva" <an*******@disc ussions.microso ft.com> wrote in messagenews:07******* *************** ******@phx.gbl. ..

This is the code that I am running can anyone help me
understand why I get the following error

An unhandled exception of
type 'System.Data.Ol eDb.OleDbExcept ion' occurred in
system.data.dll


' IMport Data and Oledb namespaces
Imports System.Data
Imports System.Data.Ole Db

Public Class Form1
Inherits System.Windows. Forms.Form
Dim myConnection As OleDbConnection = New _
OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0; database = c:\concord.mdb" )
Dim myDataAdapter As New OleDbDataAdapte r()
Dim myDataSet As DataSet = New DataSet()
Private Sub Form1_Load(ByVa l sender As System.Object,
ByVal e As System.EventArg s) Handles MyBase.Load
' Set the SelectCommand properties
myDataAdapter.S electCommand = New OleDbCommand()
myDataAdapter.S electCommand.Co nnection =
myConnection
myDataAdapter.S electCommand.Co mmandText = _
"SELECT CustNum, WorkPhone, Alt Phone,
Firstname, LastName, Address, Address1, City,
StateOrProvince " & _
"FROM customer " & _
"ORDER BY LastName, LastName"
myDataAdapter.S electCommand.Co mmandType =
CommandType.Tex t

' OPen the database connection
myConnection.Op en()
'Now execute the command
myDataAdapter.S electCommand.Ex ecuteNonQuery()
' Fill DataSet object with data
myDataAdapter.F ill(myDataSet, "customers" )

'Close the database connection
myConnection.Cl ose()
' Set the dataGrid properties to bind it to our
data
grdCustomerInfo .DataSource = myDataSet
grdCustomerInfo .DataMember = "customers"
End Sub
End Class

.

[Cor]

Hi Anonymous,

Why are you using that

the myDataAdapter.S electCommand.Ex ecuteNonQuery() .

I do not understand why you need it

Why not try what happens when you set a ' before it

I hope this helps?

Cor