VB -> ODBC -> Oracle 7 = Can't Update ?

Hi folks. Please give me a hand in the following.

The setup is:

    Visual Basic Professional 3.0 - The VISDATA sample app.     Q+E/Intersolv ODBC Pack - Oracle 7 driver     MS-Windows 3.1 / MS-DOS 6.x
    Oracle SQL*Net SPX v1.1.1.5
    Oracle RDBMS for Netware v 7.1.16

The problem we are having is we can query tables and call up the records using the supplied VISDATA program. We are not able to update any data nor can we add new records. We are able to create and drop tables.

The properties for both the database and the any table have "Updateable=True". Only the records have "Updateable=False" for each record.

From what I understand (which is not much for VB), VB obtains these particular properties from either the ODBC driver or some related database driver.

We are able to update values and add records using the MS-Query tool that comes with
Miscrosoft Office.

Any ideas ?

Thanks in advance

Rich Holowczak
Rutgers University
holowcza_at_andromeda.rutgers.edu Received on Wed Sep 28 1994 - 22:46:30 CET