Display records

[frankhdata]

Hi

http://www.w3schools.com/ado/showasp.asp?filename=demo_display1

I would like to do the same
This is what i have tried
conn.Open(Server.Mappath("/northwind.mdb"))
Both files are in the same directory
This is what the result is
The page cannot be displayed

 

[Chopstik]

Is your Northwind.mdb file in the same directory? If so (which you say they are), then what is the exact error message that you are getting on the page?

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[BDC2]

If you are using IE, go to tools | Internet Options...
Click the Advanced Tab and UNCHECK "Show friendly HTTP error messages".

This should give you a more comprehensive error message rather than "page cannot be displayed"

BDC.

 

[frankhdata]

Hi People


Microsoft JET Database Engine error '80004005'

Could not find file 'C:\Accounts\mysite\

http://wwwRoot\northwind.mdb'.

/Samples/Untitled-1.asp, line 7

Thanks

 

[frankhdata]

Hi
this is what i have on line 7
conn.Open(Server.Mappath("/northwind.mdb"))

 

[Chopstik]

You have the wrong slash. Try this:

conn.Open(Server.Mappath("[COLOR=red]\[/color]northwind.mdb"))

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[frankhdata]

Hi Chopstik


I just tried what you said.
I am getting the same error message
Thanks

 

[BDC2]

Is you database in 'C:\Accounts\mysite\

http://wwwRoot\northwind.mdb'?

Your error suggests that your asp file is in a folder called samples but I thought that your database and ASP files were in the same folder?

Can you tell us your file structure and exactly where your database and ASP files exist within it?

BDC.

 

[frankhdata]

Hi BDC2 !

Both Untitled-1.asp and Northwind.mdb are in this Samples folder.

ftp://mysite.com/

http://wwwRoot/Samples/

Thanks

 

[theniteowl]

Then your line should go like:
conn.Open(Server.Mappath("/samples/northwind.mdb"))

Unless I am mistaken, Server.Mappath will give you the path up to the

http://wwwroot

directory and you have to specify the subfolders from there.


It's hard to think outside the box when I'm trapped in a cubicle.

 

[theniteowl]

OH, another thing. When you use an Access database the IUSR_machinename account must have Create permission in the folder the database resides in. When an Access database is opened it creates a .LDB file as a lock file and if the IUSR account does not have create permission the file cannot be created and therefore the database not opened.


It's hard to think outside the box when I'm trapped in a cubicle.

 

[frankhdata]

Hi Guys !

The problem is solved.
Thanks very much.