HELP PLEASE ... DATABASE error

prince_bakora · 09-13-2008, 03:02 PM

hi all

I have a problem ... and hope to find the solution

firstly ... I design asp vbscript pages by dreamweaver mx 2004
when I insert in my pages static elements like text and images then preview it ... it works and all right

but if I insert database elements in my page ... then preview it .. browser show me this message

Quote:

The page cannot be displayed

There is a problem with the page you are trying to reach and it cannot be displayed. Please try the following:

Click the Refresh button, or try again later.

Open the localhost home page, and then look for links to the information you want.

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
/twakol/ed.asp, line 8

Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727)

Page:
GET /twakol/ed.asp

Time:
‏13 ‏سبتمبر, ‏2008, 05:55:42 م

More information:
Microsoft Support

or you can see the picture

I tried many databases ... all times have same results

to know :
my OS is XP sp2
I installed
IIS
MDAC
DREAMWEAVER MX 2004

rico1931 · 09-13-2008, 05:25 PM

So what is it that you want exactly? Do you want to know how to set up a DSN? What kind of database do you have? Access, Mysql..??? I bet there are a bunch different ones. You need to give us more information on what you want to do. Oh and welcome to the forum

prince_bakora · 09-13-2008, 08:03 PM

I already know how to set up a DSN ... I make a DSN connection to MS ACCESS database ... and when I use this connection in dreamweaver mx 2004 to insert fields in my page ... this problem starting as the image

can anybody explain me where's the problem ?

rico1931 · 09-13-2008, 09:21 PM

code for the connection you are making please

prince_bakora · 09-13-2008, 11:14 PM

Hi ... first, I want to say thanks

second, I do not use any code .. just design by dreamweaver

but I will show the code of a page and the error message that display when I want to preview it in my browser

the code of the page

Code:

<<A href="mailto:%@LANGUAGE="VBSCRIPT">%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/pein.asp" -->
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_pein_STRING
Recordset1.Source = "SELECT * FROM Employees"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
<p>ألسلام عليكم </p>
<p><%=(Recordset1.Fields.Item("EmployeeID").Value)%></p>
<p><%=(Recordset1.Fields.Item("FirstName").Value)%></p>
<p> <%=(Recordset1.Fields.Item("LastName").Value)%></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>

the error message :

Quote:

The page cannot be displayed

There is a problem with the page you are trying to reach and it cannot be displayed.Please try the following:

<LI id=instructionsText1>Click the Refresh button, or try again later.
Open the localhost home page, and then look for links to the information you want.

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
/myfirstsite/untitled1.asp, line 8
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page:
GET /myfirstsite/untitled1.asp
Time:
‏14 ‏سبتمبر, ‏2008, 02:11:58 ص
More information:
Microsoft Support

this image can help you to view the code

rico1931 · 09-18-2008, 05:44 PM

there is something wrong with the connection. Are you able to view your data when you use dreamweaver to set up the connection? Like when you test it out does the table in the pop up box display your information in the sql table? The connection looks right and other then you missing a few links like

[code]
Dim rsDevice_cmd[code]

daysray · 12-14-2009, 07:11 PM

Hi Prince,
I'm having the same issues. The database info shows up sometimes, but usually not. Did you find out what this problem was?

Thanks.

mangofreak · 01-05-2010, 11:40 PM

Is your IIS setup to serve ASP files?
Does your database have the proper permissions?

daysray · 01-15-2010, 04:37 PM

Yes. Actually, I finally got evey piece of security turned off and it now works on my pc, but when I upload it to the web it doesn't work. I think I've got everything pathed right so now am at a loss...

suzybee · 06-02-2010, 09:54 PM

I was having the same problem with the sever 500 errors so what I did was call my hosting service and made sure I was on the correct server type to read MS Access databases. Then I set up the DSN on the server, had to set up the database connection (using the database window with server behaviors). I had to use the custom connection string (this can be found on your hosting site (absolute path)). Once I had a connection to the database I added another server behavior to login users based on name and password. Everything works now. If your personal computer isn't your hosting/server computer you will not be able to use the DSN (standard) you'll need to get the custom string).
I hope this helped. I've only got as far as loging in users I am still trying to figure out how they can update they display on the page.

01-05-2010, 11:40 PM	#8
mangofreak Join Date: Jan 2006 Location: Toronto-Canada Posts: 444	Is your IIS setup to serve ASP files? Does your database have the proper permissions? __________________ J. DW \| FW \| HTML \| CSS \| ASP \| some PHP \| Windows \| Ubuntu

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

09-13-2008, 05:25 PM	#2
rico1931 Join Date: Jun 2008 Location: Buffalo Posts: 198	So what is it that you want exactly? Do you want to know how to set up a DSN? What kind of database do you have? Access, Mysql..??? I bet there are a bunch different ones. You need to give us more information on what you want to do. Oh and welcome to the forum

09-13-2008, 08:03 PM	#3
prince_bakora Join Date: Sep 2008 Posts: 3	I already know how to set up a DSN ... I make a DSN connection to MS ACCESS database ... and when I use this connection in dreamweaver mx 2004 to insert fields in my page ... this problem starting as the image can anybody explain me where's the problem ?

09-13-2008, 09:21 PM	#4
rico1931 Join Date: Jun 2008 Location: Buffalo Posts: 198	code for the connection you are making please

09-18-2008, 05:44 PM	#6
rico1931 Join Date: Jun 2008 Location: Buffalo Posts: 198	there is something wrong with the connection. Are you able to view your data when you use dreamweaver to set up the connection? Like when you test it out does the table in the pop up box display your information in the sql table? The connection looks right and other then you missing a few links like [code] Dim rsDevice_cmd[code]

12-14-2009, 07:11 PM	#7
daysray Join Date: Dec 2009 Posts: 2	Hi Prince, I'm having the same issues. The database info shows up sometimes, but usually not. Did you find out what this problem was? Thanks.

01-15-2010, 04:37 PM	#9
daysray Join Date: Dec 2009 Posts: 2	Yes. Actually, I finally got evey piece of security turned off and it now works on my pc, but when I upload it to the web it doesn't work. I think I've got everything pathed right so now am at a loss...

06-02-2010, 09:54 PM	#10
suzybee Join Date: Jun 2010 Posts: 4	I was having the same problem with the sever 500 errors so what I did was call my hosting service and made sure I was on the correct server type to read MS Access databases. Then I set up the DSN on the server, had to set up the database connection (using the database window with server behaviors). I had to use the custom connection string (this can be found on your hosting site (absolute path)). Once I had a connection to the database I added another server behavior to login users based on name and password. Everything works now. If your personal computer isn't your hosting/server computer you will not be able to use the DSN (standard) you'll need to get the custom string). I hope this helped. I've only got as far as loging in users I am still trying to figure out how they can update they display on the page.