🚀 go-pugleaf

Hi,
I recently downloaded and installed IB6 Open Source.
After installation I checked and tested and all works well.

The problem I have however, is getting data out of a table.

I have made 2 DSN connections with 2 different drivers,
having no success with eirther.

Using VisualBasic 6, and connecting with a DSN created
using the vivgenic driver provided with the download, I
just get the message unexpected error.

Using a connection created from XTG Systems driver
 I get a connection OK, and what appears to be a
recordset extraction, however no data is returned from
the table.

Other local servers installed such as MySQL and SQL7
work well, no problems.

What am I not doing correctly? - any ideas welcomed.

************
'Table named TEST with one int Field.

Dim objConn As New ADODB.Connection
Dim objRS As New ADODB.Recordset
Dim objErr As ADODB.Error

objConn.Open "DSN=IB6GO; UID=SYSDBA; PWD=masterkey"

objRS.Open "SELECT * FROM TEST", objConn, adOpenDynamic, adLockOptimistic

Set DBREC = objRS

While Not DBREC.EOF

    With DBREC
         Text1.Text = DBREC(0)
     DBREC.MoveNext
   End With
Wend

objRS.Close
objConn.Close

***********************

Lew.