Legacy VB6 app - rdoconnection problem

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

LVL 13
Atdhe NuhiuAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Atdhe NuhiuConnect With a Mentor Author Commented:
turned out it was dodgy data. not handled too well
0
 
DhaestCommented:
Is this happening on a machine where it was already running or did you install it on another machine ?
0
 
Atdhe NuhiuAuthor Commented:
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
DhaestConnect With a Mentor Commented:
Did someone install a new version of the MDAC, Office, ... ?
Is the version of the database upgraded ?
0
 
Atdhe NuhiuAuthor Commented:
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
 
DhaestCommented:
Glad to see that it's solved
0
 
Atdhe NuhiuAuthor Commented:
turned out it was dodgy data. not handled too well
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.