From: | "Stefan Taube" <2004(at)Stefan-Taube(dot)de> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1562: OdbcDataAdapter.Update Fails |
Date: | 2005-03-25 07:47:12 |
Message-ID: | 20050325074712.17D68F0FD4@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1562
Logged by: Stefan Taube
Email address: 2004(at)Stefan-Taube(dot)de
PostgreSQL version: 8.0.1
Operating system: Windows XP Home
Description: OdbcDataAdapter.Update Fails
Details:
Hi,
the Update Command of an OdbcDataAdapter fails with an error saying the
Select command didnt deliver column info. Same code works with DB2, Oracle
and MySQL, so i think its a problem with the PostGre ODBC driver.
Any ideas?
Greetings,
Stefan
SQL:
Create Table Test ( ID INTEGER NOT NULL, DATA_INT INTEGER, primary
key(ID) );
Insert Into Test Values( 1, 4 );
Commit;
C#:
DS = new DataSet();
CO = new OdbcConnection("DSN=POSTGRE;UID=SCOTT;PWD=TIGER");
CO.Open();
DA = new OdbcDataAdapter("Select * from Test Where Id = 1",CO);
new OdbcCommandBuilder(DA);
DA.Fill(DS);
DS.Tables[0].Rows[0]["DATA_INT"] = 5;
DA.Update(DS); // <<-- This fails
CO.Close();
From | Date | Subject | |
---|---|---|---|
Next Message | Dirk Raetzel | 2005-03-25 08:28:58 | BUG #1563: wrong week returnded by date_trunc('week', ...) |
Previous Message | Tom Lane | 2005-03-24 22:40:23 | Re: BUG #1532: typecast problem between arrays of an int8 derived datatype and varchar[] |