Devart Forums

Posted: **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)

Posted: **Mon 05 Jun 2006 06:23**

You should call

Code: Select all

pruebareader.Read()

method before getting any value from the table.

Posted: **Mon 05 Jun 2006 14:08**

I work.
Thanks

Posted: **Tue 13 Jun 2006 08:27**

You are welcome.

Devart Forums

Error in access to Oracle.

Error in access to Oracle.