Error -346 using ole driver. Could not update row...

[aco636]

Hi there

As always, any help gratefully received.

I have written a small vb script to update various records in an informix database.
However, when I run my connection.execute(sql) line I receive the following error;
EIX000: 9-346) Could not update a row in the table.

I have checked the sql statement and it works fine in the informix SQL Editor app. I have also tried a few other simple sql statements and these also fail when using the vbs script.

It might be worth noting that I can run select statements from the vb script without a problem.

My main reason for wanting to do this is to slow things down because I need to do several thousand records.

Regards ACO

 

[mberni]

please post more details (code) to allow an analysis of your problem.

 

[aco636]

Hi there

UPDATE TableName SET passwd = 'abcabc', durcode = '', cname = 'Freddy Bloggs', caddr1 = '1 A Nice Road', caddr2 = 'ANYTOWN', caddr3 = 'AB1 2CD', cpostcode = '*COMMENT*', cphone = '01234-5678910-123456', cfax = '', userref = '0000000000' WHERE Serialno = 1234;

Although I dont want to post the actual data, it might be worth noting that some of the comments have '*' in the string

cniFmx.Open "Connection string"

Do Until objTextFile.AtEndOfStream
	
	
	sql = objTextFile.ReadLine
'Get the next sql statement
		
		
		WScript.Sleep(500)
		
		i = i + 1
                'Just test on first 5 to start
		
		If i = 5 Then
		
			Exit Do
		Else
	
	
		rc.Close
		
		cniFmx.BeginTrans	
			
		Set cmd.ActiveConnection = cniFmx

		cmd.CommandText = sql
		cmd.Execute
		
			If cniFmx.Errors.Count <> 0 Then
				
				cn.RollbackTrans
				WScript.Echo cniFmx.Errors.Item(0).Description
				cn.Errors.Clear
				
			End If
			
		cn.CommitTrans
		WScript.Echo " Row: " & i & " - " & Left(sql, 20)
'Just let me see it is doing something
			
		End If
						
	Loop

As you can see, nothing strange here
Regards ACO

 

[mberni]

explanation of informix error 346:

346 Could not update a row in the table.

While the database server was processing an UPDATE, it received an unexpected error. Check the accompanying ISAM error code for more detailed information on the cause. Possible causes include hardware errors and locking conflicts.

i.e. it could be possible, that your db-server ran out of space, extents, etc.

is it possible to update the table using direct sql, i.e. dbaccess ?

Is your "table" really a table or is it possibly a view, which cannot be updated at all?

 

[aco636]

hi there

The sql works fine if using the IBM Informix SQL Editor.
There will be no problem with resourse
Regards ACO

 

[mberni]

hmm, this seems not to be related to informix then. Maybe ask in a vb-forum, if they can help.