Received: from nanguo.chalmers.com.au (gateway.chalmers.com.au [203.1.96.1]) by hub.org (8.9.3/8.9.3) with ESMTP id CAA84101 for ; Tue, 7 Mar 2000 02:39:57 -0500 (EST) (envelope-from robert@chalmers.com.au) Received: from carbon (carbon.chalmers.com.au [203.1.96.26]) by nanguo.chalmers.com.au (8.9.3/8.9.3) with SMTP id RAA06185 for ; Tue, 7 Mar 2000 17:37:01 +1000 (EST) Message-ID: <007801bf8809$5ab72b20$1a6001cb@chalmers.com.au> From: "Robert Chalmers" To: "pgsql" Subject: MS Access suddenly refusing to deal with pgsql db... and Failing Make Date: Tue, 7 Mar 2000 17:47:13 +1000 Organization: R.A.Chalmers Pty Ltd MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Hi, this is a strange thing. I recently upgraded my postgresql, to 6.5.3 and now I have two problems. I run a FreeBSd system. 2.2. This is one problem, Firstly, the make falls over making the odbc with; ld -x -Bshareable -Bforcearchive -o libpsqlodbc.so.0.25 info.o bind.o columninfo.o connection.o convert.o drvconn.o environ.o execute.o lobj.o misc.o options.o pgtypes.o psqlodbc.o qresult.o results.o socket.o parse.o statement.o gpps.o tuple.o tuplelist.o dlg_specific.o -lcrypt -lcompat -lln -lm -lreadline -ltermcap -lncurses /usr/lib/libcompat.a(regerror.o): Definition of symbol `_regerror' (multiply defined) /usr/lib/libcompat.a(regex.o): Definition of symbol `_regerror' (multiply defined) gmake: *** [libpsqlodbc.so.0.25] Error 1 ALSO.... Now, when I try to update my db from MS-Access, it wont let me, saying the database is already in use by osmeone else. Which of course its not? I have changed nothing on the PC with Access. It opens the databases fine, but I just cant save data to them anymore. It seems to not be locking them maybe? Does anyone have any ideas that may help on these two problems please. Thank you so much Robert http://www.chalmers.com.au Clipart And Books Art, Design and Graphics.