Received: from post.mail.demon.net (post-20.mail.demon.net [194.217.242.27]) by hub.org (8.9.1/8.9.1) with ESMTP id EAA20067 for ; Thu, 26 Nov 1998 04:56:48 -0500 (EST) (envelope-from dpage@vale-housing.co.uk) Received: from [194.222.32.17] (helo=mail.vale-housing.co.uk) by post.mail.demon.net with esmtp (Exim 2.053 #1) id 0ziyAD-0004jU-00 for pgsql-interfaces@postgresql.org; Thu, 26 Nov 1998 09:56:42 +0000 Received: from pc81 (pc81.vale-housing.co.uk [192.168.1.40]) by mail.vale-housing.co.uk (8.8.7/8.8.7) with SMTP id JAA09970 for ; Thu, 26 Nov 1998 09:55:05 GMT From: "Dave Page" To: Subject: PostODBC/MS ADO Date: Thu, 26 Nov 1998 09:54:55 -0000 Message-ID: <000501be1922$d4292000$2801a8c0@pc81.vale-housing.co.uk> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0006_01BE1922.D4292000" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0 This is a multi-part message in MIME format. ------=_NextPart_000_0006_01BE1922.D4292000 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, This message is mainly intended for Byron (for obvious reasons) but any suggestions would be helpful. I'm starting to use MS ADO under VB6 for the continuing development of pgAdmin to allow the use of some of it's new controls like the DataRepeater. I can create recordsets from the data source quite successfully, but if I try to update them, I invariably get an error along the lines of 'Insufficient base table information for updating or refreshing'. The attached commlog does show a number of conn errors - do I have a setting wrong somewhere or does the driver really not support an option that is required for ADO? On another note Byron, is there any chance of you adding an option to select the old style commlog (single file instead of 1 per session). It's frustrating during development when I have to hunt through the 15 or so files already created in a morning to find the one I want!! Thanks in advance, Dave -- Dave Page, Network & Systems Manager, The Vale Housing Association Ltd. dpage@vale-housing.co.uk http://www.vale-housing.co.uk (Work) http://www.vale-it.demon.co.uk/ (Home of pgAdmin) Beer can be a permanent solution - but only if you have enough of it! ------=_NextPart_000_0006_01BE1922.D4292000 Content-Type: application/octet-stream; name="psqlodbc.log" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="psqlodbc.log" conn=3D97585276, SQLDriverConnect( = in)=3D'DSN=3DpgDev;UID=3Ddpage;PWD=3Dxxxx;', fDriverCompletion=3D0 DSN info: = DSN=3D'pgDev',server=3D'kenny',port=3D'5432',dbase=3D'valesoft',user=3D'd= page',passwd=3D'xxxx' = readonly=3D'0',protocol=3D'',showoid=3D'1',fakeoidindex=3D'1',showsystabl= e=3D'0' conn_settings=3D'' translation_dll=3D'',translation_option=3D'' conn=3D97585276, = SQLDriverConnect(out)=3D'DSN=3DpgDev;DATABASE=3Dvalesoft;SERVER=3Dkenny;P= ORT=3D5432;UID=3Ddpage;PWD=3Dxxxx;READONLY=3D0;PROTOCOL=3D;FAKEOIDINDEX=3D= 1;SHOWOIDCOLUMN=3D1;ROWVERSIONING=3D0;SHOWSYSTEMTABLES=3D0;CONNSETTINGS=3D= ' Global Options: Version=3D'06.40.0001', fetch=3D100, socket=3D4096, = unknown_sizes=3D0, max_varchar_size=3D254, max_longvarchar_size=3D4094 disable_optimizer=3D1, ksqo=3D1, unique_index=3D1, = use_declarefetch=3D0 text_as_longvarchar=3D1, unknowns_as_longvarchar=3D0, = bools_as_char=3D1 extra_systable_prefixes=3D'dd_;', conn_settings=3D'' conn=3D97585276, query=3D' ' conn=3D97585276, query=3D'set DateStyle to 'ISO'' conn=3D97585276, query=3D'set geqo to 'OFF'' conn=3D97585276, query=3D'set ksqo to 'ON'' conn=3D97585276, query=3D'select oid from pg_type where typname=3D'lo'' [ fetched 1 rows ] [ Large Object oid =3D 243424 ] CONN ERROR: func=3DSQLGetInfo, desc=3D'Bad rgbInfoValue', errnum=3D0, = errmsg=3D'' ------------------------------------------------------------ henv=3D98631812, conn=3D97585276, status=3D1, num_stmts=3D16 sock=3D98631828, stmts=3D98631868, lobj_type=3D243424 ---------------- Socket Info ------------------------------- socket=3D400, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D97591568, buffer_out=3D97595668 buffer_filled_in=3D45, buffer_filled_out=3D0, = buffer_read_in=3D44 CONN ERROR: func=3DSQLSetConnectOption, desc=3D'fOption=3D1, = vParam=3D0', errnum=3D5, errmsg=3D'Driver does not support setting this = connect option' ------------------------------------------------------------ henv=3D98631812, conn=3D97585276, status=3D1, num_stmts=3D16 sock=3D98631828, stmts=3D98631868, lobj_type=3D243424 ---------------- Socket Info ------------------------------- socket=3D400, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D97591568, buffer_out=3D97595668 buffer_filled_in=3D45, buffer_filled_out=3D0, = buffer_read_in=3D44 CONN ERROR: func=3DSQLSetConnectOption, desc=3D'fOption=3D0, = vParam=3D0', errnum=3D5, errmsg=3D'Driver does not support setting this = connect option' ------------------------------------------------------------ henv=3D98631812, conn=3D97585276, status=3D1, num_stmts=3D16 sock=3D98631828, stmts=3D98631868, lobj_type=3D243424 ---------------- Socket Info ------------------------------- socket=3D400, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D97591568, buffer_out=3D97595668 buffer_filled_in=3D45, buffer_filled_out=3D0, = buffer_read_in=3D44 CONN ERROR: func=3DSQLGetInfo, desc=3D'Bad rgbInfoValue', errnum=3D5, = errmsg=3D'Driver does not support setting this connect option' ------------------------------------------------------------ henv=3D98631812, conn=3D97585276, status=3D1, num_stmts=3D16 sock=3D98631828, stmts=3D98631868, lobj_type=3D243424 ---------------- Socket Info ------------------------------- socket=3D400, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D97591568, buffer_out=3D97595668 buffer_filled_in=3D45, buffer_filled_out=3D0, = buffer_read_in=3D44 CONN ERROR: func=3DSQLGetConnectOption, desc=3D'fOption=3D108', = errnum=3D5, errmsg=3D'Driver does not support getting this connect = option' ------------------------------------------------------------ henv=3D98631812, conn=3D97585276, status=3D1, num_stmts=3D16 sock=3D98631828, stmts=3D98631868, lobj_type=3D243424 ---------------- Socket Info ------------------------------- socket=3D400, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D97591568, buffer_out=3D97595668 buffer_filled_in=3D45, buffer_filled_out=3D0, = buffer_read_in=3D44 conn=3D97585276, query=3D'select * from ca_alarm' [ fetched 10 rows ] CONN ERROR: func=3DSQLGetInfo, desc=3D'Bad rgbInfoValue', errnum=3D5, = errmsg=3D'Driver does not support getting this connect option' ------------------------------------------------------------ henv=3D98631812, conn=3D97585276, status=3D1, num_stmts=3D16 sock=3D98631828, stmts=3D98631868, lobj_type=3D243424 ---------------- Socket Info ------------------------------- socket=3D400, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D97591568, buffer_out=3D97595668 buffer_filled_in=3D627, buffer_filled_out=3D0, = buffer_read_in=3D626 CONN ERROR: func=3DSQLGetInfo, desc=3D'Bad rgbInfoValue', errnum=3D5, = errmsg=3D'Driver does not support getting this connect option' ------------------------------------------------------------ henv=3D98631812, conn=3D97585276, status=3D1, num_stmts=3D16 sock=3D98631828, stmts=3D98631868, lobj_type=3D243424 ---------------- Socket Info ------------------------------- socket=3D400, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D97591568, buffer_out=3D97595668 buffer_filled_in=3D627, buffer_filled_out=3D0, = buffer_read_in=3D626 CONN ERROR: func=3DSQLGetInfo, desc=3D'Bad rgbInfoValue', errnum=3D5, = errmsg=3D'Driver does not support getting this connect option' ------------------------------------------------------------ henv=3D98631812, conn=3D97585276, status=3D1, num_stmts=3D16 sock=3D98631828, stmts=3D98631868, lobj_type=3D243424 ---------------- Socket Info ------------------------------- socket=3D400, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D97591568, buffer_out=3D97595668 buffer_filled_in=3D627, buffer_filled_out=3D0, = buffer_read_in=3D626 CONN ERROR: func=3DSQLGetInfo, desc=3D'Bad rgbInfoValue', errnum=3D5, = errmsg=3D'Driver does not support getting this connect option' ------------------------------------------------------------ henv=3D98631812, conn=3D97585276, status=3D1, num_stmts=3D16 sock=3D98631828, stmts=3D98631868, lobj_type=3D243424 ---------------- Socket Info ------------------------------- socket=3D400, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D97591568, buffer_out=3D97595668 buffer_filled_in=3D627, buffer_filled_out=3D0, = buffer_read_in=3D626 STATEMENT ERROR: func=3DSQLSetStmtOption, desc=3D'fOption=3D5, = vParam=3D37024', errnum=3D10, errmsg=3D'Driver does not support setting = this statement option' = ------------------------------------------------------------ hdbc=3D97585276, stmt=3D97599768, result=3D98632144 manual_result=3D0, prepare=3D0, internal=3D0 bindings=3D98635412, bindings_allocated=3D11 parameters=3D0, parameters_allocated=3D0 statement_type=3D0, statement=3D'select * from = ca_alarm' stmt_with_params=3D'select * from ca_alarm' data_at_exec=3D-1, current_exec_param=3D-1, = put_data=3D0 currTuple=3D-1, current_col=3D-1, lobj_fd=3D-1 maxRows=3D0, rowset_size=3D1, keyset_size=3D0, = cursor_type=3D0, scroll_concurrency=3D1 cursor_name=3D'SQL_CUR05D14118' ----------------QResult Info = ------------------------------- fields=3D98632204, manual_tuples=3D0, = backend_tuples=3D97665452, tupleField=3D97665452, conn=3D97585276 fetch_count=3D0, fcount=3D10, num_fields=3D11, = cursor=3D'(null)' message=3D'(null)', command=3D'SELECT', = notice=3D'(null)' status=3D8, inTuples=3D0 CONN ERROR: func=3DSQLSetStmtOption, desc=3D'fOption=3D5, = vParam=3D37024', errnum=3D5, errmsg=3D'Driver does not support getting = this connect option' ------------------------------------------------------------ henv=3D98631812, conn=3D97585276, status=3D1, num_stmts=3D16 sock=3D98631828, stmts=3D98631868, lobj_type=3D243424 ---------------- Socket Info ------------------------------- socket=3D400, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D97591568, buffer_out=3D97595668 buffer_filled_in=3D627, buffer_filled_out=3D0, = buffer_read_in=3D626 STATEMENT ERROR: func=3DSQLSetStmtOption, desc=3D'fOption=3D11, = vParam=3D0', errnum=3D10, errmsg=3D'Driver does not support setting this = statement option' = ------------------------------------------------------------ hdbc=3D97585276, stmt=3D97599768, result=3D98632144 manual_result=3D0, prepare=3D0, internal=3D0 bindings=3D98635412, bindings_allocated=3D11 parameters=3D0, parameters_allocated=3D0 statement_type=3D0, statement=3D'select * from = ca_alarm' stmt_with_params=3D'select * from ca_alarm' data_at_exec=3D-1, current_exec_param=3D-1, = put_data=3D0 currTuple=3D-1, current_col=3D-1, lobj_fd=3D-1 maxRows=3D0, rowset_size=3D1, keyset_size=3D0, = cursor_type=3D0, scroll_concurrency=3D1 cursor_name=3D'SQL_CUR05D14118' ----------------QResult Info = ------------------------------- fields=3D98632204, manual_tuples=3D0, = backend_tuples=3D97665452, tupleField=3D97665452, conn=3D97585276 fetch_count=3D0, fcount=3D10, num_fields=3D11, = cursor=3D'(null)' message=3D'(null)', command=3D'SELECT', = notice=3D'(null)' status=3D8, inTuples=3D0 CONN ERROR: func=3DSQLSetStmtOption, desc=3D'fOption=3D11, vParam=3D0', = errnum=3D5, errmsg=3D'Driver does not support getting this connect = option' ------------------------------------------------------------ henv=3D98631812, conn=3D97585276, status=3D1, num_stmts=3D16 sock=3D98631828, stmts=3D98631868, lobj_type=3D243424 ---------------- Socket Info ------------------------------- socket=3D400, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D97591568, buffer_out=3D97595668 buffer_filled_in=3D627, buffer_filled_out=3D0, = buffer_read_in=3D626 CONN ERROR: func=3DSQLGetInfo, desc=3D'Bad rgbInfoValue', errnum=3D5, = errmsg=3D'Driver does not support getting this connect option' ------------------------------------------------------------ henv=3D98631812, conn=3D97585276, status=3D1, num_stmts=3D16 sock=3D98631828, stmts=3D98631868, lobj_type=3D243424 ---------------- Socket Info ------------------------------- socket=3D400, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D97591568, buffer_out=3D97595668 buffer_filled_in=3D627, buffer_filled_out=3D0, = buffer_read_in=3D626 CONN ERROR: func=3DSQLGetInfo, desc=3D'Bad rgbInfoValue', errnum=3D5, = errmsg=3D'Driver does not support getting this connect option' ------------------------------------------------------------ henv=3D98631812, conn=3D97585276, status=3D1, num_stmts=3D16 sock=3D98631828, stmts=3D98631868, lobj_type=3D243424 ---------------- Socket Info ------------------------------- socket=3D400, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D97591568, buffer_out=3D97595668 buffer_filled_in=3D627, buffer_filled_out=3D0, = buffer_read_in=3D626 CONN ERROR: func=3DSQLGetInfo, desc=3D'Bad rgbInfoValue', errnum=3D5, = errmsg=3D'Driver does not support getting this connect option' ------------------------------------------------------------ henv=3D98631812, conn=3D97585276, status=3D1, num_stmts=3D16 sock=3D98631828, stmts=3D98631868, lobj_type=3D243424 ---------------- Socket Info ------------------------------- socket=3D400, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D97591568, buffer_out=3D97595668 buffer_filled_in=3D627, buffer_filled_out=3D0, = buffer_read_in=3D626 CONN ERROR: func=3DSQLGetInfo, desc=3D'Bad rgbInfoValue', errnum=3D5, = errmsg=3D'Driver does not support getting this connect option' ------------------------------------------------------------ henv=3D98631812, conn=3D97585276, status=3D1, num_stmts=3D16 sock=3D98631828, stmts=3D98631868, lobj_type=3D243424 ---------------- Socket Info ------------------------------- socket=3D400, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D97591568, buffer_out=3D97595668 buffer_filled_in=3D627, buffer_filled_out=3D0, = buffer_read_in=3D626 conn=3D97585276, SQLDisconnect ------=_NextPart_000_0006_01BE1922.D4292000--