• Revista PROGRAMAR: Já está disponível a edição #53 da revista programar. Faz já o download aqui!

Sign in to follow this  
Followers 0
Wagner Araujo

vb6 recordset vazio vindo do oracle

1 post in this topic

galera estou usando este codigo

Dim conn2 As New ADODB.Connection

Dim rs As New ADODB.Recordset

conn2.ConnectionString = str 'Provider=MSDAORA.1;Data Source=orabanco;User ID=scott;Password=tiger

conn2.CursorLocation = adUseServer


rs.CursorLocation = adUseServer

rs.CursorType = adOpenDynamic

rs.ActiveConnection = conn2

rs.Open "select * from testes"

'Set rs = conn.Execute("select * from testes", 1, 1)

Set DGRD.DataSource = rs

'aqui ele retorna "The rowset is not bookmarkable."

'fazendo o select na base vem os dados

'se olhar o recordset os dados estão la


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
Followers 0