ADO Recordset

M

MCyn

I am currently opening a recordset using the following code:

Dim dbConn As New ADODB.Connection
Dim rstLiveClaim As ADODB.Recordset

'--- ODBC connection string
dbConn.ConnectionString =
"DSN=cetz;UID=*****;PWD=****;DBQ=WORLD;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;"
& _

"FDL=10;LOB=T;RST=T;GDE=F;FRL=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=0"
'--- Number of seconds before timing out
dbConn.ConnectionTimeout = 0
'--- Make connection to ODBC driver
dbConn.Open

'--- Create a new instance of a recordset
Set rstLiveClaim = New ADODB.Recordset
'--- open connection to Table
rstLiveClaim.Open "table", dbConn, adOpenForwardOnly, , adCmdTable

When I get to writing "rstLiveClaim.Index" and run the code I receive an
error stating provider does not support the necessary interface for Index
functionality.

Can someone please help me with this????
 
A

Aaron Kempf

what kind of database are you using-- Oracle?

do u have the correct drivers installed?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top