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

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

From: David Hartwig <daveh(at)insightdist(dot)com>
To: Matthew Hagerty <matthew(at)wolfepub(dot)com>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] postgresODBC and Symantec dbAnywhere/Visual Cafe, broken?
Date: 1998-08-05 18:25:02
Message-ID: 35C8A37E.B1F41333@insightdist.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
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




In response to

Responses

pgsql-interfaces by date

Next:From: William McCrackenDate: 1998-08-05 21:09:01
Subject: Accessing PostgreSQL server on linux from windows NT server
Previous:From: Peter T MountDate: 1998-08-05 17:45:12
Subject: Re: [INTERFACES] JDBC:postgresql and Symantec Visual Cafe

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