Error in access to Oracle.

Guest · Post by **Guest** » Fri 02 Jun 2006 22:23

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)

Alexey · Post by **Alexey** » Mon 05 Jun 2006 06:23

You should call

Code: Select all

pruebareader.Read()

method before getting any value from the table.

mjimenez · Post by **mjimenez** » Mon 05 Jun 2006 14:08

I work.
Thanks

Alexey · Post by **Alexey** » Tue 13 Jun 2006 08:27

You are welcome.