G
Guest
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????
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????