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?
 
Atdhe NuhiuAuthor 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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
DhaestCommented:
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.