X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 73FD3535D3; Thu, 12 May 2005 17:46:09 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87922-05; Thu, 12 May 2005 20:46:00 +0000 (GMT) Received: from mta10.nationwireless.net (mta10.nationwireless.net [63.163.128.10]) by svr1.postgresql.org (Postfix) with ESMTP id E53E754011; Thu, 12 May 2005 17:45:59 -0300 (ADT) Received: from jfradkin [63.162.100.127] by mta10.nationwireless.net with ESMTP (SMTPD-8.20) id A089031C; Thu, 12 May 2005 16:46:01 -0400 From: "Joel Fradkin" To: "'Bricklen Anderson'" Cc: , Subject: Re: catastrophic error Date: Thu, 12 May 2005 16:46:23 -0400 Message-ID: <002401c55733$a922b5a0$797ba8c0@jfradkin> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable In-Reply-To: <4283BE0D.90606@PresiNET.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.801 tagged_above=0 required=5 tests=AWL, MSGID_DOLLARS X-Spam-Level: * X-Archive-Number: 200505/174 X-Sequence-Number: 17603 The catastrophic error was the actual text sent from the IIS component error. SO I am not 100% sure what it means, I believe it is just mirroring back text from the dbserver when trying to connect and failing. I am guessing it is odbc and I am currently using the 7.4 version, but = am looking for the best way to move from SQL_ASCHII to UNICODE (maybe a = backup and restore using some kind of params? I hope? If not I guess I could alter my original program that read MSSQL to read from postgres and write it back to a Unicode database and see if the = odbc drivers are ok (it originally blew up and that's how I ended up using SQL_ASCHII). Joel Fradkin What does a catastrophic error consist of? Do you mean your IIS servers could no longer connect to the db, and yet you _could_ connect to the db = via pgadmin? Yes the web interface gave that as the conection error string = (my error routine just prints that to the screen) I would have thought that rebooting the IIS would have solved any connectivity issues (assuming that that is the error that you are = getting). I've never used IIS, so I can't even guess about that. ODBC is a possibility, I suppose, and it certainly wouldn't hurt to try again on = the ODBC list. Cheers, Bricklen --=20 _______________________________ This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. _______________________________