Received: from sapphire.albourne.com (root@sapphire.albourne.com [195.212.241.227]) by hub.org (8.10.1/8.10.1) with ESMTP id e7ILRWm10737 for ; Fri, 18 Aug 2000 17:27:32 -0400 (EDT) Received: from albourne.com (akamas.albourne.com [195.212.241.254]) by sapphire.albourne.com (8.9.3/8.9.3/Albourne/CYS/1.8/MAPS) with ESMTP id AAA02012 for ; Sat, 19 Aug 2000 00:27:17 +0300 (EET DST) Message-ID: <399DAA34.A4870D95@albourne.com> Date: Sat, 19 Aug 2000 00:27:16 +0300 From: Fabio Nanni X-Mailer: Mozilla 4.73 [en] (X11; I; Linux 2.2.17pre13 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: MS Access problems Content-Type: multipart/mixed; boundary="------------4C6C75D9B0C788CD71B31DB2" X-Archive-Number: 200008/109 This is a multi-part message in MIME format. --------------4C6C75D9B0C788CD71B31DB2 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello all, I have two problems in accessing a psql database via MS-Access-ODBC, and I cannot find anything similar on the mailing list. I am a novice to psql and ODBC, has anybody perhaps faced these problems? The configuration was: Client side: - MS Access 97 SR-2 running on NT 4.0 (Build 1381: Service Pack 6) - odbc driver version: 6.50.0000 Server side: - postgresql database, version: 7.0.0 The problems are: 1. when linking a table, Access is unable to find automatically the primary key and raises a dialog asking me to specify it. I attached the tracelog file due to the linking of the table below: Table "currencies" Attribute | Type | Modifier ------------+---------+---------------------- curr | char(3) | not null curr_name | text | not null curr_quote | boolean | not null default '1' Index: currencies_pkey 2. Access is unable to discover automatically relations and foreign keys in the database. Many thanks in advance Fabio --------------4C6C75D9B0C788CD71B31DB2 Content-Type: application/x-gzip; name="psqlodbc.log.gz" Content-Transfer-Encoding: base64 Content-Disposition: inline; filename="psqlodbc.log.gz" H4sICAKonTkAA3BzcWxvZGJjLmxvZwDtW21z2kgS/u5fMecvJHcKJTD22nHp qniRgaAXIgkwbO1RAo1tbYTk6CWx7+rut1/PSGDTA44dvJurC1S5PNPq6Znp p5+eHlHMozBUKsfV40rtrFaTiP1Ra8X+Fxo34QGdp2+IH75VSi2rO1Qt5V/9 KEmvYwpa/z4fdFvKX4vPedM0DFt1nK7RtpVzu2OO7LHtqLpTb2iqrcjnljkC C3bXNEAF+kzF7LaapjbQDehf1Hsq9LtGS72Ebt8yHRMeKifl2rml1lumoY2V ynnftJyHWW3VYsuCZrn4O2/VYcq6rTLheUkiV8vtLG4DmvoR7PagHUQzNyDm Lesn78mQxgl7UpJPysdyWYYPG0nT+Y1SkWWJJNH8E02Vmnx2IpEs/BRGX8Np 4v+TJgo8Xbh30y9uPL9xYy5Uqse1XBpE4fXak9PKmXxA0MfzE3cW0GkE61mA VqxUJPIp+Ryx/1nof87o1A89escmyxI69eg8cGNaLFCwl9K7dOomj2fnI/N1 JxsezaIo4HIuEC2CwdidJvdJyhd6C3P7d7D5kudNmZPnECzThKapH16DtHQw R2EFW4jvlRLZ+gQGk5abUju9DyhJI1Lq2uZ2Q0z9mn6OuKZ5cfG0JvNlrmls V2yo7a6x9WnhcsaPaXNgyWeVU1muyWSexUkUkyv4S2gAhCGR75GrOFqQ2+tp en9LydcbCgOhGboLqpSCaPsaOKIEQg5Yh6cqcVR+zcOSekQmcfQ1Ib9tszUP okRY79aZVaMlPhOSQZSlW5LBGu020HKdt2upoz9qKWsUf0x9lBZw1tiUVVDi WctMfxz6tqqpTYeAp678a4mEQzfIKLmwTJ3o9n3C5KUD1bJMK4+OmQspJfSI l8VAGgie0Jvy2d6TEld7T4hFA5elKFJaAPfmzATxIpqQMEqBk36Sbl1xvQEO Lx3YTh18oRoOKWxeZeFcsZtTekfnWUol4tFkDoyVCI3jMFuwlAOtRXINMRHH sLGvNz4wMtdnK01vaD5JSUgT5N0OH9HajTebP95aki5S3j/55fSXqkRimmRB qogJFXJvmLnBdKkgEchYtwAga/phSuPQDTaNm0Ga5SmM5cSiPXWDIJpDavI2 jQCrwGqwyMc89J4eBXk0pQsapjxDsJEriVJ6ViRtMLlIp1/99GbKF5G8XtAK U3lu6k7dlMeQ8g4CBizGbDNMkE/PxbdZOmW6mzzAhjgZHMlrBuZRwPtwPv8+ vfKgvQnbOwsSH3MaS4A0zU9WdmTS+1VXlop9Pnh4HkdBAFOE+Wzz+w0H3XJQ nqo3ZuC1Dw7ijxYPOdINr6JvseGAZabn87IiP2LmCxLEU8v9bn7e0PDLkprV 07wAWKeqm2YJAwXWPmWxCZ2TNROspuJDqpXqqZyzO8kFZ8dHJ0UQcPTenZ2d PbkPYvMC7Xlux4uAwu6odsrSCZx0CY8VyjIfrHxG41WXO/6NMdC0t+tOnWVX VzSGCq3YzRFzSCGEAzOXHteOqptGXflBQD02+EhCMjZWXglj6nK16mudYGcy hNSG+iWmAYt+XmnmDZDcuEmcBRBYy8oGrCWJxFqgFhc1Dih+gqxJFFKKS8SF VmGM/OU/pPSPOz/88qv87uy3v+UPIRPXYJNvwAJEr++9hYFLGQyEWpXGb6PY A/uz+6Wpl9ZOfJu4dmJaT1dPL7FWq76wFCusvKQU+06Q60eyfLoB5Hl5E6gc ykxa4UvmBbBZeYkRQMTHcnA4irzLQQ78T5SUiuzq0+TFdS5frYDVC51bGPmB zuXeyqmzco5E3LKbpo+akNl8TyJpubgZLDWyRdEKaPiguoi8pUIEOkEgPRtD 3oaBsT+Dk4W40upmkj4LXrjQKPnU8ABUmPRhBzAiZSpc/Ga5BfJ3Ir/9VniQ FbfzQa8SLkfLcAG9ZhRkC3bB59dW5fHc0pVPA68455m8JPGjpiLXqlLyOeCd 6snpsVw5OapKud7slt2PSy81zZuF/erxVuvs2v5y25+zKF0ar5xsXzrc8Lf6 98dRqHEkt/YU+nEU4v7fU+j1KVQ49kcf8Tkr/DJUZXA7Klp+kr9UXHXnQZbA pZV62xjB3z4SX6BE3vYKDvA4ZzVcmes/hLq3CmBlPXrzh49G8TH/52XDtlv4 4YNnDsu8c5hfxR8/2P4G9SXvDr+7/t1o7fRPeBX5R/j6UDpc5ZZlm+eCQ7LB 8WTUUS21GMkCud7ql4hpPZZc1LFE07BEb2GJ0cYS08ASy8YSR5AMBMuj9uu8 a678pAhPdOTRRgP7uNFysES9wJI2joJGR7DTFUYJkdIwBInZ2CO8A8INc4g9 aglY2YLXHczPxgjngsa4gSUTbKdZFyQdHAVN7Ykvt/YIfxPhpoaRaRpjLDEF HauJJQNBZ6hiyVjQmfSQpKXinNL6sEd4F4S7HzGLupaFJTbGoetgnn8Q8u0H U5D0cez0VHwO99qCpGPtEd4B4VZPYJHA2JaQXdUmxkFt4myvqtiy2saWVVuQ ODi3X3T1PcI7IHzxAaN30cNev7Dw2dhuYJ22gGe7gzN5uyuMEpjfNoS5rNYe 4R0QbjsfsUeFmqk9xjh0eoLEwHm7Y2HMOw6+UXUGGM9uSzgj1P4e4V3OYQ3n 266BfdzTMQ69/ghLLEEywlHQEyKlN8H3MK2O40Jr7BHeBWF9hD2qX+KbkD7G mOvCLdoQ7j1GG9sxuiaWaJjVhonXY/T3ldYuCGs9jJ5mYaw0G2dgTailNSHf akNBR+CwLsSF3sKj9Pb+trQTh4UTVdcFVhs4l+pCva1bmJ+6EAX6QMgFw+dJ XgXh058SYNvCadJ2MOT2EBfFtvDqwp5gOJ0OvvY4Ok7tjvCK0hFCx+mrewrv gLAhXHVNHZOoX8dY9VV8xPbbmPj9DsaqLxwIfU2wo02wxNkjvAvC/THm8Mc6 xsEyMT8tId1aI3wM24IdW/hKw24KOi1BBy7ae4R3yNJtwaMC9+wuPoZt4UWY LXzBaJv4Gvb9kldB+OSnBFgVyPi/KHkdCv+UADvCF4WOUGc5wosLZ4J5NhBe Uwzal1gifAU5sPEpPBgPsGTySgz+SXP0UMU11FCobocD/JXCyMZZ+7KOT+HL JrZzaQo6fSwZq5jC48ETP2jcI/xNhCdCNTQRLsMTCzNtIrC6rv6RkldB+PjP +bmoz36FxH4revBfLE9Dllo+AAA= --------------4C6C75D9B0C788CD71B31DB2--