Skip site navigation (1) Skip section navigation (2)

Re: : Strange things with VB6 in adUseServer mode

From: Thomas Chabaud <tc(at)geosys(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: : Strange things with VB6 in adUseServer mode
Date: 2005-11-15 08:47:37
Message-ID: 4379A0A9.1070001@geosys.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Thomas Chabaud a écrit :
> Hello.
> 
> I'm using PostgreSQL ODBC Driver v08.01.0100 with Visual Basic 6
> applications.
> When I try an AddNew on a recordset with the following code :
> 
> Dim rs As ADODB.Recordset
> Set rs = New ADODB.Recordset
> rs.Open "tRepertoiresParcellaires", dbConn,adOpenKeyset, _
> adLockPessimistic, adCmdTableDirect
> 
> rs.AddNew
> rs("myfield").value = "myvalue"
> 
> I have always the same error :
> "-2147467259 Error while executing the query;
> ERROR:  null value in column "mycolumn" violates not-null constraint"
> 
> [...]

I solve the problem by using adCmdTable, it seems to work in this mode.

Thomas


In response to

pgsql-odbc by date

Next:From: noreplyDate: 2005-11-15 09:48:34
Subject: [ psqlodbc-Bugs-1000416 ] Tables not shown when linking from Access to the server. Prior drivers worked.
Previous:From: Claus ScherschelDate: 2005-11-15 08:47:34
Subject: Re: Invisible tables in Access 2000

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group