navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

Frontpgae 2002 and 2003

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Frontpgae 2002 and 2003
Page: [1]
 
yuanchih_chen

 

Posts: 2
Joined: 4/3/2004
Status: offline

 
Frontpgae 2002 and 2003 - 4/3/2004 7:44:50   
Dear everyone:
I just used frontpage 2003 and tested Database Wizard. Something happen:) ? ASP.NET can use, but ASP cannot work and show me
" Database Results Wizard Error The operation failed. If this continues, please contact your server administrator."

Later on , I changed to frontpage 2002 and used Database Wizard again. It shows me
" Database Results Error
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xdc0 Thread 0xa2c DBC 0x10b6cdc Jet'."

I used Microsoft Windows XP , Access 2000, and Visual Studio.NET 2002 if they would cause my Database Wizard of Frontpage make mistakes??

I didn't change any code from frontpage after finishing Database Wizard , but my disk -base webpage showed me error messages in my desktop again and again. :).

------somebody help me:)
Spooky

 

Posts: 26597
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: Frontpgae 2002 and 2003 - 4/3/2004 15:47:36   
Hi and welcome :)
Try these:

http://www.frontpagewebmaster.com/m-175524/tm.htm

and

http://www.frontpagewebmaster.com/searchpro.asp?phrase=%28volatile%29&author=&forumid=6&topicreply=both&message=body&timeframe=%3E&timefilter=0&language=single&top=300&criteria=AND&minRank=0&sortMethod=r&submitbutton=+OK+

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)


(in reply to yuanchih_chen)
yuanchih_chen

 

Posts: 2
Joined: 4/3/2004
Status: offline

 
RE: FrontPgae 2002 and 2003 - 4/4/2004 10:48:28   
Dear web expert:

First,I saw Microsoft resource like that

1. Start Registry Editor (Regedt32.exe).
2. Select the following key in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
3. On the Security menu, click Permissions.
4. Type the required permissions for the account that is accessing the Web page.
5. Quit Registry Editor.

However, I am not sure what should I type for" required permissions for the account that is accessing the Web page":)

Second, I found that IIS problem about IUSR_xxxxx user account from Doug G, but I am not sure where my IUSR_xxxxx of a account a member of the Administrators group is and how/what I can change permission for ??:)

Third, I read microsoft resource:
Note An easier way to perform this task is to click Start, click Run, type %temp%, and then press Enter.
2. Start Windows Explorer.
3. In Folders view, expand the path to your temporary folder.
4. Right-click the folder and click Properties on the shortcut menu.
5. On the Security tab, add Everyone to the existing permissions, assign it Change permissions, and apply these new settings to all files and subfolders.
6. Click OK

I done that, not work!

Fourth, I change something like that
fp_DEBUG = False

to :

fp_DEBUG = True

well, my error of Database Wizard became registry key 'Temporary (volatile):)
Fifth,
here is a FrontPage 2003 code of global.asa
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Application_OnStart
'==FrontPage Generated - startspan==
Dim FrontPage_UrlVars(1)
'--Project Data Connection
Application("database1_ConnectionString") = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/database1.mdb"
FrontPage_UrlVars(0) = "database1_ConnectionString"
Application("database1_ConnectionTimeout") = 15
Application("database1_CommandTimeout") = 30
Application("database1_CursorLocation") = 3
Application("database1_RuntimeUserName") = ""
Application("database1_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>
Finally, hope I can find a solution:)

(in reply to Spooky)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Frontpgae 2002 and 2003
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts