Re: Row Level out of range on 07.02.0005 - Mailing list pgsql-odbc

Thanks a lot Chris, it really did the trick but now we
are having another problem. We are creating the DSN
through programming using SQLConfigDataSource function
using this code

Dim rc As Long
    ' 1=ODBC_ADD_DSN
    rc = SQLConfigDataSource(0, 1, "PostgreSQL", _
                             "DSN=someDSN" & Chr(0) &
_
                             "Servername=someServer" &
Chr(0) & _
                             "Username=someUser" &
Chr(0) & _
                             "Port=5432" & Chr(0) & _
                             "Protocol=6.4" & Chr(0) &
_
                             "ReadOnly=0" & Chr(0) & _
                             "UseDeclareFetch=1" &
Chr(0) & _
                             Chr(0))
    If rc = 0 Then
        MsgBox "Can't create data source"
    Else
        MsgBox "Data source created successfully"
    End If


But when ever i run this code, UseDeclareFetch doesnt
seem to work. This function is unable to set the value
of "Use Declare/Fetch" option of the DSN but if i use
RowVersioning option in above example, it runs
perfectly.



 --- Chris Gamache <cgg007@yahoo.com> wrote: > I don't
use rs.update simply because I find
> accessing the database with
> conn.execute ("UPDATE table SET field=value;")
> yields more predictable results.
> I'm also ONLY dealing with PostgreSQL, so I can
> optimize my SQL statements
> specifically for PostgreSQL.
>
> However, if I wanted to use rs.update I might try
> fiddling around with the
> settings for "Use Declare/Fetch", and "UPDATABLE
> CURSORS". Couldn't hurt,
> right?
>
> CG
>
> --- Muhammad Shariq Muzaffar <shariq77@yahoo.com>
> wrote:
> > hi
> > we are currently using pgsql 7.3.1 on Redhat linux
> > 8.0, and we are developing interface using VB 6.0
> on
> > windows 2000/XP.
> >
> > We are having a problem using the latest psqlodbc
> i.e.
> > ver 07.02.0005. When ever we try to update a
> record
> > using '.update' command of the ADO recordset, ODBC
> > gives us an error of 'ROW VALUE OUT OF RANGE' but
> when
> > we use an older version of psqlodbc i.e. ver
> > 07.01.0009, it runs smoothly.
> >
> > We are using dynamic type of recordsets. Is it an
> > error, bug or do we have to install some other
> patch
> > or something.
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Everything you'll ever need on one web page
> > from News and Sport to Email and Music Charts
> > http://uk.my.yahoo.com
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, more
> http://taxes.yahoo.com/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com