The asp page works fine with Access database if both are located at the

same machine.  It would give me error message like the following:



Microsoft JET Database Engine error '80004005' 

'\\Felicity\Inetpub\wwwroot\floodProject\FloodPlain.mdb' isn't a valid

path. Make sure that the path name is spelled correctly and that you are

connected to the server on

which the file resides. 

/fpm/ProcForm.asp, line 32 



The following is the connection string.  Felicity is the computer name and

running Window NT and has PWS installed. "d" drive is a shared drive. Am I

doing it right?  Please help!

<%

StrConnect = "Provider=Microsoft.Jet.OLEDB.3.51;" & _

             "Data

Source=\\Felicity\d:\Inetpub\wwwroot\floodProject\FloodPlain.mdb"

%>

Be sure you make this reference:



<!-- #INCLUDE FILE="adovbs.inc" -->



which I think is available from WROX. Then try



filePath = Server.MapPath("yourdatabase.mdb")

Set oConn = Server.CreateObject("ADODB.Connection")

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filePath

Set oRs = oConn.Execute("SELECT.....



Be sure to dimension your variables. This works for me.



Curtis F. Barnett

SailorSoft.com

cfb@s... <mailto:cfb@s...>



> -----Original Message-----

> From: amandat@w... [mailto:amandat@w...]

> Sent: Friday, September 22, 2000 4:25 PM

> To: ASP Databases

> Subject: [asp_databases] Felicity error 80004005

>

>

> The asp page works fine with Access database if both are located at the

> same machine.  It would give me error message like the following:

>

> Microsoft JET Database Engine error '80004005'

> '\\Felicity\Inetpub\wwwroot\floodProject\FloodPlain.mdb' isn't a valid

> path. Make sure that the path name is spelled correctly and that you are

> connected to the server on

> which the file resides.

> /fpm/ProcForm.asp, line 32

>

> The following is the connection string.  Felicity is the computer name and

> running Window NT and has PWS installed. "d" drive is a shared drive. Am I

> doing it right?  Please help!

> <%

> StrConnect = "Provider=Microsoft.Jet.OLEDB.3.51;" & _

>              "Data

> Source=\\Felicity\d:\Inetpub\wwwroot\floodProject\FloodPlain.mdb"

> %>

>

>

*********** REPLY SEPARATOR  ***********



On 22/9/00 at 22:24 amandat@w... wrote:



>Source=\\Felicity\d:\Inetpub\wwwroot\floodProject\FloodPlain.mdb"



	If you have shared d:, you should use

\\Felicity\name_you_gave_when_you_the_shared_the_resource\inetpub.....





Fidel Leon - EA3GIP

ea3gip@p...