Cant get ADO running under IIS

[Tony]

I have a new W2K3 box running IIS

Is there anything I have to install in order to use ADO?

When I perform the following

Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open "mydsn"

I get the error

Provider error '80004005'
Unspecified error

[Brad]

Tony,

Not sure if this pertains to your question but do you have ADOVBS.INC file,
added to your Application folder. In order to avoid ADO connection errors
you''ll need this INCLUDE file.

Example:
adovbs.inc

<!--METADATA TYPE="TypeLib"
NAME="Microsoft ActiveX Data Objects 2.7 Library"
UUID="{EF53050B-882E-4776-B643-EDA472E8E3F2}"
VERSION="2.7"-->

Please see more
here:http://www.4guysfromrolla.com/webtec...ner/faq7.shtml

Hope this helps,

~Brad
----------------------------------------------
Brad Isaacs
Web/Application Developer & Client Support
www.webdevcreations.com
"Tony" <an*******@discussions.microsoft.com> wrote in message
news:1d****************************@phx.gbl...

I have a new W2K3 box running IIS

Is there anything I have to install in order to use ADO?

When I perform the following

Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open "mydsn"

I get the error

Provider error '80004005'
Unspecified error

[Curt_C [MVP]]

IIRC you've got a permissions issue. That's where I would start looking.
--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Tony" <an*******@discussions.microsoft.com> wrote in message
news:1d****************************@phx.gbl...

I have a new W2K3 box running IIS

Is there anything I have to install in order to use ADO?

When I perform the following

Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open "mydsn"

I get the error

Provider error '80004005'
Unspecified error