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

postgresODBC and Symantec dbAnywhere/Visual Cafe, broken?

From: Matthew Hagerty <matthew(at)wolfepub(dot)com>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: postgresODBC and Symantec dbAnywhere/Visual Cafe, broken?
Date: 1998-08-05 17:16:20
Message-ID: 3.0.1.32.19980805131620.006a496c@wolfepub.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
Greetings,

I'm going to get all these interfaces working if it kills me! ;)

I have dbAnywhere running, I have an ODBC driver for my database
(PostgreSQL) installed and working, and dbAnywhere makes a connection okay.
 The only problem I have is when I try to select a table using a wizard (or
in the recordDefinition->Table Name property, or in the dbNavigator), I get
the following error:

dbAnywhere window:

    Message: [Symantec][dbANYWHERE Server][Version: 1.1a - Build:
219][SQL]Database engine or client library specific error encountered.
    DBMS error code: 1
    DBMS message: Null statement result in SQLFetch.
    Suggestion: Please see the specific database's vendor supplied
manual(s) for further information concerning this error.


>From my ODBC log:

STATEMENT ERROR: func=SQLFetch, desc='', errnum=3, errmsg='Null statement
result in SQLFetch.'
                 ------------------------------------------------------------
                 hdbc=75499644, stmt=75514136, result=0
                 manual_result=1, prepare=0, internal=0
                 bindings=0, bindings_allocated=0
                 parameters=0, parameters_allocated=0
                 statement_type=-2, statement='(null)'
                 stmt_with_params=''
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=1
                 cursor_name=''
                 ----------------QResult Info -------------------------------
CONN ERROR: func=SQLFetch, desc='', errnum=0, errmsg=''
            ------------------------------------------------------------
            henv=76546180, conn=75499644, status=1, num_stmts=16
            sock=76546196, stmts=76546236, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=40, reverse=0, errornumber=0, errormsg='(null)'
            buffer_in=75505936, buffer_out=75510036
            buffer_filled_in=2, buffer_filled_out=0, buffer_read_in=2


Does anyone have any ideas what may be causing this error?  I have tried
changing the ODBC setting to just about everything that makes sense (and
them some that don't).  The only problems with the driver seems to be
viewing tables.

Otherwise, I *am* able to create tables using postgresqlODBC via
dbAnywhere!  Go figure that I can create a table with dbAnywhere via ODBC,
but I can't view a table!?

Any ideas?

Thanks,
Matthew


Responses

pgsql-interfaces by date

Next:From: Peter T MountDate: 1998-08-05 17:30:56
Subject: Re: Postgresql JDBC driver compliance
Previous:From: Matthew HagertyDate: 1998-08-05 17:08:25
Subject: Re: [INTERFACES] JDBC:postgresql and Symantec Visual Cafe

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