Problem with ADODB.Connection with IIS7

Hi Everyone

I was wondering if you could help me - I've set up a legacy ASP
website I have as a site on IIS7 on my Windows Vista Business machine
and I can't get it to work.

The error I get is the generic "An error occurred on the server when
processing the URL. Please contact the system administrator" error.

I've been through this line by line, and the error seems to be
generated on the line where I open my DSN connection to a Microsoft
Access Database that I have an ODBC entry for... my code is roughly
this:

<%

dim sDSNConn
sDSNConn "DSN=MyDatabase;"

Set oContent = Server.CreateObject( "ADODB.Connection" )
oContent.Open sDSNConn

%>

If I remove the database calls, then I don't get the error, so I'm
confident that is what it is.

I have tried this: http://support.microsoft.com/?id=926939 and I've
tried adding the IIS6 compatibilty module with no joy.

Does anybody have any suggestions?

Many thanks in advance.

Darren

Re: Problem with ADODB.Connection with IIS7

Got it:

http://forums.iis.net/t/1071472.aspx

Darren

On 20 Jul, 00:07, Darren.Ratcli...@gmail.com wrote:
> Hi Everyone
>
> I was wondering if you could help me - I've set up a legacy ASP
> website I have as a site on IIS7 on my Windows Vista Business machine
> and I can't get it to work.
>
> The error I get is the generic "An error occurred on the server when
> processing the URL. Please contact the system administrator" error.
>
> I've been through this line by line, and the error seems to be
> generated on the line where I open my DSN connection to a Microsoft
> Access Database that I have an ODBC entry for... my code is roughly
> this:
>
> <%
>
> dim sDSNConn
> sDSNConn "DSN=MyDatabase;"
>
> Set oContent = Server.CreateObject( "ADODB.Connection" )
> oContent.Open sDSNConn
>
> %>
>
> If I remove the database calls, then I don't get the error, so I'm
> confident that is what it is.
>
> I have tried this:http://support.microsoft.com/?id=926939and I've
> tried adding the IIS6 compatibilty module with no joy.
>
> Does anybody have any suggestions?
>
> Many thanks in advance.
>
> Darren