Hi,

I've written a program for Pervasive Version 8 which had been working for the last 2 years, upgraded to Version 9.5 yesterday and the below code returns null or just blank depending on the ADO connection properties and will not return the procedure details.  If I copy this select statement into the control centre and run it, it does returns the procedure content.  I'm at a loss as to what has changed for ODBC interactions now and has anyone else come across this???  I've changed all connection properties and cannot make any change to the result.  See below.

Pervasive V9.5

Visual Basic 6 Service PAck 6.

Windows XP Professional 

Any help would be appreciated!

Barry
 

    Dim ors As ADODB.Recordset
    Set ors = New ADODB.Recordset
    ors.Open "SELECT Xp$Name, Xp$Flags, Xp$Misc FROM X$Proc WHERE Xp$Name = 'del_ST_QtyBreak' ",    pConn, adOpenDynamic, adLockReadOnly
    Debug.Print ors.Fields("Xp$Name").Value
    Debug.Print ors.Fields("Xp$Flags").Value
    Debug.Print ors.Fields("Xp$Misc").Value
    Set ors = Nothing

What is your connection string used for pConn?

Hi,

Its

 pConn.Open "Driver={Pervasive ODBC Client Interface};ServerName=dbserv;dbq=AA"

I've tried clientside and serverside cursors. 

Thanks

Barry