Thread: Help
I have never contacted you before but desparately now find myself needing your help. We have a small debt collection businesswith an Access front end and Postgre SQL 8.3.<br /><br />I am getting an error on my front end and cannot seem tofix it. My technical skills are very basic. Our db was set up by a third party who is no longer available. <br /><br />Theerror I am getting is:<br /><br /><b>ODBC - update on a linked table 'tbldebtormaster' failed.<br /><br />Error: Couldnot read block 0 of relation 1663/157545/289002; read only 0 of 8192 bytes;<br />Error while executing the query (#7)</b><br/><br />Can you help?<br />Can you recommend someone who could help and also provide ongoing support.<br />Ouroffice is in Burlington, Ontario, Canada<br />Toll free 1-800-661-3915<br /><br />Larry Partridge<br /><br />Alternateemail<br /><a href="mailto:larrypartridge@ccrcollections.com"></a><a href="mailto:larrypartridge@ccrcollections.com">larrypartridge@ccrcollections.com</a><br /><br /><br />
Le 29/09/2010 18:46, Larry Partridge a écrit : > I have never contacted you before but desparately now find myself needing > your help. We have a small debt collection business with an Access front end > and Postgre SQL 8.3. > > I am getting an error on my front end and cannot seem to fix it. My > technical skills are very basic. Our db was set up by a third party who is > no longer available. > > The error I am getting is: > > *ODBC - update on a linked table 'tbldebtormaster' failed. > > Error: Could not read block 0 of relation 1663/157545/289002; read only 0 of > 8192 bytes; > Error while executing the query (#7)* > > Can you help? It seems one (at least) of your database files disappeared. This is not good at all. Without more info, the best you can do is restore a backup. Whatever you do, be extra careful. > Can you recommend someone who could help and also provide ongoing support. > Our office is in Burlington, Ontario, Canada > Toll free 1-800-661-3915 > Nope, sorry. Perhaps others know someone in Canada who could help you. -- Guillaumehttp://www.postgresql.frhttp://dalibo.com
Try disabling any anti-virus software that you may have installed recently. Sometimes, that can interact with PG (and other DB servers) in unpredictable ways. -- Regards, Peter Geoghegan