Hello
We have made a database installed it on MS SQL server version 8.0.0.760 (SP3) running on Win NT 4.0 (SP6a) danish. The database is accessed from a program made with delphi 6, and it uses BDE.
The problem is when we start the program, it says :
Field 'V=E6rdi' not found.
This field is accessed by a view called Xsystem:
which contain: select * from Xtable.
This problem is not found on another PC runnig Windows 2000 (sp3). On this PC it work fine.
Any Help pleaseHi,
TRY FOR TEST
CREATE VIEW TESTVIEW AS
SELECT "Værdi" AS Vaerdi from Xtable
>We have made a database installed it on MS SQL server
>version 8.0.0.760 (SP3) running on Win NT 4.0 (SP6a)
>danish. The database is accessed from a program made with
>delphi 6, and it uses BDE.
Check version of Middlewares
MDAC
BDE
--
SHINICHI YONEDA MXL04371@.nifty.ne.jp
Microsoft Most Valuable Professional
MVP for SQL Server 2002-2003|||Thank you Mr. SHINICHI YONEDA for your reply.
I will try this.
>--Original Message--
>Hi,
> TRY FOR TEST
>CREATE VIEW TESTVIEW AS
>SELECT "V=E6rdi" AS Vaerdi from Xtable
>>We have made a database installed it on MS SQL server
>>version 8.0.0.760 (SP3) running on Win NT 4.0 (SP6a)
>>danish. The database is accessed from a program made with
>>delphi 6, and it uses BDE.
> Check version of Middlewares
>MDAC
>BDE
>--
>SHINICHI YONEDA MXL04371@.nifty.ne.jp
>Microsoft Most Valuable Professional
>MVP for SQL Server 2002-2003
>.
>
Showing posts with label accessed. Show all posts
Showing posts with label accessed. Show all posts
Thursday, March 29, 2012
Friday, March 9, 2012
Faster than Access?
I currently have an Access database that has numerous forms, tables, reports, etc. Although it works fine over our LAN, it is very slow when accessed from a second site over our VPN. Will migrating this application to SQL Server give me faster response?
Ken
Probably not; it sounds like your response issues are due to network
latency. Data is still data whether it's being sent by SQL Server or
Access...
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken
|||> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
In and of itself? Probably not. Your bottleneck is much more likely to be
the network as opposed to the data access layer.
While you can't just migrate your forms and reports to SQL Server, it is
likely that redesigning them might offer you the opportunity to improve
efficiency there...
http://www.aspfaq.com/
(Reverse address to reply.)
|||If you can move your users to Terminal Services and connect to the machine
(assuming it's hosted on Windows Server) hosting the Access database (or at
least a machine on the LAN), the speed will increase dramatically. I had a
client with the same problem and it appeared the latency in copying the .mdb
file(s) over VPN was what was slowing the application down.
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken
Ken
Probably not; it sounds like your response issues are due to network
latency. Data is still data whether it's being sent by SQL Server or
Access...
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken
|||> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
In and of itself? Probably not. Your bottleneck is much more likely to be
the network as opposed to the data access layer.
While you can't just migrate your forms and reports to SQL Server, it is
likely that redesigning them might offer you the opportunity to improve
efficiency there...
http://www.aspfaq.com/
(Reverse address to reply.)
|||If you can move your users to Terminal Services and connect to the machine
(assuming it's hosted on Windows Server) hosting the Access database (or at
least a machine on the LAN), the speed will increase dramatically. I had a
client with the same problem and it appeared the latency in copying the .mdb
file(s) over VPN was what was slowing the application down.
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken
Faster than Access?
I currently have an Access database that has numerous forms, tables, reports, etc. Although it works fine over our LAN, it is very slow when accessed from a second site over our VPN. Will migrating this application to SQL Server give me faster response?
KenProbably not; it sounds like your response issues are due to network
latency. Data is still data whether it's being sent by SQL Server or
Access...
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken|||> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
In and of itself? Probably not. Your bottleneck is much more likely to be
the network as opposed to the data access layer.
While you can't just migrate your forms and reports to SQL Server, it is
likely that redesigning them might offer you the opportunity to improve
efficiency there...
--
http://www.aspfaq.com/
(Reverse address to reply.)|||If you can move your users to Terminal Services and connect to the machine
(assuming it's hosted on Windows Server) hosting the Access database (or at
least a machine on the LAN), the speed will increase dramatically. I had a
client with the same problem and it appeared the latency in copying the .mdb
file(s) over VPN was what was slowing the application down.
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken
KenProbably not; it sounds like your response issues are due to network
latency. Data is still data whether it's being sent by SQL Server or
Access...
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken|||> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
In and of itself? Probably not. Your bottleneck is much more likely to be
the network as opposed to the data access layer.
While you can't just migrate your forms and reports to SQL Server, it is
likely that redesigning them might offer you the opportunity to improve
efficiency there...
--
http://www.aspfaq.com/
(Reverse address to reply.)|||If you can move your users to Terminal Services and connect to the machine
(assuming it's hosted on Windows Server) hosting the Access database (or at
least a machine on the LAN), the speed will increase dramatically. I had a
client with the same problem and it appeared the latency in copying the .mdb
file(s) over VPN was what was slowing the application down.
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken
Faster than Access?
I currently have an Access database that has numerous forms, tables, reports
, etc. Although it works fine over our LAN, it is very slow when accessed f
rom a second site over our VPN. Will migrating this application to SQL Serv
er give me faster response?
KenProbably not; it sounds like your response issues are due to network
latency. Data is still data whether it's being sent by SQL Server or
Access...
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken|||> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
In and of itself? Probably not. Your bottleneck is much more likely to be
the network as opposed to the data access layer.
While you can't just migrate your forms and reports to SQL Server, it is
likely that redesigning them might offer you the opportunity to improve
efficiency there...
http://www.aspfaq.com/
(Reverse address to reply.)|||If you can move your users to Terminal Services and connect to the machine
(assuming it's hosted on Windows Server) hosting the Access database (or at
least a machine on the LAN), the speed will increase dramatically. I had a
client with the same problem and it appeared the latency in copying the .mdb
file(s) over VPN was what was slowing the application down.
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken
, etc. Although it works fine over our LAN, it is very slow when accessed f
rom a second site over our VPN. Will migrating this application to SQL Serv
er give me faster response?
KenProbably not; it sounds like your response issues are due to network
latency. Data is still data whether it's being sent by SQL Server or
Access...
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken|||> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
In and of itself? Probably not. Your bottleneck is much more likely to be
the network as opposed to the data access layer.
While you can't just migrate your forms and reports to SQL Server, it is
likely that redesigning them might offer you the opportunity to improve
efficiency there...
http://www.aspfaq.com/
(Reverse address to reply.)|||If you can move your users to Terminal Services and connect to the machine
(assuming it's hosted on Windows Server) hosting the Access database (or at
least a machine on the LAN), the speed will increase dramatically. I had a
client with the same problem and it appeared the latency in copying the .mdb
file(s) over VPN was what was slowing the application down.
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken
Sunday, February 19, 2012
Fails to Render
RS works fine locally.
When accessed from the internet, I can see the report folders; I can select
a report; it processes "Opening...."; then (briefly) "Finding site xxxx";
then nothing. No circular icon that says "Processing Report", just a big
blank page.
I have tried it as Administrator, and from both an XP/IE and Windows 2003
Server box.
RS is running on IIS 6.0, Windows 2003.
I don't know what SP is on RS. How do I find that out?
Any suggestions will be appreciated.On Fri, 22 Apr 2005 10:56:04 -0700, "JohnWoll"
<JohnWoll@.discussions.microsoft.com> wrote:
>RS works fine locally.
>When accessed from the internet, I can see the report folders; I can select
>a report; it processes "Opening...."; then (briefly) "Finding site xxxx";
>then nothing. No circular icon that says "Processing Report", just a big
>blank page.
>I have tried it as Administrator, and from both an XP/IE and Windows 2003
>Server box.
>RS is running on IIS 6.0, Windows 2003.
>I don't know what SP is on RS. How do I find that out?
>Any suggestions will be appreciated.
Version info:
http://www.tfosorcim.org/archives/000351.html
Andrew Watt
MVP - InfoPath|||Thank you, Andrew, for the help in determining the SP. I am running the
latest release (8.00.878.00).
I still have the original problem: The report does not render, nor is there
any error message. The report renders fine when inside the intranet.
Please advise the best way to proceed to resolve this. I have several
clients who would like to use Reporting Services - but first I have to show
that it works!
"JohnWoll" wrote:
> RS works fine locally.
> When accessed from the internet, I can see the report folders; I can select
> a report; it processes "Opening...."; then (briefly) "Finding site xxxx";
> then nothing. No circular icon that says "Processing Report", just a big
> blank page.
> I have tried it as Administrator, and from both an XP/IE and Windows 2003
> Server box.
> RS is running on IIS 6.0, Windows 2003.
> I don't know what SP is on RS. How do I find that out?
> Any suggestions will be appreciated.|||Are you using fully qualified domain names or NetBIOS names? Can you browse
to http://server/reportserver instead of using the Report Manager UI?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
news:13B3183D-F808-4369-AB7F-F10BEDC05368@.microsoft.com...
> Thank you, Andrew, for the help in determining the SP. I am running the
> latest release (8.00.878.00).
> I still have the original problem: The report does not render, nor is
> there
> any error message. The report renders fine when inside the intranet.
> Please advise the best way to proceed to resolve this. I have several
> clients who would like to use Reporting Services - but first I have to
> show
> that it works!
> "JohnWoll" wrote:
>> RS works fine locally.
>> When accessed from the internet, I can see the report folders; I can
>> select
>> a report; it processes "Opening...."; then (briefly) "Finding site
>> xxxx";
>> then nothing. No circular icon that says "Processing Report", just a big
>> blank page.
>> I have tried it as Administrator, and from both an XP/IE and Windows 2003
>> Server box.
>> RS is running on IIS 6.0, Windows 2003.
>> I don't know what SP is on RS. How do I find that out?
>> Any suggestions will be appreciated.|||Thanks for the response, Brian!
I am using fully qualified domain names.
I tried going straight to reportserver, instead of using Report Manager UI.
When I do, the report renders normally: I see the icon and message, and it
renders. I greatly appreciate the suggestion, and shame on me for not
thinking of trying that.
The question remains, why Report Manager does not render. Any suggestions?
"Brian Welcker [MSFT]" wrote:
> Are you using fully qualified domain names or NetBIOS names? Can you browse
> to http://server/reportserver instead of using the Report Manager UI?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> news:13B3183D-F808-4369-AB7F-F10BEDC05368@.microsoft.com...
> > Thank you, Andrew, for the help in determining the SP. I am running the
> > latest release (8.00.878.00).
> >
> > I still have the original problem: The report does not render, nor is
> > there
> > any error message. The report renders fine when inside the intranet.
> >
> > Please advise the best way to proceed to resolve this. I have several
> > clients who would like to use Reporting Services - but first I have to
> > show
> > that it works!
> >
> > "JohnWoll" wrote:
> >
> >> RS works fine locally.
> >> When accessed from the internet, I can see the report folders; I can
> >> select
> >> a report; it processes "Opening...."; then (briefly) "Finding site
> >> xxxx";
> >> then nothing. No circular icon that says "Processing Report", just a big
> >> blank page.
> >>
> >> I have tried it as Administrator, and from both an XP/IE and Windows 2003
> >> Server box.
> >>
> >> RS is running on IIS 6.0, Windows 2003.
> >> I don't know what SP is on RS. How do I find that out?
> >> Any suggestions will be appreciated.
>
>|||Most likely, you need to set the ReportServerExternalUrl property. This is
described in the docs somewhere but I don't have the link handy.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
news:C359A949-2907-4FE5-A9F4-86EAA915A8FA@.microsoft.com...
> Thanks for the response, Brian!
> I am using fully qualified domain names.
> I tried going straight to reportserver, instead of using Report Manager
> UI.
> When I do, the report renders normally: I see the icon and message, and it
> renders. I greatly appreciate the suggestion, and shame on me for not
> thinking of trying that.
> The question remains, why Report Manager does not render. Any suggestions?
> "Brian Welcker [MSFT]" wrote:
>> Are you using fully qualified domain names or NetBIOS names? Can you
>> browse
>> to http://server/reportserver instead of using the Report Manager UI?
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
>> news:13B3183D-F808-4369-AB7F-F10BEDC05368@.microsoft.com...
>> > Thank you, Andrew, for the help in determining the SP. I am running the
>> > latest release (8.00.878.00).
>> >
>> > I still have the original problem: The report does not render, nor is
>> > there
>> > any error message. The report renders fine when inside the intranet.
>> >
>> > Please advise the best way to proceed to resolve this. I have several
>> > clients who would like to use Reporting Services - but first I have to
>> > show
>> > that it works!
>> >
>> > "JohnWoll" wrote:
>> >
>> >> RS works fine locally.
>> >> When accessed from the internet, I can see the report folders; I can
>> >> select
>> >> a report; it processes "Opening...."; then (briefly) "Finding site
>> >> xxxx";
>> >> then nothing. No circular icon that says "Processing Report", just a
>> >> big
>> >> blank page.
>> >>
>> >> I have tried it as Administrator, and from both an XP/IE and Windows
>> >> 2003
>> >> Server box.
>> >>
>> >> RS is running on IIS 6.0, Windows 2003.
>> >> I don't know what SP is on RS. How do I find that out?
>> >> Any suggestions will be appreciated.
>>|||Hi,
In the Report Manager, Site Settings try increasing the Report Execution
Timeout period
Mandar
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:enfGsNvSFHA.2336@.TK2MSFTNGP12.phx.gbl...
> Most likely, you need to set the ReportServerExternalUrl property. This is
> described in the docs somewhere but I don't have the link handy.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> news:C359A949-2907-4FE5-A9F4-86EAA915A8FA@.microsoft.com...
> > Thanks for the response, Brian!
> >
> > I am using fully qualified domain names.
> >
> > I tried going straight to reportserver, instead of using Report Manager
> > UI.
> > When I do, the report renders normally: I see the icon and message, and
it
> > renders. I greatly appreciate the suggestion, and shame on me for not
> > thinking of trying that.
> >
> > The question remains, why Report Manager does not render. Any
suggestions?
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> >> Are you using fully qualified domain names or NetBIOS names? Can you
> >> browse
> >> to http://server/reportserver instead of using the Report Manager UI?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> >> news:13B3183D-F808-4369-AB7F-F10BEDC05368@.microsoft.com...
> >> > Thank you, Andrew, for the help in determining the SP. I am running
the
> >> > latest release (8.00.878.00).
> >> >
> >> > I still have the original problem: The report does not render, nor is
> >> > there
> >> > any error message. The report renders fine when inside the intranet.
> >> >
> >> > Please advise the best way to proceed to resolve this. I have several
> >> > clients who would like to use Reporting Services - but first I have
to
> >> > show
> >> > that it works!
> >> >
> >> > "JohnWoll" wrote:
> >> >
> >> >> RS works fine locally.
> >> >> When accessed from the internet, I can see the report folders; I can
> >> >> select
> >> >> a report; it processes "Opening...."; then (briefly) "Finding site
> >> >> xxxx";
> >> >> then nothing. No circular icon that says "Processing Report", just a
> >> >> big
> >> >> blank page.
> >> >>
> >> >> I have tried it as Administrator, and from both an XP/IE and Windows
> >> >> 2003
> >> >> Server box.
> >> >>
> >> >> RS is running on IIS 6.0, Windows 2003.
> >> >> I don't know what SP is on RS. How do I find that out?
> >> >> Any suggestions will be appreciated.
> >>
> >>
> >>
>|||I tried increasing the Report Execution Timeout period. It did not make any
difference.
"IB Ghost" wrote:
> Hi,
> In the Report Manager, Site Settings try increasing the Report Execution
> Timeout period
> Mandar
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:enfGsNvSFHA.2336@.TK2MSFTNGP12.phx.gbl...
> > Most likely, you need to set the ReportServerExternalUrl property. This is
> > described in the docs somewhere but I don't have the link handy.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> > news:C359A949-2907-4FE5-A9F4-86EAA915A8FA@.microsoft.com...
> > > Thanks for the response, Brian!
> > >
> > > I am using fully qualified domain names.
> > >
> > > I tried going straight to reportserver, instead of using Report Manager
> > > UI.
> > > When I do, the report renders normally: I see the icon and message, and
> it
> > > renders. I greatly appreciate the suggestion, and shame on me for not
> > > thinking of trying that.
> > >
> > > The question remains, why Report Manager does not render. Any
> suggestions?
> > >
> > > "Brian Welcker [MSFT]" wrote:
> > >
> > >> Are you using fully qualified domain names or NetBIOS names? Can you
> > >> browse
> > >> to http://server/reportserver instead of using the Report Manager UI?
> > >>
> > >> --
> > >> Brian Welcker
> > >> Group Program Manager
> > >> Microsoft SQL Server Reporting Services
> > >>
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >>
> > >> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> > >> news:13B3183D-F808-4369-AB7F-F10BEDC05368@.microsoft.com...
> > >> > Thank you, Andrew, for the help in determining the SP. I am running
> the
> > >> > latest release (8.00.878.00).
> > >> >
> > >> > I still have the original problem: The report does not render, nor is
> > >> > there
> > >> > any error message. The report renders fine when inside the intranet.
> > >> >
> > >> > Please advise the best way to proceed to resolve this. I have several
> > >> > clients who would like to use Reporting Services - but first I have
> to
> > >> > show
> > >> > that it works!
> > >> >
> > >> > "JohnWoll" wrote:
> > >> >
> > >> >> RS works fine locally.
> > >> >> When accessed from the internet, I can see the report folders; I can
> > >> >> select
> > >> >> a report; it processes "Opening...."; then (briefly) "Finding site
> > >> >> xxxx";
> > >> >> then nothing. No circular icon that says "Processing Report", just a
> > >> >> big
> > >> >> blank page.
> > >> >>
> > >> >> I have tried it as Administrator, and from both an XP/IE and Windows
> > >> >> 2003
> > >> >> Server box.
> > >> >>
> > >> >> RS is running on IIS 6.0, Windows 2003.
> > >> >> I don't know what SP is on RS. How do I find that out?
> > >> >> Any suggestions will be appreciated.
> > >>
> > >>
> > >>
> >
> >
>
>|||THANK YOU BRIAN! That is exactly what the problem was.
In the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager folder I changed the RSWebApplication.config file by
adding a line tagged with ReportServerExternalUrl:
<ReportServerExternalURL>http://MyDomain.com/ReportServer</ReportServerExternalURL>
"Brian Welcker [MSFT]" wrote:
> Most likely, you need to set the ReportServerExternalUrl property. This is
> described in the docs somewhere but I don't have the link handy.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> news:C359A949-2907-4FE5-A9F4-86EAA915A8FA@.microsoft.com...
> > Thanks for the response, Brian!
> >
> > I am using fully qualified domain names.
> >
> > I tried going straight to reportserver, instead of using Report Manager
> > UI.
> > When I do, the report renders normally: I see the icon and message, and it
> > renders. I greatly appreciate the suggestion, and shame on me for not
> > thinking of trying that.
> >
> > The question remains, why Report Manager does not render. Any suggestions?
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> >> Are you using fully qualified domain names or NetBIOS names? Can you
> >> browse
> >> to http://server/reportserver instead of using the Report Manager UI?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> >> news:13B3183D-F808-4369-AB7F-F10BEDC05368@.microsoft.com...
> >> > Thank you, Andrew, for the help in determining the SP. I am running the
> >> > latest release (8.00.878.00).
> >> >
> >> > I still have the original problem: The report does not render, nor is
> >> > there
> >> > any error message. The report renders fine when inside the intranet.
> >> >
> >> > Please advise the best way to proceed to resolve this. I have several
> >> > clients who would like to use Reporting Services - but first I have to
> >> > show
> >> > that it works!
> >> >
> >> > "JohnWoll" wrote:
> >> >
> >> >> RS works fine locally.
> >> >> When accessed from the internet, I can see the report folders; I can
> >> >> select
> >> >> a report; it processes "Opening...."; then (briefly) "Finding site
> >> >> xxxx";
> >> >> then nothing. No circular icon that says "Processing Report", just a
> >> >> big
> >> >> blank page.
> >> >>
> >> >> I have tried it as Administrator, and from both an XP/IE and Windows
> >> >> 2003
> >> >> Server box.
> >> >>
> >> >> RS is running on IIS 6.0, Windows 2003.
> >> >> I don't know what SP is on RS. How do I find that out?
> >> >> Any suggestions will be appreciated.
> >>
> >>
> >>
>
>
When accessed from the internet, I can see the report folders; I can select
a report; it processes "Opening...."; then (briefly) "Finding site xxxx";
then nothing. No circular icon that says "Processing Report", just a big
blank page.
I have tried it as Administrator, and from both an XP/IE and Windows 2003
Server box.
RS is running on IIS 6.0, Windows 2003.
I don't know what SP is on RS. How do I find that out?
Any suggestions will be appreciated.On Fri, 22 Apr 2005 10:56:04 -0700, "JohnWoll"
<JohnWoll@.discussions.microsoft.com> wrote:
>RS works fine locally.
>When accessed from the internet, I can see the report folders; I can select
>a report; it processes "Opening...."; then (briefly) "Finding site xxxx";
>then nothing. No circular icon that says "Processing Report", just a big
>blank page.
>I have tried it as Administrator, and from both an XP/IE and Windows 2003
>Server box.
>RS is running on IIS 6.0, Windows 2003.
>I don't know what SP is on RS. How do I find that out?
>Any suggestions will be appreciated.
Version info:
http://www.tfosorcim.org/archives/000351.html
Andrew Watt
MVP - InfoPath|||Thank you, Andrew, for the help in determining the SP. I am running the
latest release (8.00.878.00).
I still have the original problem: The report does not render, nor is there
any error message. The report renders fine when inside the intranet.
Please advise the best way to proceed to resolve this. I have several
clients who would like to use Reporting Services - but first I have to show
that it works!
"JohnWoll" wrote:
> RS works fine locally.
> When accessed from the internet, I can see the report folders; I can select
> a report; it processes "Opening...."; then (briefly) "Finding site xxxx";
> then nothing. No circular icon that says "Processing Report", just a big
> blank page.
> I have tried it as Administrator, and from both an XP/IE and Windows 2003
> Server box.
> RS is running on IIS 6.0, Windows 2003.
> I don't know what SP is on RS. How do I find that out?
> Any suggestions will be appreciated.|||Are you using fully qualified domain names or NetBIOS names? Can you browse
to http://server/reportserver instead of using the Report Manager UI?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
news:13B3183D-F808-4369-AB7F-F10BEDC05368@.microsoft.com...
> Thank you, Andrew, for the help in determining the SP. I am running the
> latest release (8.00.878.00).
> I still have the original problem: The report does not render, nor is
> there
> any error message. The report renders fine when inside the intranet.
> Please advise the best way to proceed to resolve this. I have several
> clients who would like to use Reporting Services - but first I have to
> show
> that it works!
> "JohnWoll" wrote:
>> RS works fine locally.
>> When accessed from the internet, I can see the report folders; I can
>> select
>> a report; it processes "Opening...."; then (briefly) "Finding site
>> xxxx";
>> then nothing. No circular icon that says "Processing Report", just a big
>> blank page.
>> I have tried it as Administrator, and from both an XP/IE and Windows 2003
>> Server box.
>> RS is running on IIS 6.0, Windows 2003.
>> I don't know what SP is on RS. How do I find that out?
>> Any suggestions will be appreciated.|||Thanks for the response, Brian!
I am using fully qualified domain names.
I tried going straight to reportserver, instead of using Report Manager UI.
When I do, the report renders normally: I see the icon and message, and it
renders. I greatly appreciate the suggestion, and shame on me for not
thinking of trying that.
The question remains, why Report Manager does not render. Any suggestions?
"Brian Welcker [MSFT]" wrote:
> Are you using fully qualified domain names or NetBIOS names? Can you browse
> to http://server/reportserver instead of using the Report Manager UI?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> news:13B3183D-F808-4369-AB7F-F10BEDC05368@.microsoft.com...
> > Thank you, Andrew, for the help in determining the SP. I am running the
> > latest release (8.00.878.00).
> >
> > I still have the original problem: The report does not render, nor is
> > there
> > any error message. The report renders fine when inside the intranet.
> >
> > Please advise the best way to proceed to resolve this. I have several
> > clients who would like to use Reporting Services - but first I have to
> > show
> > that it works!
> >
> > "JohnWoll" wrote:
> >
> >> RS works fine locally.
> >> When accessed from the internet, I can see the report folders; I can
> >> select
> >> a report; it processes "Opening...."; then (briefly) "Finding site
> >> xxxx";
> >> then nothing. No circular icon that says "Processing Report", just a big
> >> blank page.
> >>
> >> I have tried it as Administrator, and from both an XP/IE and Windows 2003
> >> Server box.
> >>
> >> RS is running on IIS 6.0, Windows 2003.
> >> I don't know what SP is on RS. How do I find that out?
> >> Any suggestions will be appreciated.
>
>|||Most likely, you need to set the ReportServerExternalUrl property. This is
described in the docs somewhere but I don't have the link handy.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
news:C359A949-2907-4FE5-A9F4-86EAA915A8FA@.microsoft.com...
> Thanks for the response, Brian!
> I am using fully qualified domain names.
> I tried going straight to reportserver, instead of using Report Manager
> UI.
> When I do, the report renders normally: I see the icon and message, and it
> renders. I greatly appreciate the suggestion, and shame on me for not
> thinking of trying that.
> The question remains, why Report Manager does not render. Any suggestions?
> "Brian Welcker [MSFT]" wrote:
>> Are you using fully qualified domain names or NetBIOS names? Can you
>> browse
>> to http://server/reportserver instead of using the Report Manager UI?
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
>> news:13B3183D-F808-4369-AB7F-F10BEDC05368@.microsoft.com...
>> > Thank you, Andrew, for the help in determining the SP. I am running the
>> > latest release (8.00.878.00).
>> >
>> > I still have the original problem: The report does not render, nor is
>> > there
>> > any error message. The report renders fine when inside the intranet.
>> >
>> > Please advise the best way to proceed to resolve this. I have several
>> > clients who would like to use Reporting Services - but first I have to
>> > show
>> > that it works!
>> >
>> > "JohnWoll" wrote:
>> >
>> >> RS works fine locally.
>> >> When accessed from the internet, I can see the report folders; I can
>> >> select
>> >> a report; it processes "Opening...."; then (briefly) "Finding site
>> >> xxxx";
>> >> then nothing. No circular icon that says "Processing Report", just a
>> >> big
>> >> blank page.
>> >>
>> >> I have tried it as Administrator, and from both an XP/IE and Windows
>> >> 2003
>> >> Server box.
>> >>
>> >> RS is running on IIS 6.0, Windows 2003.
>> >> I don't know what SP is on RS. How do I find that out?
>> >> Any suggestions will be appreciated.
>>|||Hi,
In the Report Manager, Site Settings try increasing the Report Execution
Timeout period
Mandar
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:enfGsNvSFHA.2336@.TK2MSFTNGP12.phx.gbl...
> Most likely, you need to set the ReportServerExternalUrl property. This is
> described in the docs somewhere but I don't have the link handy.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> news:C359A949-2907-4FE5-A9F4-86EAA915A8FA@.microsoft.com...
> > Thanks for the response, Brian!
> >
> > I am using fully qualified domain names.
> >
> > I tried going straight to reportserver, instead of using Report Manager
> > UI.
> > When I do, the report renders normally: I see the icon and message, and
it
> > renders. I greatly appreciate the suggestion, and shame on me for not
> > thinking of trying that.
> >
> > The question remains, why Report Manager does not render. Any
suggestions?
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> >> Are you using fully qualified domain names or NetBIOS names? Can you
> >> browse
> >> to http://server/reportserver instead of using the Report Manager UI?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> >> news:13B3183D-F808-4369-AB7F-F10BEDC05368@.microsoft.com...
> >> > Thank you, Andrew, for the help in determining the SP. I am running
the
> >> > latest release (8.00.878.00).
> >> >
> >> > I still have the original problem: The report does not render, nor is
> >> > there
> >> > any error message. The report renders fine when inside the intranet.
> >> >
> >> > Please advise the best way to proceed to resolve this. I have several
> >> > clients who would like to use Reporting Services - but first I have
to
> >> > show
> >> > that it works!
> >> >
> >> > "JohnWoll" wrote:
> >> >
> >> >> RS works fine locally.
> >> >> When accessed from the internet, I can see the report folders; I can
> >> >> select
> >> >> a report; it processes "Opening...."; then (briefly) "Finding site
> >> >> xxxx";
> >> >> then nothing. No circular icon that says "Processing Report", just a
> >> >> big
> >> >> blank page.
> >> >>
> >> >> I have tried it as Administrator, and from both an XP/IE and Windows
> >> >> 2003
> >> >> Server box.
> >> >>
> >> >> RS is running on IIS 6.0, Windows 2003.
> >> >> I don't know what SP is on RS. How do I find that out?
> >> >> Any suggestions will be appreciated.
> >>
> >>
> >>
>|||I tried increasing the Report Execution Timeout period. It did not make any
difference.
"IB Ghost" wrote:
> Hi,
> In the Report Manager, Site Settings try increasing the Report Execution
> Timeout period
> Mandar
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:enfGsNvSFHA.2336@.TK2MSFTNGP12.phx.gbl...
> > Most likely, you need to set the ReportServerExternalUrl property. This is
> > described in the docs somewhere but I don't have the link handy.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> > news:C359A949-2907-4FE5-A9F4-86EAA915A8FA@.microsoft.com...
> > > Thanks for the response, Brian!
> > >
> > > I am using fully qualified domain names.
> > >
> > > I tried going straight to reportserver, instead of using Report Manager
> > > UI.
> > > When I do, the report renders normally: I see the icon and message, and
> it
> > > renders. I greatly appreciate the suggestion, and shame on me for not
> > > thinking of trying that.
> > >
> > > The question remains, why Report Manager does not render. Any
> suggestions?
> > >
> > > "Brian Welcker [MSFT]" wrote:
> > >
> > >> Are you using fully qualified domain names or NetBIOS names? Can you
> > >> browse
> > >> to http://server/reportserver instead of using the Report Manager UI?
> > >>
> > >> --
> > >> Brian Welcker
> > >> Group Program Manager
> > >> Microsoft SQL Server Reporting Services
> > >>
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >>
> > >> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> > >> news:13B3183D-F808-4369-AB7F-F10BEDC05368@.microsoft.com...
> > >> > Thank you, Andrew, for the help in determining the SP. I am running
> the
> > >> > latest release (8.00.878.00).
> > >> >
> > >> > I still have the original problem: The report does not render, nor is
> > >> > there
> > >> > any error message. The report renders fine when inside the intranet.
> > >> >
> > >> > Please advise the best way to proceed to resolve this. I have several
> > >> > clients who would like to use Reporting Services - but first I have
> to
> > >> > show
> > >> > that it works!
> > >> >
> > >> > "JohnWoll" wrote:
> > >> >
> > >> >> RS works fine locally.
> > >> >> When accessed from the internet, I can see the report folders; I can
> > >> >> select
> > >> >> a report; it processes "Opening...."; then (briefly) "Finding site
> > >> >> xxxx";
> > >> >> then nothing. No circular icon that says "Processing Report", just a
> > >> >> big
> > >> >> blank page.
> > >> >>
> > >> >> I have tried it as Administrator, and from both an XP/IE and Windows
> > >> >> 2003
> > >> >> Server box.
> > >> >>
> > >> >> RS is running on IIS 6.0, Windows 2003.
> > >> >> I don't know what SP is on RS. How do I find that out?
> > >> >> Any suggestions will be appreciated.
> > >>
> > >>
> > >>
> >
> >
>
>|||THANK YOU BRIAN! That is exactly what the problem was.
In the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager folder I changed the RSWebApplication.config file by
adding a line tagged with ReportServerExternalUrl:
<ReportServerExternalURL>http://MyDomain.com/ReportServer</ReportServerExternalURL>
"Brian Welcker [MSFT]" wrote:
> Most likely, you need to set the ReportServerExternalUrl property. This is
> described in the docs somewhere but I don't have the link handy.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> news:C359A949-2907-4FE5-A9F4-86EAA915A8FA@.microsoft.com...
> > Thanks for the response, Brian!
> >
> > I am using fully qualified domain names.
> >
> > I tried going straight to reportserver, instead of using Report Manager
> > UI.
> > When I do, the report renders normally: I see the icon and message, and it
> > renders. I greatly appreciate the suggestion, and shame on me for not
> > thinking of trying that.
> >
> > The question remains, why Report Manager does not render. Any suggestions?
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> >> Are you using fully qualified domain names or NetBIOS names? Can you
> >> browse
> >> to http://server/reportserver instead of using the Report Manager UI?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> >> news:13B3183D-F808-4369-AB7F-F10BEDC05368@.microsoft.com...
> >> > Thank you, Andrew, for the help in determining the SP. I am running the
> >> > latest release (8.00.878.00).
> >> >
> >> > I still have the original problem: The report does not render, nor is
> >> > there
> >> > any error message. The report renders fine when inside the intranet.
> >> >
> >> > Please advise the best way to proceed to resolve this. I have several
> >> > clients who would like to use Reporting Services - but first I have to
> >> > show
> >> > that it works!
> >> >
> >> > "JohnWoll" wrote:
> >> >
> >> >> RS works fine locally.
> >> >> When accessed from the internet, I can see the report folders; I can
> >> >> select
> >> >> a report; it processes "Opening...."; then (briefly) "Finding site
> >> >> xxxx";
> >> >> then nothing. No circular icon that says "Processing Report", just a
> >> >> big
> >> >> blank page.
> >> >>
> >> >> I have tried it as Administrator, and from both an XP/IE and Windows
> >> >> 2003
> >> >> Server box.
> >> >>
> >> >> RS is running on IIS 6.0, Windows 2003.
> >> >> I don't know what SP is on RS. How do I find that out?
> >> >> Any suggestions will be appreciated.
> >>
> >>
> >>
>
>
Subscribe to:
Posts (Atom)