Authentication failed error (but not with 127.0.0.1)

I am running 2003 server with abunch of sites, all is well

I just dumped some stuff for a new site there and I am getting the good
ol'

Provider error '80040e4d'
Authentication failed.

Here's my code...


<%
MyConn.open MyConnString
set rs = MyConn.execute ("SELECT DISTINCT(companyID)FROM data")
%>


<%
'this is my db.asp file...
Dim ipValue
ipValue = Request.ServerVariables("LOCAL_ADDR")
Select Case ipValue

Case "127.0.0.1"
dbSource = "D:\www_data\cohenreps\cohenData.mdb"


Case "216.***.***.***0"
dbSource = "D:\www_data\cohenreps\cohenData.mdb"


end select
set MyConn = Server.CreateObject("ADODB.Connection")
MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="&dbSource&""
%>

I am simply doing a little loop to get some data

<%while not rs.eof%>

href="company.asp?company=<%=rs("companyID")%>"><%=rs("companyID")%>

<% rs.moveNext
wend %>

<%
rs.close
set rs = nothing
MyConn.close
set MyConn = nothing
%>

Any ideas??

Re: Authentication failed error (but not with 127.0.0.1)

I fix'd it but am confused about the solution.

My page was working fine if I called it by 127.0.0.1 but when I called
it by my public IP, i got the error.

I changed my connection string from
MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="&dbSource&""

to

MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="D:\data\mymdb.mdb"

and the page worked.

Any insight??

Thanks