Global.asa errors

[Anesthaesia]

Hi,

I am using Web Reporting for SMS 2.0

When I try run a report, I get the following error :
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [-2147467259]

I have found that manually editing and entering the connection string from the global.asa file into the .asp file makes the report work. It seems the session variables from the global.asa are therefore not being loaded. Does anyone know why this is happening ?

 

[Anesthaesia]

At least I know now I'm not alone

I still haven't been able to resolve the issue. So far, I have manually edited the ASP files with the connection string, but that is far from ideal, as some pages relying on the variable do not work.

 

[mumbojumbo]

try renaming all your connection vars with Application("varnames&quot
then print em..


try and use DSN for connection see if that works... could be IIS issue