Run time error 3219 Invalid Operation
Posted on 2005-04-12
I have a VB app that queries an informix database, and opens a recordset.
It works fine on all machines but one.
This is a windows 2000 box. It will make the database connection, but when I try to open the recordset, I get 'Runtime error 3219' Invalid operation.
I think that the machine is probably missing a .dll for the recordset object, but I can't figure out which one it is.
Some of the code -
Dim platrec As Recordset
Dim informixcon As Connection
If informixcon Is Nothing Then
Set wrkODBC = CreateWorkspace("NewODBCWorkspace", _
"admin", "", dbUseODBC)
Set informixcon = wrkODBC.OpenConnection("Connection1", _
dbDriverNoPrompt, , _
'''''' This is where it crashes -
Set platrec = informixcon.OpenRecordset( _
"select * from ct_mstr, ct_grantee where ct_mstr.doc_type = 'PLT' and upper(ct_grantee.last_name) like '" & prefix & "%' and ct_mstr.recno = ct_grantee.recno order by ct_grantee.recno", dbOpenSnapshot)