Gregory,
Here is my global.ASA file:
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Application_OnStart
'==FrontPage Generated - startspan==
Dim FrontPage_UrlVars(2)
'--Project Data Connection
Application("intranet_ConnectionString")
= "DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=fpdb/intranet.mdb"
FrontPage_UrlVars(0)
= "intranet_ConnectionString"
Application("intranet_ConnectionTimeout")
= 15
Application("intranet_CommandTimeout") =
30
Application("intranet_CursorLocation") = 3
Application("intranet_RuntimeUserName")
= ""
Application("intranet_RuntimePassword")
= ""
'--Project Data Connection
Application
("forumdatabase_ConnectionString") = "DRIVER={Microsoft
Access Driver (*.mdb)};DBQ=URL=fpdb/snitz_forums_2000.mdb"
FrontPage_UrlVars(1)
= "forumdatabase_ConnectionString"
Application
("forumdatabase_ConnectionTimeout") = 15
Application
("forumdatabase_CommandTimeout") = 30
Application
("forumdatabase_CursorLocation") = 3
Application
("forumdatabase_RuntimeUserName") = ""
Application
("forumdatabase_RuntimePassword") = ""
'--
Application("FrontPage_UrlVars") =
FrontPage_UrlVars
'==FrontPage Generated - endspan==
End Sub
Sub Session_OnStart
FrontPage_StartSession '==FrontPage Generated==
End Sub
Sub FrontPage_StartSession
On Error Resume Next
if Len(Application("FrontPage_VRoot")) > 0 then
Exit Sub
sFile = "global.asa"
sRootPath = Request.ServerVariables
("APPL_PHYSICAL_PATH")
if Left(sRootPath,1) = "/" then sSep = "/" else
sSep = "\"
if Right(sRootPath,1) <> sSep then sRootPath =
sRootPath & sSep
sRootPath = sRootPath & sFile
' discover the VRoot for the current page;
' walk back up VPath until we match VRoot
Vroot = Request.ServerVariables("PATH_INFO")
iCount = 0
do while Len(Vroot) > 1
idx = InStrRev(Vroot, "/")
if idx > 0 then
Vroot = Left(Vroot,idx)
else
' error; assume root web
Vroot = "/"
end if
if Server.MapPath(Vroot & sFile) =
sRootPath then exit do
if Right(Vroot,1) = "/" then Vroot = Left
(Vroot,Len(Vroot)-1)
iCount = iCount + 1
if iCount > 100 then
' error; assume root web
Vroot = "/"
exit do
end if
loop
' map all URL= attributes in _ConnectionString
variables
Application.Lock
if Len(Application("FrontPage_VRoot")) = 0 then
Application("FrontPage_VRoot") = Vroot
UrlVarArray = Application
("FrontPage_UrlVars")
for i = 0 to UBound(UrlVarArray)
if Len(UrlVarArray(i)) > 0 then
FrontPage_MapUrl(UrlVarArray(i))
next
end if
Application.Unlock
End Sub
Sub FrontPage_MapUrl(AppVarName)
' convert URL attribute in conn string to
absolute file location
strVal = Application(AppVarName)
strKey = "URL="
idxStart = InStr(strVal, strKey)
If idxStart = 0 Then Exit Sub
strBefore = Left(strVal, idxStart - 1)
idxStart = idxStart + Len(strKey)
idxEnd = InStr(idxStart, strVal, ";")
If idxEnd = 0 Then
strAfter = ""
strURL = Mid(strVal, idxStart)
Else
strAfter = ";" & Mid(strVal, idxEnd + 1)
strURL = Mid(strVal, idxStart, idxEnd -
idxStart)
End If
strOut = strBefore & Server.MapPath(Application
("FrontPage_VRoot") & strURL) & strAfter
Application(AppVarName) = strOut
End Sub
</SCRIPT>
<head><title>Web Settings for Active Server
Pages</title><html xmlns:mso="urn:schemas-microsoft-
com
ffice
ffice" xmlns:msdt="uuid:C2F41010-65B3-11d1-
A29F-00AA00C14882">
<!--[if gte mso 9]><xml>
<mso:CustomDocumentProperties>
<mso:connectionstatus msdt:dt="string">intranet=1
forumdatabase=1</mso:connectionstatus>
</mso:CustomDocumentProperties>
-----Original Message-----
The error indicates the OleDb provider is not finding the Access database.
If every ASP page connects to data, you will have the same error on every
page. Best bet is to write the following line:
Call Response.Write(connString)
Call Response.Flush
You will have to look at the ASP page and see what the variable name for
connString (connection String) is for the connection object. As another
option:
Call Response.Write(objConn.ConnectionString)
If you do not see an explicit connection object, you will have to create one
from the ActiveConnection property of the command object. If recordset is
used and creating everything else implicitly, you will HAVE to find the
variable with the connection string. This is in the global.asa file if
FrontPage created it.
I would then check the path to the .mdb file via ASP. I do not have the
syntax. If this path does not match the path in the connection string, you
have found your problem.
Hope this gets you on the right path.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
********************************************************* *************
Think Outside the Box!
********************************************************* *************
I am getting the following error:
Database Results Error
[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is
not a valid path. Make sure that the path name is spelled
correctly and that you are connected to the server on
which the file resides.
I re-published from my laptop to the server overwriting
all files. I can view HTM files but not asp pages.
I went onto the site live and verified that the DRW pages
are seeing the database. They are. I recalculated the
site and re-verified the database connections.
Nothing is working.
Any insight would be appreciated.
-M
.
