SUS installation breaks ASP pages

[Michael Stumpo]

I recently installed SUS/SP1 on our intranet server.
After doing so, all the ASP (database connected) pages
now report the following error:

Database Results Error
[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is
not a valid path. Make sure that the path name is spelled
correctly and that you are connected to the server on
which the file resides.

I uninstalled SUS and all it's components but the ASP
pages still do not work.

Does anyone have any ideas what caused this? My guess is
some kind of security/lockdown IIS issue? But I can't
find a way to correct this.

Help

[Mark Schupp]

What is SUS?

--
Mark Schupp
Head of Development
Integrity eLearning
[url]www.ielearning.com[/url]


"Michael Stumpo" <anonymous@discussions.microsoft.com> wrote in message
news:1d9d01c3e03e$6af0b560$a501280a@phx.gbl...

> I recently installed SUS/SP1 on our intranet server.
> After doing so, all the ASP (database connected) pages
> now report the following error:
>
> Database Results Error
> [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is
> not a valid path. Make sure that the path name is spelled
> correctly and that you are connected to the server on
> which the file resides.
>
> I uninstalled SUS and all it's components but the ASP
> pages still do not work.
>
> Does anyone have any ideas what caused this? My guess is
> some kind of security/lockdown IIS issue? But I can't
> find a way to correct this.
>
> Help

[Ken Schaefer]

Software Update Services:
[url]http://www.microsoft.com/windowsserversystem/sus/default.mspx[/url]

"Mark Schupp" <mschupp@ielearning.com> wrote in message
news:%23$fMjzH4DHA.2388@TK2MSFTNGP09.phx.gbl...
: What is SUS?
:
: --
: Mark Schupp
: Head of Development
: Integrity eLearning
: [url]www.ielearning.com[/url]
:
:
: "Michael Stumpo" <anonymous@discussions.microsoft.com> wrote in message
: news:1d9d01c3e03e$6af0b560$a501280a@phx.gbl...
: > I recently installed SUS/SP1 on our intranet server.
: > After doing so, all the ASP (database connected) pages
: > now report the following error:
: >
: > Database Results Error
: > [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is
: > not a valid path. Make sure that the path name is spelled
: > correctly and that you are connected to the server on
: > which the file resides.
: >
: > I uninstalled SUS and all it's components but the ASP
: > pages still do not work.
: >
: > Does anyone have any ideas what caused this? My guess is
: > some kind of security/lockdown IIS issue? But I can't
: > find a way to correct this.
: >
: > Help
:
:

[Ken Schaefer]

Can you please post sample connection string?

Cheers
Ken



"Michael Stumpo" <anonymous@discussions.microsoft.com> wrote in message
news:1d9d01c3e03e$6af0b560$a501280a@phx.gbl...
: I recently installed SUS/SP1 on our intranet server.
: After doing so, all the ASP (database connected) pages
: now report the following error:
:
: Database Results Error
: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is
: not a valid path. Make sure that the path name is spelled
: correctly and that you are connected to the server on
: which the file resides.
:
: I uninstalled SUS and all it's components but the ASP
: pages still do not work.
:
: Does anyone have any ideas what caused this? My guess is
: some kind of security/lockdown IIS issue? But I can't
: find a way to correct this.
:
: Help

[Lain]

Hi Michael

I have a development server with DSNs and running SUS SP1 and fortunately didn't have any issues, so from that perspective I'm guessing here, but:
- When you performed the uninstall, did you check that the IIS Lockdown utility was rerun and the settings it implemented during the install were reversed?
- Did you uninstall the IIS URLScan utility (also installed as part of the IIS Lockdown installation and available in Add/Remove Programs) when you removed SUS?

If you can confirm through the Data Sources applet that the DSN is still okay (as it should be) then perhaps either/both of the above may help.

On the remote chance that this information helps you, what I tend to do (and *possibly* why I've had no troubles, though I don't know for sure) is run the IIS Lockdown utility first so that I can specify the lockdown options or server role I want. That way I don't lose unexpected functionality through using the default options. So my process looks like this:

- Set up the server (in my case the corporate standard is Win2000 SP4).
- Run the IIS Lockdown utility and customise the options I want.
- Install SUS SP1.
- Configure client-related group policy settings.

If you're unsure of where to find the IIS Lockdown utility, check out KB article 325864 and/or follow this URL:

[url]http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=DDE9EFC0-BB30-47EB-9A61-FD755D23CDEC[/url]

Cheers
Lain

did you find a fix. I'm in hell with the same problem

>: "Michael Stumpo" <anonymous@discussions.microsoft.com>

wrote in message

>: news:1d9d01c3e03e$6af0b560$a501280a@phx.gbl...
>: > I recently installed SUS/SP1 on our intranet server.
>: > After doing so, all the ASP (database connected)

pages

>: > now report the following error:
>: >
>: > Database Results Error
>: > [Microsoft][ODBC Microsoft Access

Driver] '(unknown)' is

>: > not a valid path. Make sure that the path name is

spelled

>: > correctly and that you are connected to the server on
>: > which the file resides.
>: >
>: > I uninstalled SUS and all it's components but the ASP
>: > pages still do not work.
>: >
>: > Does anyone have any ideas what caused this? My

guess is

>: > some kind of security/lockdown IIS issue? But I can't
>: > find a way to correct this.
>: >
>: > Help
>:
>:
>
>
>.
>