Unable to access data from asp file

[aminahbt]

Hi,

I have a coldfusion and asp running in the same server. Recently, I reinstalled coldfusion server to rectify a certain problem. The problem has been solved, only now Im totally unable to connect to my SQL DB using asp codes. My .cfm files are running fine. My .asp files give an error message :
Microsoft VBScript runtime error '800a01ad'

ActiveX component can't create object
when I use the code:
Set DataConn = Server.CreateObject("ADODB.Connection&quot
Otherwise, .asp files with other loop functions run fine.

Tell me I dont have to install an MDAC file into my server.

What do I do? I've created a new problem while trying to solve one.

Could a kind soul come to my aid?

-lost

 

[lobstah]

we had the same problem (for the same reasons....), and it was that coldfusion had an older version of MDAC, so yes, you probably do have to reinstall latest MDAC on your server.

 

[aminahbt]

Hi lobstah,

I resorted to installing the MDAC yesterday right out of the SQL Server 2000 cd. It didnt't work. I went to

http://www.microsoft.com/data

and downloaded MDAC 2.6 sp1 and restarted my server and it worked. Spent two days just contemplating whether to install this into my server.

But it worked al right. And thanks for your reply.

cheers