Re: [INTERFACES] postgresODBC and Symantec dbAnywhere/Visual Cafe, broken?

1.   What version of the driver?

2.  Could you activate the CommLog in the drive setup and send the result of a
minimal test.  The log file will be found in C:\psqlodbc.log .

Matthew Hagerty wrote:

> 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