Re: Error in MS Access

Thank you Andy.

The server is SunOS 5.8 Generic_117350-29 ultra-250. The db is version 7.
I checked disk (df -k) telling me /home0 is full 100% that has DB on. Former DBA has notes to delete large log files (server.log). But this time I didn't find same file. I saw pg_log file 4.6 MB timestamped May 9.

Any suggestions? Thank you again.

Rocky

________________________________

From: Andy Shellam [mailto:andy(dot)shellam(at)mailnetwork(dot)co(dot)uk]
Sent: Mon 5/15/2006 10:53 AM
To: Xu, Xiaoyi (Rocky) FSM
Cc: pgsql-admin(at)postgresql(dot)org
Subject: RE: [ADMIN] Error in MS Access

I take it you've checked your server? i.e. disk space, available memory, state of the postgresql service?

If you provide some more info, such as the platform you're running the server on, server version, ODBC driver version etc, we could help more.

Andy

________________________________

From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Xu, Xiaoyi (Rocky) FSM
Sent: 15 May 2006 4:39 pm
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] Error in MS Access

Hi,

My database users are getting following error:

ODBC-call failed
Error while executing query
Error: ItsWriteBlock: failed to write block 1 of temporary file
Perhaps out of disk space (#1)

This happens in front-end Access. Could anyone shed some light on this? Thank you.

Rocky

!DSPAM:14,4468a0ca34491802220264!