connection string prob, works in VS but not IIS

[gerryR com]

Hi All I've got the following connection string in my web.config file, when I "view in browser" through VS's built in web server everything works fine, however when I copy everything to the IIS wwwroot folder and browse that I get the following error: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified I've searched high an low but can't get the thing working! <add name="ConnectionString5" connectionString="DSN=Excel Files;DBQ=C:\Inetpub\wwwroot\A2Z.xls;;DefaultDir=C:\Inetpub\wwwroot;DriverId=1046;MaxBufferSize=2048;PageTimeout=5;" providerName="System.Data.Odbc"/> Really appreciate any help (again :( )

[Venkat Eswaran]

Can you try re-registering .net with IIS using aspnet_regiis.exe

Venky