-----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@xxxxxxxxxxx>
$ 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
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
