data access with asp

[Guest]

We have the code below in a webpage




If IsObject(Session("portal_conn")) Then
Set conn = Session("portal_conn")
Else
Set conn = Server.CreateObject("ADODB.Connection")
cConnString = "Provider=vfpoledb;Data
Source="+session("portaldata")+"portal.dbc"
conn.open cConnString,"",""
Set Session("portal_conn") = conn
End If


This code works perfectly from within the lan accessing the site by ip
address.

However when the site is accessed from the internet the "ADODB.Connection"
is not created.

The site is running on a 2003 server, the anonymous user is set to an
account which has administrator rights and it still will not work.

We have tried running in iis isolation mode 5 and 6 which makes no
difference at all.

Any help on this would be greatly appreciated.

Thanks in advance

Dave

 

[David Berry]

Have you tried updating the Visual FoxPro OLE DB provider? See
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForVisualFoxPro
for information