Problem using dataadapter

[Eric Caron]

Here's my problem,

I try to populate a dataset using a dataadpater. I use ODBC.NET to
access COBOL data with USQL odbc driver. My problem is that my table
has no primary key. Here's my code :

Dim myConnection As New OdbcConnection("DSN=pg_dem;UID=dba;PWD=tom")
Dim myAdapter As New OdbcDataAdapter
Dim mySelectQuery As String = "SELECT no_gl, descript FROM gl_annu
WHERE no_gl='121110000'"
Dim DS As New DataSet
myAdapter.MissingSchemaAction = MissingSchemaAction.Ignore
myAdapter.SelectCommand = New OdbcCommand(mySelectQuery, myConnection)
myAdapter.Fill(DS)

I receive an error message in line : myAdapter.Fill(DS)

I don't know exactly why but it seem that my table required a primary
key if I want to use dataadapter and dataset. But if I use a
datareader, this work great but I must insert, delete and update
table. Do you know exactly why I have this problem and how I can mak
this to work

Thanks very much