 |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Dreamweaver (all versions) section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
December 8th, 2004, 04:39 AM
|
|
Authorized User
|
|
Join Date: Dec 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
The page cannot be displayed
I got a IIS server with ASP and using a Access database with ODBC coonection to the database with dsn. I am doing a user authentication within dreamweaver but everytime I go to load the page it comes up with the error "The page cannot be displayed." Here is the technical information it posts:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
/evers/login.asp, line 14
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Page:
POST 45 bytes to /evers/login.asp
POST Data:
username=admin&password=password&Submit=Login ...
Ive tryed everything. I was going to switch over to PHP but Im not good at all with PHP. Still in process of opening book to read it. thanks in advance for the help.
-Jerry
|
|
December 8th, 2004, 05:17 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
|
|
December 8th, 2004, 02:53 PM
|
|
Authorized User
|
|
Join Date: Dec 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Imar,
I tried that but it didnt seem to work. I gotta go to work now but will try when I get home some modifications of it. Do you have any other ideas. I appreciate all the help you are giving me. How do you know all this information man? You must have been doing this for some time now. lol. Anyways thanks.
-Jerry
|
|
December 8th, 2004, 03:08 PM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Well, I read a lot. It;s amazing what you can find in books and on the Web. Also, I have doing this for a couple of years professionally....
Anyway, you could try to drop the dsn connection and use OleDb. Not that it will take away the error, but it will be easier for us to see if you use the right database / connection.
Also, make sure the database is not marked as read-only under Windows....
HtH,
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
|
|
December 8th, 2004, 09:32 PM
|
|
Authorized User
|
|
Join Date: Dec 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
What do you mean by use OleDb. You mean jsut type in all the information via the asp page. I tried that and it still comes up with a error saying it cant connect. Here is the error it comes up with:
Technical Information (for support personnel)
Error Type:
Microsoft JET Database Engine (0x80004005)
Unspecified error
/evers/login.asp, line 14
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Page:
POST 45 bytes to /evers/login.asp
POST Data:
username=admin&password=password&Submit=Login
Grr. This is a pain in the butt. lol. Thanks for the help Imar.
-Jerry
|
|
December 11th, 2004, 06:48 AM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
What I meant with OleDb is to use an in-line OleDb connection string, rather than an DSN. For an example, look here:
http://Imar.Spaanjaars.Com/QuickDocID.aspx?QUICKDOC=284
You can see that the Data Source in MyConnectionString points to an .mdb file directly.
What are the settings for the folder where your .mdb file resides? What accounts have what permissions?
I still think this is a security issue....
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
|
|
December 11th, 2004, 03:15 PM
|
|
Authorized User
|
|
Join Date: Dec 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
What I did was i tried all this in ASPX and I used some premade scripts and put it all on my machine and had it access the access database it had with it and it all worked fine. I think I found the problem. I have XP Office on my laptop. Would this make the Provider=Microsoft.Jet.OLEDB.4.0 be different. I am going to test this to see if it works. Thanks for the help. Will post when I find out.
-jerry
|
|
December 11th, 2004, 03:27 PM
|
|
Authorized User
|
|
Join Date: Dec 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
That didnt seem to work to well, now Dreamweaver gives me a error of 'Unspecified error'.
-Jerry
The permissions are set to Full Control. I tried the only read & write. But htat didnt work either. I have it on the folder that the databases are in for the user IUSR_MALYCOMP. Malycomp is the name of my server.
-Jerry
|
|
December 11th, 2004, 07:17 PM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Hi again,
Does Dreamweaver give you this error, or do you get this error when you run the page?
Also, are you sure your Website actually runs under the IUSR account (in anonymous mode??)
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
|
|
December 11th, 2004, 09:19 PM
|
|
Authorized User
|
|
Join Date: Dec 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Ok I can get websites to access 'Access' databases, dreamweaver is giving me the code at the moment. This new one. Forget the first two. I know that this is dreamweaver now. the otehr errors was the server, not dreamweaver. This whole thing is pissing me off. I put SQL Server 2000 back on and now it wont even be seen by dreamweaver. For some reason dreamweaver is giving me a lot of problems now.
|
|
|
