Reply to thread

Message

<blockquote data-quote="mveliz" data-source="post: 4758" data-attributes="member: 1957">Hi,I am currently writing a VB .NET application where I am trying to open 1 database, create a select statement and then post the results into another database file using Microsoft Access database 2002.The code seems to stop executing at the statement &quot;cmdJetDB.ExecuteNonQuery()&quot;I am using the following code:Dim conn1 As OleDbConnection = New OleDbConnection(&quot;Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\Sample.mdb&quot;)Dim conn2 As OleDbConnection = New OleDbConnection(&quot;Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\db2.mdb&quot;)conn1.Open()conn2.Open()Dim mySelectQuery As String mySelectQuery = &quot;SELECT Sample.LANE_ADDR, Sample.LANE_DT, Sample.LANE_TM, Sample.LANE_SPEED FROM (Sample) WHERE ((Sample.LANE_ADDR) = '164.909' OR (Sample.LANE_ADDR) = '164.909' AND Sample.LANE_DT BETWEEN #4/4/2003# AND #4/5/2003#)&quot;Dim cmdJetDB As New OleDbCommand(mySelectQuery, conn1)cmdJetDB.ExecuteNonQuery()Dim cmdInsert As StringcmdInsert = &quot;Insert INTO Table1 (Sample.LANE_ADDR, Sample.LANE_TM,Sample.LANE_SPEED) VALUES ('164.909', '00:12:30' , '30' )&quot;Dim cmdJetDB2 As New OleDbCommand(cmdInsert, conn2)cmdJetDB2.ExecuteNonQuery()conn2.Close()conn1.Close()Question: What is it that I am not doing. I opened both connections, stated my two SQL statements, yet it is still not working. I really need to get this application working. I have spent the past 2 days working on this problem. Please Help.........</blockquote>

[QUOTE="mveliz, post: 4758, member: 1957"] Hi, I am currently writing a VB .NET application where I am trying to open 1 database, create a select statement and then post the results into another database file using Microsoft Access database 2002. The code seems to stop executing at the statement "cmdJetDB.ExecuteNonQuery()" I am using the following code: Dim conn1 As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\Sample.mdb") Dim conn2 As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\db2.mdb") conn1.Open() conn2.Open() Dim mySelectQuery As String mySelectQuery = "SELECT Sample.LANE_ADDR, Sample.LANE_DT, Sample.LANE_TM, Sample.LANE_SPEED FROM (Sample) WHERE ((Sample.LANE_ADDR) = '164.909' OR (Sample.LANE_ADDR) = '164.909' AND Sample.LANE_DT BETWEEN #4/4/2003# AND #4/5/2003#)" Dim cmdJetDB As New OleDbCommand(mySelectQuery, conn1) cmdJetDB.ExecuteNonQuery() Dim cmdInsert As String cmdInsert = "Insert INTO Table1 (Sample.LANE_ADDR, Sample.LANE_TM,Sample.LANE_SPEED) VALUES ('164.909', '00:12:30' , '30' )" Dim cmdJetDB2 As New OleDbCommand(cmdInsert, conn2) cmdJetDB2.ExecuteNonQuery() conn2.Close() conn1.Close() Question: What is it that I am not doing. I opened both connections, stated my two SQL statements, yet it is still not working. I really need to get this application working. I have spent the past 2 days working on this problem. Please Help......... [/QUOTE]

Verification