Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Run time error 3219 Invalid Operation

Posted on 2005-04-12
17
Medium Priority
?
696 Views
Last Modified: 2008-01-09
Hi everyone,

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, , _
    "ODBC;DATABASE=theDatabase;UID=user;PWD=password;DSN=informix7")

End If

'''''' 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)














0
Comment
Question by:sabev
  • 9
  • 8
17 Comments
 
LVL 12

Expert Comment

by:gbzhhu
ID: 13763007
Has the machine got correct MDAC versoin installed?
0
 

Author Comment

by:sabev
ID: 13763079
I installed the newest version.  2.8.

0
 
LVL 12

Expert Comment

by:gbzhhu
ID: 13763183
Try using Depends(know as Dependency Walker)
Compile your app exe, run Depends.exe then open your app via depends menu.  it should help you pinpoint if a dll is missing

Depends is part of Visual Studio tools
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:sabev
ID: 13763543
Thanks, I knew there was something like that.  I'll double check all those .dlls and make sure they are registered on the no functioning machine and get back to you.

I may not have access to the users machine for a few hours.



0
 
LVL 12

Expert Comment

by:gbzhhu
ID: 13763660
No probs.  Good luck
0
 

Author Comment

by:sabev
ID: 13763944
Rats....

All the dependencies are there.  I re-registered them just in case.  Still no go.

I ran depends.exe on a working machine, and on the machine that is having problems.  It found the same files in both cases.

0
 
LVL 12

Expert Comment

by:gbzhhu
ID: 13764054
OK,

Try to run RegClean (if you don't have it check download.com) and see if that helps.  This looks pretty much some cooruption either registry or system files
0
 
LVL 12

Expert Comment

by:gbzhhu
ID: 13764114
See this

http://www.registryscan.com/articles/runtime-error-3219.html

Please be careful when dealing with registry.  Backup if you have important data on the PC (I expect you know this already)
0
 

Author Comment

by:sabev
ID: 13764636
Well, I ran RegClean, and the free trial of ErrorNuker. No go.

I think I'm going to go ahead and buy the full version.  It says that it only fixed some of the errors.

0
 

Author Comment

by:sabev
ID: 13764889
The full version did not fix it either.
0
 
LVL 12

Expert Comment

by:gbzhhu
ID: 13770400
I am short of ideas now.  The only other suggestion I have is to try and connect to a different DB on different RDBMS say SQL Server or Oracle as it maybe database related
0
 
LVL 12

Accepted Solution

by:
gbzhhu earned 375 total points
ID: 13770412
Just re-reading the question I see it only happens to one PC.  Where is the database? on each PC or some DB server?.  If it is on a server thgen my last comment is useless
0
 

Author Comment

by:sabev
ID: 13773328
The database is Informix on a UNIX server.

Fun times.

I do get a connection to it.  Just does not like to open the recordset on the one PC.
0
 

Author Comment

by:sabev
ID: 13793616
Problem has been fixed.  The informix connections, and ODBC driver.  Reinstalled a different version of the informix conection, and it works.

Odd, I had tried that before with no luck.
0
 
LVL 12

Expert Comment

by:gbzhhu
ID: 13813557
Nice 1.

I suggest that you close your question saving cleanup staff some trouble.  My suggestion would be to NOT delete the question as it contains some usufel info.  Whether you award the points or ask for a refund is up to you
0
 

Author Comment

by:sabev
ID: 13815033
I'll award the points.  Thanks.  I did get some usefull info as well.

Doug
0
 
LVL 12

Expert Comment

by:gbzhhu
ID: 13815127
Thanks Doug
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question