Re: Cannot update table with Informix OLE DB Provider

Richard Spitz wrote: > The problem is, there is code! > > As an example, I have the following table: > > create table "verteil".vbtest > ( > satznr smallint not null , > name char(20), > anzahl smallint > ); > revoke all on "verteil".vbtest from "public";> > create unique index "verteil".ix522_1 on "verteil".vbtest (satznr); > > insert into vbtest values (1,"First Row", NULL); > insert into vbtest values (2,"Second Row", NULL); > insert into vbtest values (3,"Third Row", NULL); > insert into vbtest values (4,"Fourth Row", NULL);> > Then I start VB6, open a new project and click on the symbol that looks like > a yellow pie with a handle attached to it. The caption that appears when the > cursor is above it is "Datenansichtsfenster" in German, which translates into > "Data view window" in English. > > Now a window opens that shows the available data links. I have one on the > database with the above test table, which shows when I click on "Tables". > Before that, I have to enter the password for the user id shown. > > The properties of that data link are: > > property value > fIsProjectUnderVCS false > Name Provider=Ifxoledbc.2;Persist Security Info=False;User > ID=xxxxx;Data Source=xxxxx@xxserver;Extended > Properties="";Connect Timeout=10 > Owner xxxxx <same as user id above> > > A double click on the table name "vbtest" will open another window with > the title (translated): Execute table: vbtest > > In this window, I can see a grid with the four rows that are already in the > table. When I click into any of the fields and type something, the arrow > marking the current row changes into a pen, denoting that the current > row is being changed. When I leave that row, an error window pops up > with the message: > > X42000:-201: Syntax error or access violation > > Please note that the user id I entered has all necessary privileges to > connect to the database and manipulate data in the test table. > > I am at my wit's end. I had hoped that I could build a "quick and dirty" > app to update some data in a table without having to code much, but now > I've already spent more time chasing the problem than if I had hand-coded > a program from the beginning. > > Regards, Richard > -- Hallo Richard, I don't have an Informix OLE DB Provider but I reproduced your example and used the Microsoft OLE DB Provider for ODBC Drivers. I used The Informix CLI 2.5 ODBC Drivers for the Connection. Everything worked fine! Mit freundlichen Gr''en Tolis Varnas -- V+K Relational Solutions mailto:tvarnas@compulink.gr Deligiorgi 26 mailto:tvarnas@orbit.de 546 42 Thessaloniki Voice: +30-31-820270 Greece Fax: +30-31-865463