Forum Moderators: open

Message Too Old, No Replies

access db problem

         

NeRu

3:48 pm on Feb 7, 2006 (gmt 0)

10+ Year Member



hi

i have build an asp based web page with access db by using dreamweaver. in the local it works perfect, but not working in my host. i could not do the db connection in the host.

help me :S

wingnut

7:30 pm on Feb 7, 2006 (gmt 0)

10+ Year Member



You need to find the path to the access file.

create a asp page call test.asp (see below): Upload to directory and type address in your browser to test.asp. This will return the server variables, one of which will be the path information. You should be able to work out the path the access file, put that into your connection string.

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<div align="left">
<table border="0" cellpadding="0" cellspacing="0" width="750">
<tr>
<td valign="top" align="left" width="150"><font face="Arial" size="2" color="#FF0000"><b>Variable Name</b></font></td>
<td valign="top" align="left" width="600"><font face="Arial" size="2"><b>Value</font></b></td>
</tr>
<%
for each name in request.servervariables
%>
<tr>
<td valign="top" align="left" width="150">
<font face="Arial" size="1" color="#FF0000">
<%= name %></font></td>
<td valign="top" align="left" width="600">
<font face="Arial" size="1"><%= request.servervariables(name) %></font></td>
</tr>

<%
Next
%>
</table>
</div>
</body>
</html>