Error in access to Oracle.

Error in access to Oracle.

Postby 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)
Guest
 

Postby Alexey » Mon 05 Jun 2006 06:23

You should call
Code: Select all
pruebareader.Read()

method before getting any value from the table.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby mjimenez » Mon 05 Jun 2006 14:08

I work.
Thanks
mjimenez
 
Posts: 6
Joined: Thu 27 Apr 2006 16:22

Postby Alexey » Tue 13 Jun 2006 08:27

You are welcome.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle