Update over ODBC in Progress Database

[NetProggi]

Hi,

in Thread http://www.vbdotnetforums.com/showthread.php?t=4709 I found something like perhaps my problem, but I don´t know what I must change.

I have a .NET 2.0 Program written.
In one Part I make over the Merant 3.6 ODBC Client a connect to a Progress Database.
A Select in the Database will work fine.
But when I try to make a UPDATE Statement, I always will get an ODBC Error 42000 Syntax-Error 7587

What is wrong?

Abfrageparameter_Firma = "'" & TextBox_Firma.Text & "'"
Abfrageparameter_Artikel = "'" & Wert_aus_Haupbild_Indexe & "'"
Aktuallisierungsparameter_Bild = "'" & Mid(Dateiname, InStrRev(Dateiname, "\") + 1) & "'"

Dim Aktuallisierungsabfrage AsNew Odbc.OdbcCommand("UPDATE PUB.S_Artikel SET PUB.S_Artikel.Bild = " & Aktuallisierungsparameter_Bild & " WHERE PUB.S_Artikel.Firma = " & Abfrageparameter_Firma & " AND PUB.S_Artikel.Artikel = " & Abfrageparameter_Artikel, OdbcConnection_PA)

Try
Aktuallisierungsabfrage.ExecuteNonQuery()
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.Critical, "Fehler beim Update aufgetreten...")
ExitTry
EndTry


Who can help me?

 

[zekeman]

I'm new to this but I did read once about congiguring security in the
control panel adm tools. Also there is an event viewer there.

Probably not must help.