LIKE Operator with ODBC & Access is causing pain.
I'm trying to query a table on an Access database using the LIKE operator
with wildcards within a VB app. The technique I usually use is to massage
a 'template' query with Access via 'cut-and-paste'. I am using ADO 2.1, ODBC,
WinNT 4(SP5), VB6 (SP3).
I get the following errors (using Debug.Print) in VB:
SELECT ... FROM ... WHERE Languages LIKE "*COBOL*" ORDER BY ...;
-2147217904 [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
NOTE: The above works perfectly from within Access itself, but not within
Changing " to ' seems to work until I try to access the recordset:
SELECT ... FROM ... WHERE Languages LIKE '*COBOL*' ORDER BY ...;
3021 Either BOF or EOF is True, or the current record has been deleted;
the operation requested by the application requires a current record.
My VB code is as follows:
Dim rsTCCSource As ADODB.Recordset 'Source recordset
'Open a connection
Set cnTCC = New ADODB.Connection
strSQL = ... (the above SQL statements)
'Get the Source recordset - Static & Read Only
Set rsTCCSource = New ADODB.Recordset
rsTCCSource.Open strSQL, cnTCC, adOpenStatic, adLockReadOnly, adCmdText
'ERROR here for SQL(1)
'Loop through the Source recordset
rsTCCSource.MoveFirst 'ERROR here for SQL(2) - no records
Any ideas, suggestions or clues on how to overcome the above problem will
be much appreciated. Thanks - AP.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center