Re: Problem getting sequences under 8.02.03.00 driver

Eric E schrieb:
> Hi all,
>     I installed the 8.02.03.00 driver during my installation of
> Postgres 8.2 onto my machine.  After installation of that driver, the
> following code related to sequences would not work:
[...]
> Where sSequenceName is holding the name of a sequence in the
> search_path visible to the connection.  The problem is that the value
> returned from the ADODB Recordset is always 0.  I can get a sequence
> perfectly well using pgAdmin, and logs of statements showed that the
> driver was in fact executing the SELECT nextval statement.  I can also
> execute other SELECT statements just fine using the Connection and
> Recordset objects.  For some reason, however, sequence values are
> always returned as 0.

Maybe it's because you define the resulting type as text?

I've installed latest ODBC V8.0.2.04.01 and there a similar query works.

    Dim objRstADO As ADODB.Recordset

    Set objRstADO = objConnADO.Execute("SELECT nextval('" &
strSequenceName & "')", , adLockReadOnly)
    debug.print Nz(objRstADO(0), 0)


Is the Login-role in the connectionstring the same as you use in pgAdmin?
Perhaps - ok, not very likely - is your ADO connection just not allowed
to see the sequence.
Depending on your function's error handler there could be a hidden error
condition and the function delivers the default value for numeric types = 0.