Please, can help me ...
When trying to access the data base to send the next error:
An unhandled exception of type 'System.InvalidOperationException' occurred in CoreLab.Oracle.dll
Additional information: No data exists for the row/column.
the used lines are:
''prueba a base de datos con Oracle
Dim cnnprueba As OracleConnection
cnnprueba = New OracleConnection
cnnprueba.UserId = "rey_lawson"
cnnprueba.Password = "bmrf5cr6"
cnnprueba.Server = "titan.smrey.net"
cnnprueba.Sid = "pro8"
'cnnprueba.Port = 8080
cnnprueba.Open()
sql = "select * from sm_movil"
Dim com As New OracleCommand(sql, cnnprueba)
Dim pruebareader As OracleDataReader = com.ExecuteReader
TxtMovil.Text = pruebareader.value(0)
TxtModelo.Text = pruebareader.value(1)
TxtModelo.Text = pruebareader.value(3)
Error in access to Oracle.
You should call
method before getting any value from the table.
Code: Select all
pruebareader.Read()