ASP.NET Forum

**Johntech** · 09-12-2006, 08:53 PM

I have a project where there is a parts diagram with hot spots on it. When you click on a part on the diagram,a box will pop up with all the information about the part. I believe Chip Johns was helping me with the project in this forum. I have moved the project to another system and it doesn not work on the new system. The original system was on a XP PRO laptop. I have moved it to a W2k system. Now when you click on the hot spot the pop up box displays the following message:

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] 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.
/DisplayPart.asp, line 27
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Page:
GET /DisplayPart.asp
Time:
Tuesday, September 12, 2006, 7:45:36 PM

Here is the program listing:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
' Program name - DisplayPart.asp

' Beginning of ASP code
'Use to make sure ALL variables are dimentioned
Option Explicit
'Set up the Dim statements for your connection and the sql statement
Dim objConnection, objRS, strQuery
Dim strConnection
'Dimention the receiving string
Dim sPart
'sPart is the receiving part number
sPart = Request.QueryString("part")
' change YourDSN to the name you gave the DSN datasource
set objConnection = Server.CreateObject("ADODB.Connection")
'The data source is PARTS as created in the Data Source in the control panel
strConnection = "Data Source=Parts;"
'Open the connection to the database
objConnection.Open strConnection
'Set the connections for the recordset
Set objRS = Server.CreateObject("ADODB.Recordset")
Set objRS.ActiveConnection = objConnection
'Build the SQL statement to access the RecordSet
strQuery = "SELECT * FROM tblPartsList Where PartNo = '" & sPart & "'"
'Run the query
objRS.Open strQuery
'End of ASP code
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Part Information</title>
</head>
<body>

<%
'Beginning of ASP code
Response.Write "Part No. : "
Response.Write objRS("PartNo")
Response.Write " Discription : "
Response.Write objRS("Description")
Response.Write " Quantity : "
Response.Write objRS("Quantity")
Response.Write " Cabinet Location : "
Response.Write objRS("Location")
Response.Write " Comments : "
Response.Write objRS("Comments")
'End of ASP code
%>
 
<A href="javascript: self.close ()">Close</A>
<a href="javascript: parent.refresh()"></a>
</body></html>

On the page with the hot spots, here is the HREF that passes the part number to the display program :
HREF=http://localhost/DisplayPart.asp?part=Y280054

Any help would be greatly appreciated!!

john

**chrishirst** · 09-13-2006, 06:58 AM

probably the path to the .mdb file is wrong.

is the DSN setup on the server ?

**Johntech** · 09-13-2006, 04:10 PM

Quote:

Originally Posted by chrishirst

probably the path to the .mdb file is wrong.

is the DSN setup on the server ?

This is running off of a stand-alone system. I tried to set it up just like it was
set up on my laptop which is running XP PRO and works great on it. But I am trying to move it over to a W2K machine with no luck.

When I was working with Chip Johns I tried to document everything as I went. The only thing different, that I can see, is the operating system.

**Johntech** · 09-13-2006, 04:20 PM

Quote:

Originally Posted by chrishirst

probably the path to the .mdb file is wrong.

is the DSN setup on the server ?

I also know that the internal server is working because I can run a small program on the W2K machine that displays the time:

<html>
<head>
<title>Server Time </title>
</head>
<body>
<%
response.write "The server time is now:"
response.write time
response.write ""
%>
</body>
</html>

Being new to ASP makes it harder to understand why things aren't working

John

**Johntech** · 09-13-2006, 04:23 PM

Quote:

Originally Posted by chrishirst

probably the path to the .mdb file is wrong.

is the DSN setup on the server ?

Maybe I shoud somehow hard code the connection to the database??????

Any thoughts on this or directions??

Thanks for your help

John

**Johntech** · 09-13-2006, 04:25 PM

Quote:

Originally Posted by chrishirst

probably the path to the .mdb file is wrong.

is the DSN setup on the server ?

Is there a way to hard code the path to the database ????

Any thoughts or ideas??

John

**chrishirst** · 09-13-2006, 05:51 PM

using a connection string is less fraught with issues when moving between systems

to hardcode it use;

Code:

strConnection = "Driver= {MicrosoftAccessDriver(*.mdb)};DBQ=C:\webroot\DbName.mdb;"

if the mdb will remain in the same folder relative to the site

Code:

strConnection = "Driver= {MicrosoftAccessDriver(*.mdb)};DBQ=" & server.mappath("/path/DbName.mdb") & ";"

the above are for ODBC.

the preferred method is to use OLEDB

Hardcoded;

Code:

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\webroot\DbName.mdb;"

Relative;

Code:

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("/path/DbName.mdb") & ";"

**Johntech** · 09-13-2006, 06:26 PM

Hi Chris

There must be something different in the software on the W2K machine. I tried all of the code you mentioned above and I still can't display any data.

From the code I sent in a previous post, directly from the working laptop, everything works up to the point that the popup window displays then that is where the error is displayed in the popup window.

I'm not sure what else to try.

John