arggggg... adodb.connection error... help

I have a laptop computer I routinely use at home for regular stuff
(mail, word processing, etc.) on a daily basis. Win XP/SP2, Office
2003, etc.

I periodically do development work for a friends' company. So, I also
have VB6 and SQL Server installed on the laptop.

About 6 months ago I wrote an ASP app for my friend which performs some
database IO against their sql server. All worked great. Zero problems.

I haven't touched VB or SQL Server on this box in months. I have though
applied the usual updates from microsoft's update site.

So, my friend calls me yesterday and asks me to make a few changes to
the app (layout related, not logic related). I launch SQL Server (works
fine) and use frontpage to make the mods to the ASP app.

Now, however, whenever I go to run the ASP app, I get the following
error:

Server object, ASP 0177 (0x8007007E)

The line the program is choking on is:

SET DBCn = Server.CreateObject("adodb.connection")

I tried re-installed MDAC 2.8SP1, but that fails (yields an error
message that it cannot be installed on this OS). I re-installed SP2,
same message.

Any idea how I can clear up this error message? This code was working
fine 6 months ago, so the only thing I can fathom is either SP2 or
another update from Microsoft somehow "broke" it.

Thanks,
Vin

.

Relevant Pages

  • Remote development advice
    ... My friend and I are entrusted to develop a small web based application ... using ASP and SQL Server database. ... We are using IIS as the web server. ... The IIS and SQL Server is setup in his ...
    (microsoft.public.dotnet.general)
  • Re: Access in wireless PDA scanner
    ... Access doesn't work with mobile devices ... you need to use SQL Server ... operations in a tiny warehouse of a friend of mine. ...
    (microsoft.public.access.devtoolkits)
  • (ACCESS or Dot.Net ) + SQL server for a simple multiuser aplication
    ... A friend of mine who is familiar in Dot.Net programming is advicing me not to ... of SQL server is seriously diminishing if there are more ACCESS Front Ends ...
    (microsoft.public.access.adp.sqlserver)
  • Re: (ACCESS or Dot.Net ) + SQL server for a simple multiuser aplication
    ... > I am about to start developing a multiuser aplication using SQL-server ... > A friend of mine who is familiar in Dot.Net programming is advicing me not ... > of SQL server is seriously diminishing if there are more ACCESS Front Ends ...
    (microsoft.public.access.adp.sqlserver)
  • System.Data error 80131904
    ... The legacy asp app has no problem connecting to Sql Server, but when the dll ...
    (microsoft.public.sqlserver.connect)