Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA50834; Fri, 21 Jan 2000 04:32:24 -0500 (EST) (envelope-from jose@sferacarta.com) Received: from proxy.sferacarta.com (sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.9.3/8.9.3/NETTuno 4.1) with ESMTP id KAA12383; Fri, 21 Jan 2000 10:32:22 +0100 (MET) Received: from rosso.sferacarta.com (sferacarta.com) [10.20.30.5] by proxy.sferacarta.com with esmtp (Exim 2.05 #1 (Debian)) id 12BanL-0000Tt-00; Fri, 21 Jan 2000 09:55:55 +0000 Message-ID: <38881FC3.D34B1BEC@sferacarta.com> Date: Fri, 21 Jan 2000 09:58:43 +0100 From: Jose Soares X-Mailer: Mozilla 4.6 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: interfaces , hackers Subject: Re: ODBC drive strange behavior References: <38881F35.CAA49A56@sferacarta.com> Content-Type: multipart/mixed; boundary="------------4C67C5F375F657E37C344777" This is a multi-part message in MIME format. --------------4C67C5F375F657E37C344777 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Sorry I forgot to send the attachement :) Jose Soares wrote: > Please help! > > The PSQLODBC aborts a transaction with a strange error while execute a > legal query. > The message is: > > "Could not begin a transaction; unexpected protocol character from > backend (sen_query) (#1)" > > I tried the same query with psql client and it works with no problems. > > Does anyone know what this message means ? > > My configuration: > > Data base server: PostgreSQL v6.5.2 > OS server: Linux 2.0.37 (Debian) > Win Client: M$_Access95 > PsqlODBC v6.40.0006 > log file attached. > > Any help would be very apreciated. > > José --------------4C67C5F375F657E37C344777 Content-Type: application/x-unknown-content-type-txtfile; name="LOG_ERROR.log" Content-Transfer-Encoding: base64 Content-Disposition: inline; filename="LOG_ERROR.log" PERFTEVURUQ+DQpjb25uPTEyODk1MDU0NCwgcXVlcnk9J0JFR0lOJw0KY29ubj0xMjg5NTA1 NDQsIHF1ZXJ5PSdkZWNsYXJlIFNRTF9DVVIwN0IwNTY5OCBjdXJzb3IgZm9yIFNFTEVDVCAi Y29kaWNlX2Zpc2NhbGUiICBGUk9NICJ1dGVudGkiIFdIRVJFIE5PVCgoImNvZGljZV9maXNj YWxlIiA9ICJhemllbmRhIiApICkgR1JPVVAgQlkgImNvZGljZV9maXNjYWxlIiAgSEFWSU5H IChDT1VOVCgiY29kaWNlX2Zpc2NhbGUiICkgID4gMSApICcNCmNvbm49MTI4OTUwNTQ0LCBx dWVyeT0nZmV0Y2ggMTAwIGluIFNRTF9DVVIwN0IwNTY5OCcNCiAgICBbIGZldGNoZWQgMCBy b3dzIF0NCmNvbm49MTI4OTUwNTQ0LCBxdWVyeT0nY2xvc2UgU1FMX0NVUjA3QjA1Njk4Jw0K Y29ubj0xMjg5NTA1NDQsIHF1ZXJ5PSdFTkQnDQpjb25uPTEyODk1MDU0NCwgcXVlcnk9J0JF R0lOJw0KY29ubj0xMjg5NTA1NDQsIHF1ZXJ5PScoU0VMRUNUICJmaWd1cmUiLiJhemllbmRh IiAsImZpZ3VyZSIuImNvZGljZV9maWd1cmEiICwidXRlbnRpIi4icmFnaW9uZV9zb2NpYWxl IiAsInV0ZW50aSIuImlzdGF0IiAsInV0ZW50aSIuImNhcCIgLCJ1dGVudGkiLiJpbmRpcml6 em8iICwidXRlbnRpIi4iY2l2aWNvIiAsImZpZ3VyZSIuInRpcG8iICwidXRlbnRpIi4iY29k aWNlX2Zpc2NhbGUiICwidXRlbnRpIi4icGFydGl0YV9pdmEiICwiZmlndXJlIi4iZmluZV9h dHRpdml0YSIgLCJmaWd1cmUiLiJkYXRhX2VzcG9ydGF6aW9uZSIgLCJmaWd1cmUiLiJkYXRh X2FnZ2lvcm5hbWVudG8iICwidXRlbnRpIi4iZGlzdHJldHRvIiAsImZpZ3VyZSIuImdydXBw byIgLCJmaWd1cmUiLiJkYXRhX2VzcG9ydGF6aW9uZSIgLCJ1dGVudGkiLiJkYXRhX2VzcG9y dGF6aW9uZSIgIEZST00gImZpZ3VyZSIsInV0ZW50aSIgV0hFUkUgKCgiZmlndXJlIi4idGlw byIgSU4gKCdEJyAsJ0RCJyAsJ0RPJyAsJ0RTJyApICkgQU5EICgiZmlndXJlIi4iY29kaWNl X2ZpZ3VyYSIgPSAidXRlbnRpIi4iYXppZW5kYSIgKSApICkgVU5JT04gQUxMIChTRUxFQ1Qg ImZpZ3VyZSIuImF6aWVuZGEiICwiZmlndXJlIi4iY29kaWNlX2ZpZ3VyYSIgLCJ1dGVudGki LiJyYWdpb25lX3NvY2lhbGUiICwidXRlbnRpIi4iaXN0YXQiICwidXRlbnRpIi4iY2FwIiAs InV0ZW50aSIuImluZGlyaXp6byIgLCJ1dGVudGkiLiJjaXZpY28iICwiZmlndXJlIi4idGlw byIgLCJ1dGVudGkiLiJjb2RpY2VfZmlzY2FsZSIgLCJ1dGVudGkiLiJwYXJ0aXRhX2l2YSIg LCJmaWd1cmUiLiJmaW5lX2F0dGl2aXRhIiAsImZpZ3VyZSIuImRhdGFfZXNwb3J0YXppb25l IiAsImZpZ3VyZSIuImRhdGFfYWdnaW9ybmFtZW50byIgLCJ1dGVudGkiLiJkaXN0cmV0dG8i ICwiZmlndXJlIi4iZ3J1cHBvIiAsImZpZ3VyZSIuImRhdGFfZXNwb3J0YXppb25lIiAsInV0 ZW50aSIuImRhdGFfZXNwb3J0YXppb25lIiAgRlJPTSAiZmlndXJlIiwidXRlbnRpIiBXSEVS RSAoKCJmaWd1cmUiLiJ0aXBvIiBJTiAoJ1AnICwnUEInICwnUE8nICwnUFMnICwnQScgKSAp IEFORCAoImZpZ3VyZSIuImNvZGljZV9maWd1cmEiID0gInV0ZW50aSIuImF6aWVuZGEiICkg KSApJw0KY29ubj0xMjg5NTA1NDQsIHF1ZXJ5PSdBQk9SVCcNClNUQVRFTUVOVCBFUlJPUjog ZnVuYz1TQ19leGVjdXRlLCBkZXNjPScnLCBlcnJudW09MSwgZXJybXNnPSdFcnJvciB3aGls ZSBleGVjdXRpbmcgdGhlIHF1ZXJ5Jw0KICAgICAgICAgICAgICAgICAtLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAgICAg ICAgICAgICAgICAgaGRiYz0xMjg5NTA1NDQsIHN0bXQ9MTI4OTk3MDE2LCByZXN1bHQ9MA0K ICAgICAgICAgICAgICAgICBtYW51YWxfcmVzdWx0PTAsIHByZXBhcmU9MCwgaW50ZXJuYWw9 MA0KICAgICAgICAgICAgICAgICBiaW5kaW5ncz0wLCBiaW5kaW5nc19hbGxvY2F0ZWQ9MA0K ICAgICAgICAgICAgICAgICBwYXJhbWV0ZXJzPTAsIHBhcmFtZXRlcnNfYWxsb2NhdGVkPTAN CiAgICAgICAgICAgICAgICAgc3RhdGVtZW50X3R5cGU9LTEsIHN0YXRlbWVudD0nKFNFTEVD VCAiZmlndXJlIi4iYXppZW5kYSIgLCJmaWd1cmUiLiJjb2RpY2VfZmlndXJhIiAsInV0ZW50 aSIuInJhZ2lvbmVfc29jaWFsZSIgLCJ1dGVudGkiLiJpc3RhdCIgLCJ1dGVudGkiLiJjYXAi ICwidXRlbnRpIi4iaW5kaXJpenpvIiAsInV0ZW50aSIuImNpdmljbyIgLCJmaWd1cmUiLiJ0 aXBvIiAsInV0ZW50aSIuImNvZGljZV9maXNjYWxlIiAsInV0ZW50aSIuInBhcnRpdGFfaXZh IiAsImZpZ3VyZSIuImZpbmVfYXR0aXZpdGEiICwiZmlndXJlIi4iZGF0YV9lc3BvcnRhemlv bmUiICwiZmlndXJlIi4iZGF0YV9hZ2dpb3JuYW1lbnRvIiAsInV0ZW50aSIuImRpc3RyZXR0 byIgLCJmaWd1cmUiLiJncnVwcG8iICwiZmlndXJlIi4iZGF0YV9lc3BvcnRhemlvbmUiICwi dXRlbnRpIi4iZGF0YV9lc3BvcnRhemlvbmUiICBGUk9NICJmaWd1cmUiLCJ1dGVudGkiIFdI RVJFICgoImZpZ3VyZSIuInRpcG8iIElOICgnRCcgLCdEQicgLCdETycgLCdEUycgKSApIEFO RCAoImZpZ3VyZSIuImNvZGljZV9maWd1cmEiID0gInV0ZW50aSIuImF6aWVuZGEiICkgKSAp IFVOSU9OIEFMTCAoU0VMRUNUICJmaWd1cmUiLiJhemllbmRhIiAsImZpZ3VyZSIuImNvZGlj ZV9maWd1cmEiICwidXRlbnRpIi4icmFnaW9uZV9zb2NpYWxlIiAsInV0ZW50aSIuImlzdGF0 IiAsInV0ZW50aSIuImNhcCIgLCJ1dGVudGkiLiJpbmRpcml6em8iICwidXRlbnRpIi4iY2l2 aWNvIiAsImZpZ3VyZSIuInRpcG8iICwidXRlbnRpIi4iY29kaWNlX2Zpc2NhbGUiICwidXRl bnRpIi4icGFydGl0YV9pdmEiICwiZmlndXJlIi4iZmluZV9hdHRpdml0YSIgLCJmaWd1cmUi LiJkYXRhX2VzcG9ydGF6aW9uZSIgLCJmaWd1cmUiLiJkYXRhX2FnZ2lvcm5hbWVudG8iICwi dXRlbnRpIi4iZGlzdHJldHRvIiAsImZpZ3VyZSIuImdydXBwbyIgLCJmaWd1cmUiLiJkYXRh X2VzcG9ydGF6aW9uZSIgLCJ1dGVudGkiLiJkYXRhX2VzcG9ydGF6aW9uZSIgIEZST00gImZp Z3VyZSIsInV0ZW50aSIgV0hFUkUgKCgiZmlndXJlIi4idGlwbyIgSU4gKCdQJyAsJ1BCJyAs J1BPJyAsJ1BTJyAsJ0EnICkgKSBBTkQgKCJmaWd1cmUiLiJjb2RpY2VfZmlndXJhIiA9ICJ1 dGVudGkiLiJhemllbmRhIiApICkgKScNCiAgICAgICAgICAgICAgICAgc3RtdF93aXRoX3Bh cmFtcz0nKFNFTEVDVCAiZmlndXJlIi4iYXppZW5kYSIgLCJmaWd1cmUiLiJjb2RpY2VfZmln dXJhIiAsInV0ZW50aSIuInJhZ2lvbmVfc29jaWFsZSIgLCJ1dGVudGkiLiJpc3RhdCIgLCJ1 dGVudGkiLiJjYXAiICwidXRlbnRpIi4iaW5kaXJpenpvIiAsInV0ZW50aSIuImNpdmljbyIg LCJmaWd1cmUiLiJ0aXBvIiAsInV0ZW50aSIuImNvZGljZV9maXNjYWxlIiAsInV0ZW50aSIu InBhcnRpdGFfaXZhIiAsImZpZ3VyZSIuImZpbmVfYXR0aXZpdGEiICwiZmlndXJlIi4iZGF0 YV9lc3BvcnRhemlvbmUiICwiZmlndXJlIi4iZGF0YV9hZ2dpb3JuYW1lbnRvIiAsInV0ZW50 aSIuImRpc3RyZXR0byIgLCJmaWd1cmUiLiJncnVwcG8iICwiZmlndXJlIi4iZGF0YV9lc3Bv cnRhemlvbmUiICwidXRlbnRpIi4iZGF0YV9lc3BvcnRhemlvbmUiICBGUk9NICJmaWd1cmUi LCJ1dGVudGkiIFdIRVJFICgoImZpZ3VyZSIuInRpcG8iIElOICgnRCcgLCdEQicgLCdETycg LCdEUycgKSApIEFORCAoImZpZ3VyZSIuImNvZGljZV9maWd1cmEiID0gInV0ZW50aSIuImF6 aWVuZGEiICkgKSApIFVOSU9OIEFMTCAoU0VMRUNUICJmaWd1cmUiLiJhemllbmRhIiAsImZp Z3VyZSIuImNvZGljZV9maWd1cmEiICwidXRlbnRpIi4icmFnaW9uZV9zb2NpYWxlIiAsInV0 ZW50aSIuImlzdGF0IiAsInV0ZW50aSIuImNhcCIgLCJ1dGVudGkiLiJpbmRpcml6em8iICwi dXRlbnRpIi4iY2l2aWNvIiAsImZpZ3VyZSIuInRpcG8iICwidXRlbnRpIi4iY29kaWNlX2Zp c2NhbGUiICwidXRlbnRpIi4icGFydGl0YV9pdmEiICwiZmlndXJlIi4iZmluZV9hdHRpdml0 YSIgLCJmaWd1cmUiLiJkYXRhX2VzcG9ydGF6aW9uZSIgLCJmaWd1cmUiLiJkYXRhX2FnZ2lv cm5hbWVudG8iICwidXRlbnRpIi4iZGlzdHJldHRvIiAsImZpZ3VyZSIuImdydXBwbyIgLCJm aWd1cmUiLiJkYXRhX2VzcG9ydGF6aW9uZSIgLCJ1dGVudGkiLiJkYXRhX2VzcG9ydGF6aW9u ZSIgIEZST00gImZpZ3VyZSIsInV0ZW50aSIgV0hFUkUgKCgiZmlndXJlIi4idGlwbyIgSU4g KCdQJyAsJ1BCJyAsJ1BPJyAsJ1BTJyAsJ0EnICkgKSBBTkQgKCJmaWd1cmUiLiJjb2RpY2Vf ZmlndXJhIiA9ICJ1dGVudGkiLiJhemllbmRhIiApICkgKScNCiAgICAgICAgICAgICAgICAg ZGF0YV9hdF9leGVjPS0xLCBjdXJyZW50X2V4ZWNfcGFyYW09LTEsIHB1dF9kYXRhPTANCiAg ICAgICAgICAgICAgICAgY3VyclR1cGxlPS0xLCBjdXJyZW50X2NvbD0tMSwgbG9ial9mZD0t MQ0KICAgICAgICAgICAgICAgICBtYXhSb3dzPTAsIHJvd3NldF9zaXplPTEsIGtleXNldF9z aXplPTAsIGN1cnNvcl90eXBlPTAsIHNjcm9sbF9jb25jdXJyZW5jeT0xDQogICAgICAgICAg ICAgICAgIGN1cnNvcl9uYW1lPSdTUUxfQ1VSMDdCMDU2OTgnDQogICAgICAgICAgICAgICAg IC0tLS0tLS0tLS0tLS0tLS1RUmVzdWx0IEluZm8gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLQ0KQ09OTiBFUlJPUjogZnVuYz1TQ19leGVjdXRlLCBkZXNjPScnLCBlcnJudW09 MTA2LCBlcnJtc2c9J1VuZXhwZWN0ZWQgcHJvdG9jb2wgY2hhcmFjdGVyIGZyb20gYmFja2Vu ZCAoc2VuZF9xdWVyeSknDQogICAgICAgICAgICAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAgICAgICAgICAgIGhlbnY9 MTI5OTYxODgwLCBjb25uPTEyODk1MDU0NCwgc3RhdHVzPTEsIG51bV9zdG10cz0xNg0KICAg ICAgICAgICAgc29jaz0xMjg5NDEzMTYsIHN0bXRzPTEyODk0MTM1NiwgbG9ial90eXBlPS05 OTkNCiAgICAgICAgICAgIC0tLS0tLS0tLS0tLS0tLS0gU29ja2V0IEluZm8gLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KICAgICAgICAgICAgc29ja2V0PTMyMCwgcmV2ZXJz ZT0wLCBlcnJvcm51bWJlcj0wLCBlcnJvcm1zZz0nKG51bGwpJw0KICAgICAgICAgICAgYnVm ZmVyX2luPTEyODk1Njg3MiwgYnVmZmVyX291dD0xMjg5NjA5NzINCiAgICAgICAgICAgIGJ1 ZmZlcl9maWxsZWRfaW49NDA5NiwgYnVmZmVyX2ZpbGxlZF9vdXQ9MCwgYnVmZmVyX3JlYWRf aW49OQ0KPERFTEVURUQ+DQo= --------------4C67C5F375F657E37C344777--