ODBC Driver Issue (possibly OT - wrong list?) - Mailing list pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I suppose this should really be on the ODBC driver list, but as I spend
so much time sorting through mail already, I'm rather hoping not to
need to subscribe to yet another list for this one issue...

I'm trying to use a commercial handheld sync program called Visual CE
in conjunction with PostgreSQL.  Visual CE works using an ODBC driver
(windows only) and I tried using the one which comes with the
PostgreSQL 8 install package (Windows 2000, btw).

When I try to sync, I get an error message from the ODBC driver.  I
turned on the log file feature; I got the log given toward the end of
this message.

I did note a similar issue mentioned on the ODBC list archives while
searching via google, but the only thing which seemed to be an answer
to the question was to turn on the "Server side prepare" option in the
ODBC driver settings.  I tried this, and it didn't work.  There also
seemed to be mention of a custom driver build out of CVS or something?
Can someone please help with this?

Thank you!


==log dump follows==

Global Options: Version='08.00.0004', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
                 disable_optimizer=1, ksqo=1, unique_index=1,
use_declarefetch=0
                 text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1 NAMEDATALEN=64
                 extra_systable_prefixes='dd_;', conn_settings=''
conn_encoding='OTHER'
conn=18429304, query=' '
conn=18429304, query='select version()'
     [ fetched 1 rows ]
     [ PostgreSQL version string = 'PostgreSQL 7.4.3 on
powerpc-apple-darwin7.5.0, compiled by GCC gcc (GCC) 3.3 20030304
(Apple Computer, Inc. build 1656)' ]
     [ PostgreSQL version number = '7.4' ]
conn=18429304, query='set DateStyle to 'ISO''
conn=18429304, query='set geqo to 'OFF''
conn=18429304, query='set extra_float_digits to 2'
conn=18429304, query='select oid from pg_type where typname='lo''
     [ fetched 0 rows ]
conn=18429304, query='select pg_client_encoding()'
     [ fetched 1 rows ]
     [ Client encoding = 'SQL_ASCII' (code = 0) ]
conn=18429304, query='set client_encoding to 'UTF8''
conn=18429304,
PGAPI_DriverConnect(out)='DSN=ESAInspections;DATABASE=ESAInspections;
SERVER=192.168.0.202;PORT=5432;UID=admin;PWD=xxxxx;ReadOnly=0;
Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;
ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;
MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=1;CommLog=1;
Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;
UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;
ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=0;
DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;
UseServerSidePrepare=1'
conn=18429304, query='select current_schema()'
     [ fetched 1 rows ]
conn=18429304, query='select relname, nspname, relkind from
pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r',
'v') and nspname like 'public' and relname like 'realtors' and relname
!~ '^pg_|^dd_' and n.oid = relnamespace order by nspname, relname'
     [ fetched 1 rows ]
conn=18429304, query='select * from "realtors" where 1=0'
     [ fetched 0 rows ]
conn=18429304, query='select relname, nspname, relkind from
pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r',
'v') and nspname like 'public' and relname like 'SYWARE_SyncInfo' and
relname !~ '^pg_|^dd_' and n.oid = relnamespace order by nspname,
relname'
     [ fetched 0 rows ]
conn=18429304, query='update "realtors" set OID = 0 where OID IS NULL'
conn=18429304, query='update "realtors" set OID = 0 where OID >=
268435456'
conn=18429304, query='select * from "realtors" order by OID'
     [ fetched 1 rows ]
STATEMENT ERROR: func=PGAPI_SetPos, desc='', errnum=10, errmsg='Only
SQL_POSITION/REFRESH is supported for PGAPI_SetPos'

- ------------------------------------------------------------
                  hdbc=18429304, stmt=18457304, result=18456544
                  manual_result=0, prepare=0, internal=0
                  bindings=18450544, bindings_allocated=19
                  parameters=0, parameters_allocated=0
                  statement_type=0, statement='select * from "realtors"
order by OID'
                  stmt_with_params='select * from "realtors" order by
OID'
                  data_at_exec=-1, current_exec_param=-1, put_data=0
                  currTuple=0, current_col=-1, lobj_fd=-1
                  maxRows=0, rowset_size=1, keyset_size=0,
cursor_type=3, scroll_concurrency=1
                  cursor_name='SQL_CUR0119A2D8'
                  ----------------QResult Info
- -------------------------------
                  fields=18457264, manual_tuples=0,
backend_tuples=18460512, tupleField=18460512, conn=18429304
                  fetch_count=0, num_total_rows=1, num_fields=15,
cursor='(NULL)'
                  message='(NULL)', command='SELECT', notice='(NULL)'
                  status=8, inTuples=0
CONN ERROR: func=PGAPI_SetPos, desc='', errnum=0, errmsg='(NULL)'
             ------------------------------------------------------------
             henv=18452864, conn=18429304, status=1, num_stmts=16
             sock=18448744, stmts=18460208, lobj_type=-999
             ---------------- Socket Info -------------------------------
             socket=168, reverse=0, errornumber=0, errormsg='(NULL)'
             buffer_in=18440320, buffer_out=18444424
             buffer_filled_in=576, buffer_filled_out=0,
buffer_read_in=576
conn=18429304, PGAPI_Disconnect


- -----------------------------------------------------------
Frank D. Engel, Jr.  <fde101@fjrhome.net>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten
Son, that whosoever believeth in him should not perish, but have
everlasting life.
$
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFB9po77aqtWrR9cZoRAvFnAJwNMcisDD9Tm5EbxXR0m5oHrTH00QCdGqCH
KA+2/TZbGcyw4oOB06JbhRw=
=znFm
-----END PGP SIGNATURE-----



___________________________________________________________
$0 Web Hosting with up to 120MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com