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
--
_______________________________
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.
_______________________________