Trouble with UPDATE Statement in VB.net
956577Aug 19 2012 — edited Aug 23 2012Hi all,
I have a problem executing an UPDATE Statement in VB.net.
This is my source code:
Dim oDBReader As Oracle.DataAccess.Client.OracleDataReader
Dim oDBConnection As New Oracle.DataAccess.Client.OracleConnection("Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.1)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));User Id=testuser;Password=testuser;")
Dim oDBCommand As New Oracle.DataAccess.Client.OracleCommand("Update DEVS Set BDay = '29.09.1986' WHERE ID = '1A7A5EB2E7A611E1AE04000C29AEA4FB'", oDBConnection)
oDBConnection.Open()
Dim Rows = oDBCommand.ExecuteNonQuery
oDBConnection.Close()
The connection can be successfully established. But the program stays on "Dim Rows = oDBCommand.ExecuteNonQuery" for about 1-2 minutes. After that Visual Studio throws an exception which is explained here:
http://dotnetdud.blogspot.de/2009/01/clr-has-been-unable-to-transition-from.html
But the solution does not work. If I do the steps as explained in the link above, the application hangs "unlimited" (waited 10 minutes and nothing happened).
Executing the statement in the SQL Developer everything works fine... Has anybody an idea?
Br