oleDBExecption 0x80004005: ODBC --- connection to 'Database' Faile

[snazzy]

Connection to ODBC Database works OK while in the Visual Studio 2008 Debug
mode. However after building the Web Application and publishing the files
for project, an error occurs;
Server Error in '/ASP' Application
ODBC --- connection to 'Database' failed
Source Error: An unhandled execption was generated during the execution of
the current web request.

Using impersonation and IIS Windows Intergrated Authenication

 

[bruce barker]

if you are using sqlserver trusted security, and impersonation Windows
Intergrated Authenication instead of the pool account, then the sqlserver
must be hosted by the webserver.

this is because Windows Intergrated Authenication does not support
credentials forwarding (1 hop rule). if you must use impersonation, you can
switch to basic, or kerberos (must enable credentials forwarding on servers)
which will allow credentials forwarding.


-- bruce (sqlwork.com)