Stange behaviour with Database Results Wizard - FP2003.
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > FrontPage Server Extensions for Windows > Stange behaviour with Database Results Wizard - FP2003.




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    Stange behaviour with Database Results Wizard - FP2003.  
David Martin


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
02-26-04 05:36 PM

Since upgrading from FP2000  to FP2003 I have a problem that ALL
pages using the database results stop working after a server reboot.

The server is a Windows 2000 server (with all SP's and fixes to date) also
running SQL Server 7.0 (with latest SP). [It's a homeserver].FPserver
extensions2002 are installed.

The databases are defined as machine data sources on the server and use NT
authentication. No log entries are found for the failures in either SQL
Server or Windows 2000 logs. Security fails are set to be logged.

The database results are returned to the client as:
Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

One long query for sure has done the select as a lot of diskactivity occurs
on the server.

Now if I go to the page with FP and edit the database results properties
(changing nothing) and save the page -all pages work fine - yes even ones in
other pages / using other OBDC connectors and databases. (the edit can
either be done on the client or the server.)

I am not sure where the problem is - so please excuse the cross post to both
the client & extensions group.

David.








[ Post a follow-up to this message ]



    Re: Stange behaviour with Database Results Wizard - FP2003.  
Kevin Spencer


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
02-26-04 06:35 PM

> I am not sure where the problem is - so please excuse the cross post to
both
> the client & extensions group.

For future reference: Cross-posting is frowned upon and bad Netiquette.
History is littered with the failures of those who have found their own
custom "exceptions" to established courtesies.

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"David Martin" <David.Martin@skill-it.com> wrote in message
news:us4GU2I$DHA.220@TK2MSFTNGP09.phx.gbl...
> Since upgrading from FP2000  to FP2003 I have a problem that ALL
> pages using the database results stop working after a server reboot.
>
> The server is a Windows 2000 server (with all SP's and fixes to date) also
> running SQL Server 7.0 (with latest SP). [It's a homeserver].FPserver
> extensions2002 are installed.
>
> The databases are defined as machine data sources on the server and use NT
> authentication. No log entries are found for the failures in either SQL
> Server or Windows 2000 logs. Security fails are set to be logged.
>
> The database results are returned to the client as:
> Database Results Wizard Error
> The operation failed. If this continues, please contact your server
> administrator.
>
> One long query for sure has done the select as a lot of diskactivity
occurs
> on the server.
>
> Now if I go to the page with FP and edit the database results properties
> (changing nothing) and save the page -all pages work fine - yes even ones
in
> other pages / using other OBDC connectors and databases. (the edit can
> either be done on the client or the server.)
>
> I am not sure where the problem is - so please excuse the cross post to
both
> the client & extensions group.
>
> David.
>
>
>







[ Post a follow-up to this message ]



    Re: Stange behaviour with Database Results Wizard - FP2003.  
David Martin


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
02-26-04 09:35 PM

O.K.- but which group would you have posted 2 ?

David

"Kevin Spencer" <kevin@takempis.com> wrote in message
news:em7hh$I$DHA.808@TK2MSFTNGP12.phx.gbl... 
> both 
>
> For future reference: Cross-posting is frowned upon and bad Netiquette.
> History is littered with the failures of those who have found their own
> custom "exceptions" to established courtesies.
>
> --
> HTH,
> Kevin Spencer
> .Net Developer
> Microsoft MVP
> Big things are made up
> of lots of little things.
>
> "David Martin" <David.Martin@skill-it.com> wrote in message
> news:us4GU2I$DHA.220@TK2MSFTNGP09.phx.gbl... 
also 
NT 
> occurs 
ones
> in 
> both 
>
>







[ Post a follow-up to this message ]



    Re: Stange behaviour with Database Results Wizard - FP2003.  
Hari


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
02-27-04 04:37 PM

Hi David,

Please check the following KB article.

http://support.microsoft.com/defaul...kb;en-us;817029

Enable (Change to True)  the fp_debug flag in the fpdbrgn1.inc file.  Then
browse the page which contains the database.  You might get a different
error which may help to troublehshoot your problem more clearly.

Hope this helps


regards

Hari
MSFT

This posting is provided "as is" with no warranties and confers no rights






[ Post a follow-up to this message ]



    Re: Stange behaviour with Database Results Wizard - FP2003.  
David Martin


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
03-05-04 10:35 PM

Thank you for your reply,
after much testing & reboots I find that I get the following consistantly,
with debug mode on

Database Results Wizard Error
Description: Class not registered
Number: -2147221164 (0x80040154)
Source: Provider

If I edit the Results of the DB reuslts wizard with FP then (without
changing anything) - I get a the correct result - without saving the file.

Can anyone undersatnda this ?

David.



"David Martin" <David.Martin@skill-it.com> wrote in message
news:%235xGmoK$DHA.212@TK2MSFTNGP12.phx.gbl...
> O.K.- but which group would you have posted 2 ?
>
> David
>
> "Kevin Spencer" <kevin@takempis.com> wrote in message
> news:em7hh$I$DHA.808@TK2MSFTNGP12.phx.gbl... 
to 
> also 
use
> NT 
SQL 
properties 
> ones 
to 
>
>







[ Post a follow-up to this message ]



    Re: Stange behaviour with Database Results Wizard - FP2003.  
Harikumar H [MSFT]


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
11-08-04 10:47 PM

Hi David,

then permissions are set too restrictive on the files necessary to access
the database.

1.  The ADO Folder

This folder is located at C:\program files\common files\system\ado.  The
Everyone
Group or the User logged in should have Read and Execute (RX) access.

2.  The WINNT Folder

This folder is typically located at c:\WINNT.  The Everyone Group or the
User
logged in should have Read, Write, and Execute (RWX) access.

Check the above folder for permissions and then try running the Database
results wizard again.

Hope this helps


regards

Hari
MSFT

This posting is provided "as is" with no warranties and confers no rights
--------------------
| Thank you for your reply,
| after much testing & reboots I find that I get the following consistantly,
| with debug mode on
|
| Database Results Wizard Error
| Description: Class not registered
| Number: -2147221164 (0x80040154)
| Source: Provider
|
| If I edit the Results of the DB reuslts wizard with FP then (without
| changing anything) - I get a the correct result - without saving the file.
|
| Can anyone undersatnda this ?
|
| David.
|
|
|
| "David Martin" <David.Martin@skill-it.com> wrote in message
| news:%235xGmoK$DHA.212@TK2MSFTNGP12.phx.gbl...
| > O.K.- but which group would you have posted 2 ?
| >
| > David
| >
| > "Kevin Spencer" <kevin@takempis.com> wrote in message
| > news:em7hh$I$DHA.808@TK2MSFTNGP12.phx.gbl...
| > > > I am not sure where the problem is - so please excuse the cross post
| to
| > > both
| > > > the client & extensions group.
| > >
| > > For future reference: Cross-posting is frowned upon and bad
Netiquette.
| > > History is littered with the failures of those who have found their
own
| > > custom "exceptions" to established courtesies.
| > >
| > > --
| > > HTH,
| > > Kevin Spencer
| > > .Net Developer
| > > Microsoft MVP
| > > Big things are made up
| > > of lots of little things.
| > >
| > > "David Martin" <David.Martin@skill-it.com> wrote in message
| > > news:us4GU2I$DHA.220@TK2MSFTNGP09.phx.gbl...
| > > > Since upgrading from FP2000  to FP2003 I have a problem that ALL
| > > > pages using the database results stop working after a server reboot.
| > > >
| > > > The server is a Windows 2000 server (with all SP's and fixes to
date)
| > also
| > > > running SQL Server 7.0 (with latest SP). [It's a
homeserver].FPserver
| > > > extensions2002 are installed.
| > > >
| > > > The databases are defined as machine data sources on the server and
| use
| > NT
| > > > authentication. No log entries are found for the failures in either
| SQL
| > > > Server or Windows 2000 logs. Security fails are set to be logged.
| > > >
| > > > The database results are returned to the client as:
| > > > Database Results Wizard Error
| > > > The operation failed. If this continues, please contact your server
| > > > administrator.
| > > >
| > > > One long query for sure has done the select as a lot of diskactivity
| > > occurs
| > > > on the server.
| > > >
| > > > Now if I go to the page with FP and edit the database results
| properties
| > > > (changing nothing) and save the page -all pages work fine - yes even
| > ones
| > > in
| > > > other pages / using other OBDC connectors and databases. (the edit
can
| > > > either be done on the client or the server.)
| > > >
| > > > I am not sure where the problem is - so please excuse the cross post
| to
| > > both
| > > > the client & extensions group.
| > > >
| > > > David.
| > > >
| > > >
| > > >
| > >
| > >
| >
| >
|
|
|







[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 12:31 AM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register