Solved

Legacy VB6 app - rdoconnection problem

Posted on 2011-03-10
7
511 Views
Last Modified: 2012-05-11
Hi,

 I have the code below

and where this has been working regularly and no (known) changes have been made. Certainly no code changes. Environment changes possibly. Pretty sure no database changes.

For no apparent reason we are getting

Error Number  : 28
Error Message : Application-defined or object-defined
                error
Error Module  : DAL.DataService
Error Routine : OpenCursorlessResultset

Trace         : DAL.Address.Load

Not sure what the SQL string is that is being passed.

Any idea what may suddenly have caused this or how I go about investigating?

TIA

Public Function OpenCursorlessResultset(ByVal sSQL As String) As rdoResultset

On Error GoTo Error_Trap:

    Set OpenCursorlessResultset = m_rdoC.OpenResultset(sSQL, rdOpenForwardOnly, rdConcurReadOnly, rdExecDirect)
    ' Wait till the query has finished
    While OpenCursorlessResultset.StillExecuting
        DoEvents
    Wend
    Exit Function

Error_Trap:
    Call GL_HandleError(Err.Number, Err.Description, MODULE_NAME, "OpenCursorlessResultset")
                
End Function

Open in new window

0
Comment
Question by:Philip Pinnell
[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
  • 4
  • 3
7 Comments
 
LVL 53

Expert Comment

by:Dhaest
ID: 35093347
Is this happening on a machine where it was already running or did you install it on another machine ?
0
 
LVL 13

Author Comment

by:Philip Pinnell
ID: 35093395
Same machine. Though we suspected Windows updates so tried it on another machine that had not had any updates in the period since it last worked and it did the same thing.
0
 
LVL 53

Assisted Solution

by:Dhaest
Dhaest earned 500 total points
ID: 35093419
Did someone install a new version of the MDAC, Office, ... ?
Is the version of the database upgraded ?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 13

Author Comment

by:Philip Pinnell
ID: 35093442
database is ms sql 6.5 and has not been updated

no new versions of MDAC or office AFAIK. That is what I am told.

0
 
LVL 13

Accepted Solution

by:
Philip Pinnell earned 0 total points
ID: 35240731
turned out it was dodgy data. not handled too well
0
 
LVL 53

Expert Comment

by:Dhaest
ID: 35240766
Glad to see that it's solved
0
 
LVL 13

Author Closing Comment

by:Philip Pinnell
ID: 35308367
turned out it was dodgy data. not handled too well
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

734 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