ASP/ADO/SQL Error

[Alexis M]

Hello, and sorry for the crosspost...

I'm using Windows 2000 Server SP1, SQL Server 7.0 SP2, IIS 5.0.

I have created a System DSN pointing to my SQL server, and I have tested it
using odbcping.exe.

When I try to connect using ASP, I get an error:

Error Type:
(0x800401F9)
Error in the DLL
/development/test.asp, line 12

Line 12 is my "rsDataset.Open" line.

In a related problem, when I'm using SQL Server Enterprise Manager, try to
open a table (to view the data), I get a message box saying:
Unknown Error in Query Designer: 800401F9

However, my SQL server is actually working, since I can view data using
SELECT statements from the Query Analyser.

Any help would be greatly appreciated.

Thanks

Alexis M
< a l e x _ m 7 4 at h o t m a i l dot c o m >

[Aaron Bertrand [MVP]]

I would recommend trying to reinstall SQL first (sounds like his error is
within the SQL programs themselves). Who knows if SP1 will do to this
bloke's IIS what it did to mine...

--
_______________________
MVP / www.aspfaq.com

> Sounds like something has gone screwy with your MDAC installation, Windows
> 2000 by default installs MDAC 2.5, and because of OS protection I beleive
it
> will not allow you to add it yourself.
>
> Not sure what you can do in that case, maybe apply Windows 2000 SP1?

[Chris Crowe]

Sounds like something has gone screwy with your MDAC installation, Windows
2000 by default installs MDAC 2.5, and because of OS protection I beleive it
will not allow you to add it yourself.

Not sure what you can do in that case, maybe apply Windows 2000 SP1?

--

Chris Crowe
IIS FAQ Web Site
http://www.iisfaq.com

"Alexis M" <nos...@hotmail.com> wrote in message
news:8miik6$6r4$1...@aristotelis.cytanet.com.cy...

[Alexis M]

I removed IIS, removed SQL7.0.

Then reinstalled SQL7.0. The same error still showed up in the Query
Designer.
"Unknown Error in Query Designer: 800401F9".

So I figured I mightr as well try SP1. I reinstalled IIS, then applied SP1.
Still nothing. I cant connect using ADO, and the query designer still wont
show any records. Strangely enough my SQL server seems to work when I use
the Query Analyzer.

I also get a message "Error in the DLL" (with no more info) when I try to
import/export data from the SQL server (which leads me to agree with Chris
in that something is screwy with MDAC).

Other than reinstalling Windows 2000, is there any other way I can force an
upgrade/reinstall of MDAC?

Thanks again

Alexis M
< a l e x _ m 7 4 at h o t m a i l dot c o m >

"Aaron Bertrand [MVP]" <send_spam...@my-deja.com> wrote in message
news:uh94Is$$$GA.261@cppssbbsa05...

>
> I would recommend trying to reinstall SQL first (sounds like his error is
> within the SQL programs themselves). Who knows if SP1 will do to this
> bloke's IIS what it did to mine...
>
> --
> _______________________
> MVP / www.aspfaq.com
>
>