?
Solved

ADO Connection Object

Posted on 2002-06-03
12
Medium Priority
?
661 Views
Last Modified: 2013-11-23
When I am closing an ado connection object using the command (conts.close) I get the following error message:

"Unhandled exception in VB6.EXE (MSADO15.DLL):0xC0000005: Access Violation"

The error occurs on some machines, while it does not occur on others.

Please help me out.

Thank You.
0
Comment
Question by:alokanant
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
12 Comments
 
LVL 3

Expert Comment

by:ketapillar
ID: 7052138
Try this where conn1 is you connection object

If conn1.state <> adStateClosed Then conn1.close
Set conn1 = Nothing


0
 
LVL 2

Author Comment

by:alokanant
ID: 7052156
I have checked the status of the connection object, it is adStateOpen before I attempt to close the database.
0
 
LVL 5

Accepted Solution

by:
rpai earned 200 total points
ID: 7052220
Check the Service Pack installed on those machines that comes up with that error message. The access violation errors used to occur when unregistering an ATL DLL or EXE built with a version of Visual C++ prior to 6.0 on a computer with the Visual C++ 6.0 Atl.dll installed. This  was, however, fixed with Service Pack 3. So Service Pack lower than 3 could be a potential cause of the problem.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 2

Author Comment

by:alokanant
ID: 7052282
I have built the application using Visual Studio 6, Service Pack 5.

The PC on which the problem occurs does not have Visual Studio. All the machines on which I am testing the application run on Windows 2000 Service Pack 2.
0
 
LVL 2

Author Comment

by:alokanant
ID: 7052286
I have built the application using Visual Studio 6, Service Pack 5.

The PC on which the problem occurs does not have Visual Studio. All the machines on which I am testing the application run on Windows 2000 Service Pack 2.
0
 

Expert Comment

by:mubashar_iqbal_cs
ID: 7053395
Perhaps u are not cheching the status of ur connection before closing the connection. Try it before closing the connection.
If conts.state <> 1 Then
   conts.close
   set conts = nothing
0
 
LVL 5

Expert Comment

by:rpai
ID: 7053639
Yet another cause could be an incorrect reference. Or
probably an incorrect tear-down of an ActiveX control in your application.

Also, take a look at this article.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q248837

Hope this helps.
0
 
LVL 2

Author Comment

by:alokanant
ID: 7054109
mubashar_iqbal_cs:
I have already checked the status of the connection object.

rpai:
what do you mean by "incorrect tear-down of an ActiveX control". How can I check whether this is happening in my application
0
 
LVL 5

Expert Comment

by:rpai
ID: 7054691
Incorrect reference could be the potential cause.
Maybe the version of ADO.

To check if its your application might be causing this error, you need to code for appropriate error handlers.

On Error Goto ErrHandler
.
.
. 'Your code
.
Exit Function
ErrHandler:
 App.LogNTEvent Err.Description
0
 
LVL 3

Expert Comment

by:PNJ
ID: 7089932
Check MSADO15.DLL, there are several weird versions. The one dated 27/11/2000 works OK (with Vb5 anyway)
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 7851451
Hi alokanant,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept rpai's comment(s) as an answer.
    *** Also, nobody said: Update MDAC on failing computer.

alokanant, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
0
 

Expert Comment

by:SpideyMod
ID: 7912931
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Introducing Priority Question

Increase expert visibility of your issues by participating in Priority Question, our latest feature for Premium and Team Account holders. Adjust the priority of your question to get emergent issues in front of subject-matter experts for help when you need it most.

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 utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses

770 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