Environment: Win2K, Sql2K, IIS5, ASP, PythonWin
Have suddenly run into problems rolling out some code to a production web server, after it worked fine on development machine and staging server. There's a single MsSql server involved across all 3 cases.
On the production box, none of my ASP pages which make ODBC calls work. I get an error at the time of trying to make the initial connection: "[Microsoft][ODBC SQL Server Driver]Client unable to establish connection in LOGIN".
Yet
- when I go into the control panel for the DSN I'm using, and hit the Test button, it works fine
- when I launch PythonWin environment on the server itself, and run the equivalent code interactively, it works fine.
Any clues as to what could be going wrong here? I've already spent a couple days on this, it's getting embarrassing.
