Received: from s20.highertech.net (root@s20.highertech.net [209.54.120.20]) by hub.org (8.9.3/8.9.1) with ESMTP id RAA40695; Fri, 23 Apr 1999 17:50:44 -0400 (EDT) (envelope-from jt-kirkpatrick@mpsllc.com) Received: from kirkpatrickjt (whiteoak-34.highertech.net [209.140.56.34] (may be forged)) by s20.highertech.net (8.8.6/8.8.6) with SMTP id RAA20185; Fri, 23 Apr 1999 17:50:33 -0400 Received: by localhost with Microsoft MAPI; Fri, 23 Apr 1999 17:53:04 -0400 Message-ID: <01BE8DB2.22D48240.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'pgsql-interfaces@hub.org'" , "'pgsql-admin@hub.org'" Subject: recordset not updateable Date: Fri, 23 Apr 1999 17:53:02 -0400 Organization: MPS, LLC X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="---- =_NextPart_000_01BE8DB2.22D48240" ------ =_NextPart_000_01BE8DB2.22D48240 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit this is a resubmit with my pdbc log file. It shows an error in finding the file MsysConf. Maybe this is the problem?? Can someone please provide some insight? Thanks! I am using rh 5.2, postgres 6.4.2, linking to postgres with access97 and odbc driver. I can create a simple table, link to it, open it, and access tell me that "this recordset is not updateable". However, I have created many other tables in the same fashion and even much more complex and they are just fine. Any idea what could be going on? This just started happening today. Most of the tables I created over the past few weeks are working fine (I met one exception which has led me to create some test tables and link to them). BTW, I can update the table directly in psql on the server itself with no problem, so it must be odbc or access. But why do the other tables still work just fine? HELP!!!! Where can I look?? JT ------ =_NextPart_000_01BE8DB2.22D48240 Content-Type: application/octet-stream; name="psqlodbc.log" Content-Transfer-Encoding: base64 Y29ubj00Mzc3ODE2OCwgU1FMRHJpdmVyQ29ubmVjdCggaW4pPSdEUklWRVI9e1Bvc3RncmVTUUx9 O0RBVEFCQVNFPXNlcnZpY2V3b3JrcztTRVJWRVI9Z3JlZW5tYW47UE9SVD01NDMyO1JFQURPTkxZ PTA7UFJPVE9DT0w9O0ZBS0VPSURJTkRFWD0wO1NIT1dPSURDT0xVTU49MDtST1dWRVJTSU9OSU5H PTA7U0hPV1NZU1RFTVRBQkxFUz0wO0NPTk5TRVRUSU5HUz07JywgZkRyaXZlckNvbXBsZXRpb249 Mw0KY29ubj00Mzc3ODE2OCwgU1FMRHJpdmVyQ29ubmVjdChvdXQpPSdEUklWRVI9e1Bvc3RncmVT UUx9O0RBVEFCQVNFPXNlcnZpY2V3b3JrcztTRVJWRVI9Z3JlZW5tYW47UE9SVD01NDMyO1VJRD1z dm1hc3RlcjtQV0Q9O1JFQURPTkxZPTA7UFJPVE9DT0w9O0ZBS0VPSURJTkRFWD0wO1NIT1dPSURD T0xVTU49MDtST1dWRVJTSU9OSU5HPTA7U0hPV1NZU1RFTVRBQkxFUz0wO0NPTk5TRVRUSU5HUz0n DQpHbG9iYWwgT3B0aW9uczogVmVyc2lvbj0nMDYuMzAuMDI1MCcsIGZldGNoPTEwMCwgc29ja2V0 PTQwOTYsIHVua25vd25fc2l6ZXM9MCwgbWF4X3ZhcmNoYXJfc2l6ZT01NTAsIG1heF9sb25ndmFy Y2hhcl9zaXplPTE1MDAwDQogICAgICAgICAgICAgICAgZGlzYWJsZV9vcHRpbWl6ZXI9MSwgdW5p cXVlX2luZGV4PTEsIHVzZV9kZWNsYXJlZmV0Y2g9MA0KICAgICAgICAgICAgICAgIHRleHRfYXNf bG9uZ3ZhcmNoYXI9MSwgdW5rbm93bnNfYXNfbG9uZ3ZhcmNoYXI9MCwgYm9vbHNfYXNfY2hhcj0x DQogICAgICAgICAgICAgICAgZXh0cmFfc3lzdGFibGVfcHJlZml4ZXM9J2RkXzsnLCBjb25uX3Nl dHRpbmdzPScnDQpjb25uPTQzNzc4MTY4LCBxdWVyeT0nICcNCmNvbm49NDM3NzgxNjgsIHF1ZXJ5 PSdzZXQgRGF0ZVN0eWxlIHRvICdJU08nJw0KY29ubj00Mzc3ODE2OCwgcXVlcnk9J3NldCBnZXFv IHRvICdPRkYnJw0KY29ubj00Mzc3ODE2OCwgcXVlcnk9J3NlbGVjdCBvaWQgZnJvbSBwZ190eXBl IHdoZXJlIHR5cG5hbWU9J2xvJycNCiAgICBbIGZldGNoZWQgMCByb3dzIF0NCmNvbm49NDM3Nzgx NjgsIHF1ZXJ5PSdTRUxFQ1QgQ29uZmlnLCBuVmFsdWUgRlJPTSBNU3lzQ29uZicNCkVSUk9SIGZy b20gYmFja2VuZCBkdXJpbmcgc2VuZF9xdWVyeTogJ0VSUk9SOiAgbXN5c2NvbmY6IFRhYmxlIGRv ZXMgbm90IGV4aXN0LicNClNUQVRFTUVOVCBFUlJPUjogZnVuYz1TQ19leGVjdXRlLCBkZXNjPScn LCBlcnJudW09MSwgZXJybXNnPSdFcnJvciB3aGlsZSBleGVjdXRpbmcgdGhlIHF1ZXJ5Jw0KICAg ICAgICAgICAgICAgICAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0NCiAgICAgICAgICAgICAgICAgaGRiYz00Mzc3ODE2OCwgc3RtdD00 Mzc5MjY2MCwgcmVzdWx0PTANCiAgICAgICAgICAgICAgICAgbWFudWFsX3Jlc3VsdD0wLCBwcmVw YXJlPTAsIGludGVybmFsPTANCiAgICAgICAgICAgICAgICAgYmluZGluZ3M9MCwgYmluZGluZ3Nf YWxsb2NhdGVkPTANCiAgICAgICAgICAgICAgICAgcGFyYW1ldGVycz0wLCBwYXJhbWV0ZXJzX2Fs bG9jYXRlZD0wDQogICAgICAgICAgICAgICAgIHN0YXRlbWVudF90eXBlPTAsIHN0YXRlbWVudD0n U0VMRUNUIENvbmZpZywgblZhbHVlIEZST00gTVN5c0NvbmYnDQogICAgICAgICAgICAgICAgIHN0 bXRfd2l0aF9wYXJhbXM9J1NFTEVDVCBDb25maWcsIG5WYWx1ZSBGUk9NIE1TeXNDb25mJw0KICAg ICAgICAgICAgICAgICBkYXRhX2F0X2V4ZWM9LTEsIGN1cnJlbnRfZXhlY19wYXJhbT0tMSwgcHV0 X2RhdGE9MA0KICAgICAgICAgICAgICAgICBjdXJyVHVwbGU9LTEsIGN1cnJlbnRfY29sPS0xLCBs b2JqX2ZkPS0xDQogICAgICAgICAgICAgICAgIG1heFJvd3M9MCwgcm93c2V0X3NpemU9MSwga2V5 c2V0X3NpemU9MCwgY3Vyc29yX3R5cGU9MCwgc2Nyb2xsX2NvbmN1cnJlbmN5PTENCiAgICAgICAg ICAgICAgICAgY3Vyc29yX25hbWU9J1NRTF9DVVIwMjlDMzkxNCcNCiAgICAgICAgICAgICAgICAg LS0tLS0tLS0tLS0tLS0tLVFSZXN1bHQgSW5mbyAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tDQpDT05OIEVSUk9SOiBmdW5jPVNDX2V4ZWN1dGUsIGRlc2M9JycsIGVycm51bT0xMCwgZXJy bXNnPSdFUlJPUjogIG1zeXNjb25mOiBUYWJsZSBkb2VzIG5vdCBleGlzdC4nDQogICAgICAgICAg ICAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0NCiAgICAgICAgICAgIGhlbnY9NDQ4MjY3NTYsIGNvbm49NDM3NzgxNjgsIHN0YXR1cz0x LCBudW1fc3RtdHM9MTYNCiAgICAgICAgICAgIHNvY2s9NDQ4MjY3NzIsIHN0bXRzPTQ0ODI2ODEy LCBsb2JqX3R5cGU9LTk5OQ0KICAgICAgICAgICAgLS0tLS0tLS0tLS0tLS0tLSBTb2NrZXQgSW5m byAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogICAgICAgICAgICBzb2NrZXQ9MjI0 LCByZXZlcnNlPTAsIGVycm9ybnVtYmVyPTAsIGVycm9ybXNnPScobnVsbCknDQogICAgICAgICAg ICBidWZmZXJfaW49NDM3ODQ0NjAsIGJ1ZmZlcl9vdXQ9NDM3ODg1NjANCiAgICAgICAgICAgIGJ1 ZmZlcl9maWxsZWRfaW49NDIsIGJ1ZmZlcl9maWxsZWRfb3V0PTAsIGJ1ZmZlcl9yZWFkX2luPTQy DQpjb25uPTQzNzc4MTY4LCBxdWVyeT0nU0VMRUNUICJhdXRvaW52IiAsInBhcnRudW0iICBGUk9N ICJvaWR0bHRlc3QiICcNCiAgICBbIGZldGNoZWQgMSByb3dzIF0NCmNvbm49NDM3NzgxNjgsIFNR TERpc2Nvbm5lY3QNCg== ------ =_NextPart_000_01BE8DB2.22D48240--