| Author |
Stange behaviour with Database Results Wizard - FP2003.
|
|
| David Martin 2004-02-26, 12: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.
| |
| Kevin Spencer 2004-02-26, 1: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.
>
>
>
| |
| David Martin 2004-02-26, 4: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[color=darkred]
NT[color=darkred]
> occurs
ones[color=darkred]
> in
> both
>
>
| |
|
| 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
| |
| David Martin 2004-03-05, 5: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[color=darkred]
> also
use[color=darkred]
> NT
SQL[color=darkred]
properties[color=darkred]
> ones
to[color=darkred]
>
>
| |
| Harikumar H [MSFT] 2004-11-08, 5: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.
| > > >
| > > >
| > > >
| > >
| > >
| >
| >
|
|
|
|
|
|
|