I run into a strange problem today while enableding ODBC SQL logging on my
IIS Server.
Once the logging was enabled, and working fine, my two ASP.Net Applications
could no longer connect to the database. I got an Access Denied or Server
does not exist error.
The moment I set the logging back to the normal file based logging, the
applications worked again.
I noticed in the stack trace of the ASP.Net errors that connection pooling
was showing up.
Could the ODBC logging, via a System DSN, somehow be interfering with the
..Net SQLClient access?
Strange thing is that all of the applications, and the logging, use
different usernames, so a connection from the pool should not be used
anways.
I'm stumped on this one, any guidance would be appreciated.
Thanks
Rob