|
Home > Archive > FrontPage Server Extensions for Windows > September 2005 > Does Server Require MS Office to be installed
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Does Server Require MS Office to be installed
|
|
| Michael L. 2005-08-31, 5:58 pm |
| Does a FrontPage Server, running the latest version of FP Extension, require
MS Office to be installed on the machine. I am trying to read and write to an
MS Access db, and I get this error.
Database Results Error
Description: Class not registered
Number: -2147221164 (0x80040154)
Source: Provider
| |
| Mark Fitzpatrick 2005-09-01, 5:55 pm |
| No, MS Office is not required. It could be that the data source provider is
not registered or something. Can you post more information about the error,
including perhaps a code sample. Specifically looking at the connection
string used to connect, as well as the Server.CreateObject statement being
used as that is the statement that throws this error, but not knowing which
control is being requested it's impossible to tell which one is not
registered.
Hope this helps
Mark Fitzpatrick
Microsoft MVP - FrontPage
"Michael L." <MichaelL@discussions.microsoft.com> wrote in message
news:8ABB02FF-3FA3-4478-A5FD-9CF4EB069238@microsoft.com...
> Does a FrontPage Server, running the latest version of FP Extension,
> require
> MS Office to be installed on the machine. I am trying to read and write to
> an
> MS Access db, and I get this error.
>
> Database Results Error
> Description: Class not registered
> Number: -2147221164 (0x80040154)
> Source: Provider
>
| |
| Michael L. 2005-09-02, 5:55 pm |
| Thanks for the reply, here is my global.asp
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Application_OnStart
'==FrontPage Generated - startspan==
Dim FrontPage_UrlVars(1)
'--Project Data Connection
Application("Database1_ConnectionString") =
"DSN=Database1;DRIVER={Microsoft Access Driver (*.mdb)}"
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
Any the begining of the webpage code. NOTE: I am using the DBRW
<!--webbot bot="DatabaseRegionStart" startspan s-columnnames="AvgOfScore"
s-columntypes="202" s-dataconnection="Database1" b-tableformat="FALSE"
b-menuformat="FALSE" s-menuchoice="AvgOfScore" s-menuvalue="AvgOfScore"
b-tableborder="TRUE"
b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE"
b-listseparator="TRUE" i-ListFormat="0" b-makeform="TRUE"
s-recordsource="callcenterReport" s-displaycolumns="AvgOfScore" s-criteria
s-order s-sql="SELECT * FROM callcenterReport" b-procedure="FALSE" clientside
SuggestedExt="asp" s-DefaultFields s-NoRecordsFound="No records returned."
i-MaxRecords="256" i-GroupSize="0" BOTID="2" u-dblib="qa/_fpclass/fpdblib.inc"
u-dbrgn1="qa/_fpclass/fpdbrgn1.inc" u-dbrgn2="qa/_fpclass/fpdbrgn2.inc"
tag="BODY"
local_preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"
align="left"><font color="#000000">Database Results regions will not preview
unless this page is fetched from a Web server using a web browser. The
section of the page from here to the end of the Database Results region will
repeat once for each record returned by the query.</font></td></tr></table>"
preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"
align="left"><font color="#000000">This is the start of a Database Results
region.</font></td></tr></table>" b-WasTableFormat="FALSE" --><!--#include
file="qa/_fpclass/fpdblib.inc"-->
Does any of this help at all? I put the full error below.
"Mark Fitzpatrick" wrote:
> No, MS Office is not required. It could be that the data source provider is
> not registered or something. Can you post more information about the error,
> including perhaps a code sample. Specifically looking at the connection
> string used to connect, as well as the Server.CreateObject statement being
> used as that is the statement that throws this error, but not knowing which
> control is being requested it's impossible to tell which one is not
> registered.
>
> Hope this helps
> Mark Fitzpatrick
> Microsoft MVP - FrontPage
>
> "Michael L." <MichaelL@discussions.microsoft.com> wrote in message
> news:8ABB02FF-3FA3-4478-A5FD-9CF4EB069238@microsoft.com...
>
>
>
|
|
|
|
|