BUG #2555: runtime error 80040e21

From: "Jonas Bruhn" <jonas(dot)bruhn(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2555: runtime error 80040e21
Date: 2006-07-28 23:54:23
Message-ID: 200607282354.k6SNsNGD030347@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2555
Logged by: Jonas Bruhn
Email address: jonas(dot)bruhn(at)gmail(dot)com
PostgreSQL version: 8.1.4
Operating system: Windows 2000 Pro
Description: runtime error 80040e21
Details:

I'm using VB6, and trying to update a table. It is all happening on my home
pc with IIS running too. I can download the table to a datagrid, bit I can't
type any text i a textbox and update it whith out the error occuring. Here
is the code and some remarks afterwards:

Private Sub command2_click()

Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset

Set cn = New ADODB.Connection

cn.Open "Provider=PostgreSQL.1;Password=***;User ID=postgres;Data
Source=localhost;Location=***" ';Extended Properties="""

Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.Open "select tilbudspris, materialer from efterkalk", cn,
adOpenKeyset, adLockOptimistic

rs.AddNew
debug here --- rs("tilbudspris").Value = Text1.Text
rs("materialer").Value = Text2.Text
rs.Update

Set rs.ActiveConnection = Nothing
Set rs = Nothing
cn.Close
Set cn = Nothing

End Sub

Remarks:
The columns in the table is set to text.
I've tried to write rs!tilbudspris and rs!materialer.
I've tried to trim(text1.text)
I've tried adopenstatic
I've tried rs.movefirst

I can't recognise where the problem should be, if it isn't a bug.

Best regards

Jonas Bruhn

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Martin Pitt 2006-07-29 10:33:40 Fwd: Bug#380047: libpq-dev: no declaration for pg_encoding_to_char
Previous Message Michael Fuhr 2006-07-28 15:52:31 Re: BUG #2553: Outer join bug