I get the following error when I try to access my UDL. I included the code I'm using two versions. Any one know what the problem is?

Provider error '80030005'

Access Denied.

/testconnection.asp, line 6


<%
option explicit
Dim oConn
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "File Name=\\FLDOIREMRHBFP4\INTRANET\TEST\TESTSQLCONNECT ION.UDL"
%>

<%
    dim dcndb

    set dcndb = server.createobject("adodb.connection")
    dcndb.connectionstring = "file name=\\FLDOIREMRHBFP4\INTRANET\TEST\TESTSQLCONNECT ION.UDL"
    dcndb.open

%>

It seems you are trying to access the UDL file from remote system. It is due to privilege problem between the remote system and your WEB server. Why don't you have that within your webserver that hosts the asp page. why do you want it to be on remote system on your network? Where is the DB running?

_________________________
- Vijay G
Strive for Perfection

UDL is sitting on IIS. The database the UDL connects to is sitting on a SQL Server. Would it appear my problem is between my IIS/Webserver and SQLServer? If I go to the UDL and test the connection it say the test is a succes. So does that mean the problem is between the browser and IIS?

Thanks!
Rich

So where is your testconnection.asp, UDL, SQL server all lying?

I assume testconnection.asp is sitting on IIS server somewhere under wwwroot. So UDL should also be somewhere within that box. Though it doesnt matter your SQL server runs on the same box or different.

Is my guess right?

_________________________
- Vijay G
Strive for Perfection

In the same folder.

Then why do you have to use it this way?
\\FLDOIREMRHBFP4\INTRANET\TEST\TESTSQLCONNECTION.U DL

replace that with

Server.MapPath("./TESTSQLCONNECTION.UDL")

Cheers!

_________________________
- Vijay G
Strive for Perfection

Thanks a million brother!

Peace Out!
Rich