named server failed logon after installing MS04-011 patch

Need help urgently.
I have on win 2000 machine a default SQL Server (local) & a named SQL Server
instance (for separate web machine).
After installing the MS04-011 Patch last nite, the named SQL Server fails to
startup on reboot or manual. The default server on the other hand is runnin
g. But I cannot use the default server as it requires access within the loca
l machine only.
I tried uninstalling the patch, but it still cannot get the SQL server runni
ng again.
HOW CAN I RECOVER THE SQL Server Instance?
Additional info: On logon, following error massage:
"NtUninstall Q8877565\WinSys.cer" not found
before and after the uninstall of the patch.What error do you get when you start it? Is there anything in he SQL Server
errorlog when it fails?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Thank Rand for responding.
The Error is simply Login Failed. Service Manager shows the instance is stop
ped, while the Default Instance (Local) is started. Click start, and return
Login Failure again.
Any idea what's wrong and how I may recover the Instance?
Almon|||Error listing end at the last restart after patch install. That is, never re
start again.
Almon

named server failed logon after installing MS04-011 patch

Need help urgently
I have on win 2000 machine a default SQL Server (local) & a named SQL Server instance (for separate web machine)
After installing the MS04-011 Patch last nite, the named SQL Server fails to startup on reboot or manual. The default server on the other hand is running. But I cannot use the default server as it requires access within the local machine only
I tried uninstalling the patch, but it still cannot get the SQL server running again.
HOW CAN I RECOVER THE SQL Server Instance'
Additional info: On logon, following error massage
"NtUninstall Q8877565\WinSys.cer" not foun
before and after the uninstall of the patch.What error do you get when you start it? Is there anything in he SQL Server
errorlog when it fails?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Thank Rand for responding
The Error is simply Login Failed. Service Manager shows the instance is stopped, while the Default Instance (Local) is started. Click start, and return Login Failure again
Any idea what's wrong and how I may recover the Instance
Almo|||Error listing end at the last restart after patch install. That is, never restart again
Almo

named server failed logon after installing MS04-011 patch

Need help urgently.
I have on win 2000 machine a default SQL Server (local) & a named SQL Server instance (for separate web machine).
After installing the MS04-011 Patch last nite, the named SQL Server fails to startup on reboot or manual. The default server on the other hand is running. But I cannot use the default server as it requires access within the local machine only.
I tried uninstalling the patch, but it still cannot get the SQL server running again.
HOW CAN I RECOVER THE SQL Server Instance?
Additional info: On logon, following error massage:
"NtUninstall Q8877565\WinSys.cer" not found
before and after the uninstall of the patch.
What error do you get when you start it? Is there anything in he SQL Server
errorlog when it fails?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Thank Rand for responding.
The Error is simply Login Failed. Service Manager shows the instance is stopped, while the Default Instance (Local) is started. Click start, and return Login Failure again.
Any idea what's wrong and how I may recover the Instance?
Almon
|||Error listing end at the last restart after patch install. That is, never restart again.
Almon
sql

Named Pipes or TCP IP in LAN

I have read that Named pipes work faster/better in a LAN environment ? I
have a question.. so would it make sense if the Web Servers (IIS on Windows
2000) that talk to the database servers on the same LAN communicate via
Named pipes as opposed to TCPIP . Also same with regards to the business
tier thats also on the same LAN that talks to the databases that can
communicate using Named pipes
Please provide your inputs here . Currently we use TCPIP. Using SQL 2000HASSAN AFTER READING THIS YOU BE THE JUDGE
Named Pipes vs. TCP/IP Sockets
In a fast local area network (LAN) environment, Transmission Control
Protocol/Internet Protocol (TCP/IP) Sockets and Named Pipes clients are
comparable in terms of performance. However, the performance difference
between the TCP/IP Sockets and Named Pipes clients becomes apparent with
slower networks, such as across wide area networks (WANs) or dial-up
networks. This is because of the different ways the interprocess
communication (IPC) mechanisms communicate between peers.
For named pipes, network communications are typically more interactive. A
peer does not send data until another peer asks for it using a read command.
A network read typically involves a series of peek named pipes messages
before it begins to read the data. These can be very costly in a slow
network and cause excessive network traffic, which in turn affects other
network clients.
It is also important to clarify if you are talking about local pipes or
network pipes. If the server application is running locally on the computer
running an instance of Microsoft SQL ServerT 2000, the local Named Pipes
protocol is an option. Local named pipes runs in kernel mode and is
extremely fast.
For TCP/IP Sockets, data transmissions are more streamlined and have less
overhead. Data transmissions can also take advantage of TCP/IP Sockets
performance enhancement mechanisms such as windowing, delayed
acknowledgements, and so on, which can be very beneficial in a slow network.
Depending on the type of applications, such performance differences can be
significant.
TCP/IP Sockets also support a backlog queue, which can provide a limited
smoothing effect compared to named pipes that may lead to pipe busy errors
when you are attempting to connect to SQL Server.
In general, sockets are preferred in a slow LAN, WAN, or dial-up network,
whereas named pipes can be a better choice when network speed is not the
issue, as it offers more functionality, ease of use, and configuration
options.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ORNMyEE8DHA.3360@.tk2msftngp13.phx.gbl...
> I have read that Named pipes work faster/better in a LAN environment ? I
> have a question.. so would it make sense if the Web Servers (IIS on
Windows
> 2000) that talk to the database servers on the same LAN communicate via
> Named pipes as opposed to TCPIP . Also same with regards to the business
> tier thats also on the same LAN that talks to the databases that can
> communicate using Named pipes
> Please provide your inputs here . Currently we use TCPIP. Using SQL 2000
>

Named Pipes or TCP IP in LAN

I have read that Named pipes work faster/better in a LAN environment ? I
have a question.. so would it make sense if the Web Servers (IIS on Windows
2000) that talk to the database servers on the same LAN communicate via
Named pipes as opposed to TCPIP . Also same with regards to the business
tier thats also on the same LAN that talks to the databases that can
communicate using Named pipes
Please provide your inputs here . Currently we use TCPIP. Using SQL 2000HASSAN AFTER READING THIS YOU BE THE JUDGE
Named Pipes vs. TCP/IP Sockets
In a fast local area network (LAN) environment, Transmission Control
Protocol/Internet Protocol (TCP/IP) Sockets and Named Pipes clients are
comparable in terms of performance. However, the performance difference
between the TCP/IP Sockets and Named Pipes clients becomes apparent with
slower networks, such as across wide area networks (WANs) or dial-up
networks. This is because of the different ways the interprocess
communication (IPC) mechanisms communicate between peers.
For named pipes, network communications are typically more interactive. A
peer does not send data until another peer asks for it using a read command.
A network read typically involves a series of peek named pipes messages
before it begins to read the data. These can be very costly in a slow
network and cause excessive network traffic, which in turn affects other
network clients.
It is also important to clarify if you are talking about local pipes or
network pipes. If the server application is running locally on the computer
running an instance of Microsoft® SQL ServerT 2000, the local Named Pipes
protocol is an option. Local named pipes runs in kernel mode and is
extremely fast.
For TCP/IP Sockets, data transmissions are more streamlined and have less
overhead. Data transmissions can also take advantage of TCP/IP Sockets
performance enhancement mechanisms such as windowing, delayed
acknowledgements, and so on, which can be very beneficial in a slow network.
Depending on the type of applications, such performance differences can be
significant.
TCP/IP Sockets also support a backlog queue, which can provide a limited
smoothing effect compared to named pipes that may lead to pipe busy errors
when you are attempting to connect to SQL Server.
In general, sockets are preferred in a slow LAN, WAN, or dial-up network,
whereas named pipes can be a better choice when network speed is not the
issue, as it offers more functionality, ease of use, and configuration
options.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ORNMyEE8DHA.3360@.tk2msftngp13.phx.gbl...
> I have read that Named pipes work faster/better in a LAN environment ? I
> have a question.. so would it make sense if the Web Servers (IIS on
Windows
> 2000) that talk to the database servers on the same LAN communicate via
> Named pipes as opposed to TCPIP . Also same with regards to the business
> tier thats also on the same LAN that talks to the databases that can
> communicate using Named pipes
> Please provide your inputs here . Currently we use TCPIP. Using SQL 2000
>|||Another thing to consider with Named Pipes is that the
user's Windows user accounts must have permission to
establish a NetBEUI connection to the Windows box that
SQL Server is running on. This is not the case when
using TCP/IP Sockets.
Just out of curiosity, where did you read that Named
Pipes was faster/better in a LAN environment? The last
time I experienced Named Pipes to be noticeably faster
was with a 16 bit client.
Matthew Bando
matthew.bando@.CSCTGI(Remove this).com
>--Original Message--
>I have read that Named pipes work faster/better in a LAN
environment ? I
>have a question.. so would it make sense if the Web
Servers (IIS on Windows
>2000) that talk to the database servers on the same LAN
communicate via
>Named pipes as opposed to TCPIP . Also same with regards
to the business
>tier thats also on the same LAN that talks to the
databases that can
>communicate using Named pipes
>Please provide your inputs here . Currently we use
TCPIP. Using SQL 2000
>
>.
>

Name storage in database

I'm dealing with a system that only stores a single "Name" field in an OLTP
(web site) database. Now my immediate reaction was to split it into: Prefix,
First, Middle, Last & Suffix. However, the UI could easilly get a little
unfriendly. So I popped into Amazon and found they were using a single field
in the UI too. Other sites I checked only used first and last names.
Someone must have done some research on this and made a paper available.
Thoughts and/or links?On Wed, 5 Dec 2007 12:37:24 -0800, Jay wrote:
>I'm dealing with a system that only stores a single "Name" field in an OLTP
>(web site) database. Now my immediate reaction was to split it into: Prefix,
>First, Middle, Last & Suffix. However, the UI could easilly get a little
>unfriendly. So I popped into Amazon and found they were using a single field
>in the UI too. Other sites I checked only used first and last names.
>Someone must have done some research on this and made a paper available.
>Thoughts and/or links?
>
Hi Jay,
It all depends on what you want to use the data for.
If you just intend to print it on address labels for your business
correspondence, than you can just as well leave it in a single column.
If you intend to do something wiith a component of a name (e.g. sorting
by last name, or personalizing a letter by having it start with "Dear
Mr. Jones" or "Hi Barry", or analysing whether your customers with a
specific title spend more than those without), then you're better off
splitting the parts you eed seperate right from the off.
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Name storage in database

I'm dealing with a system that only stores a single "Name" field in an OLTP
(web site) database. Now my immediate reaction was to split it into: Prefix,
First, Middle, Last & Suffix. However, the UI could easilly get a little
unfriendly. So I popped into Amazon and found they were using a single field
in the UI too. Other sites I checked only used first and last names.
Someone must have done some research on this and made a paper available.
Thoughts and/or links?On Wed, 5 Dec 2007 12:37:24 -0800, Jay wrote:

>I'm dealing with a system that only stores a single "Name" field in an OLTP
>(web site) database. Now my immediate reaction was to split it into: Prefix
,
>First, Middle, Last & Suffix. However, the UI could easilly get a little
>unfriendly. So I popped into Amazon and found they were using a single fiel
d
>in the UI too. Other sites I checked only used first and last names.
>Someone must have done some research on this and made a paper available.
>Thoughts and/or links?
>
Hi Jay,
It all depends on what you want to use the data for.
If you just intend to print it on address labels for your business
correspondence, than you can just as well leave it in a single column.
If you intend to do something wiith a component of a name (e.g. sorting
by last name, or personalizing a letter by having it start with "Dear
Mr. Jones" or "Hi Barry", or analysing whether your customers with a
specific title spend more than those without), then you're better off
splitting the parts you eed seperate right from the off.
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

n tier development strategy question

I don't know where to post this question-or maybe its a comment and I am
just looking for reactions.
We are developing a multi-tiered web app where all database access goes
through a Business Object layer which resides on a machine that is not the
db server.
I am trying to develop the Business Objects in such a way that the web tier
which uses them does not access datasets directly themselves. Instead, the
Business Objects layers provides objects and collection classes representing
the data in the database.
It seems that I am always presented with a trade off of choosing between
encapsulation and performance.
For example, in order to instantiate an object A, the object needs to talk
to the database. So the code for this is encaptulated in A.New. But then, if
object B needs three local instances of object A, each instance will result
in A.New making 3 round trips to the database! To code for performance, I
would have have B return ALL of the data needed to instantiate 3 A's and
pass that to a Friend A.New constructor, but this is at the expenses of
encapsulation and reusuability of objects!
Does this make sense!
HHHHHHHHHHHHHHEEEEEEEEEEEEEEEEEEEEEEEEEE
EEELLLLLLLLLLLLLLLLLLLP
It's driving me nuts not knowing what to do!
Is this a common design problem faced by apps that have a Biz Object layer?The business logic itself may be unique to your applicaiton, but there are
proven and widely accepted design patterns for passing data between the
tiers. For example:
Data Access Application Block
http://msdn.microsoft.com/library/d...aab.
asp
Designing Data Tier Components and Passing Data Through Tiers
http://msdn.microsoft.com/library/d...Gag
.asp
"Chad" <chad.dokmanovich@.unisys.com> wrote in message
news:djj90u$qo0$1@.trsvr.tr.unisys.com...
>I don't know where to post this question-or maybe its a comment and I am
>just looking for reactions.
> We are developing a multi-tiered web app where all database access goes
> through a Business Object layer which resides on a machine that is not the
> db server.
> I am trying to develop the Business Objects in such a way that the web
> tier which uses them does not access datasets directly themselves.
> Instead, the Business Objects layers provides objects and collection
> classes representing the data in the database.
> It seems that I am always presented with a trade off of choosing between
> encapsulation and performance.
> For example, in order to instantiate an object A, the object needs to talk
> to the database. So the code for this is encaptulated in A.New. But then,
> if object B needs three local instances of object A, each instance will
> result in A.New making 3 round trips to the database! To code for
> performance, I would have have B return ALL of the data needed to
> instantiate 3 A's and pass that to a Friend A.New constructor, but this is
> at the expenses of encapsulation and reusuability of objects!
>
> Does this make sense!
>
> HHHHHHHHHHHHHHEEEEEEEEEEEEEEEEEEEEEEEEEE
EEELLLLLLLLLLLLLLLLLLLP
> It's driving me nuts not knowing what to do!
> Is this a common design problem faced by apps that have a Biz Object
> layer?
>
>|||On Mon, 24 Oct 2005 14:27:22 -0400, "Chad"
<chad.dokmanovich@.unisys.com> wrote:
>Is this a common design problem faced by apps that have a Biz Object layer?
Yes.
Google is your friend, it's been endlessly discussed.
My position is that a better appreciation of relational databases as
hold a data model, rather than loose tables, is the first step towards
wisdom.
J.

MySQLAdmin for mssql

Hey,

I am looking for a asp.net web application witch has the same functionality as MySQLAdmin.
Does somebody know where I can get that (for free)?

ThxHi,

Yes, ASP EM to access SQl Server is available in 2 flavours VB.NET/C#

click here http://www.aspenterprisemanager.com/

Find Demo http://www.aspenterprisemanager.com/appcsharp/Connect.aspx

FREE Download http://sourceforge.net/projects/asp-ent-man/

Hope that helps
Murali Kumar|||Are there alternatives for this one?|||hi,

No, if i come across one other such application i ll let u know.

Murali Kumar

MySQL to MsSQL 2005

Hi!

How can i convert this code to work with MsSQL 2005?

/Tomas

PartialClass skaalbInherits System.Web.UI.PageProtected Sub Button1_Click(ByVal senderAs Object,ByVal eAs System.EventArgs)Handles Button1.ClickDim strConnectionStringAs String Dim strQueryAs String Dim MyConnectionAs OdbcConnectionDim myCommandAs OdbcCommandDim pathAs String = Server.MapPath("~/album") &"/"Dim albNameAs String = Trim(Replace(txtAlbum.Text,"'", "''")) Dim folderName As String = Trim(Replace(txtAlbum.Text, "'", "''")) folderName = Replace(folderName," ","_")Try If Not My.Computer.FileSystem.DirectoryExists(path & folderName)Then My.Computer.FileSystem.CreateDirectory(path & folderName) labelStatus.Text ="Folder <b>" & folderName &"</b> created!"Dim BeskrivningAs String = Trim(Replace(txtBeskrivning.Text,"'", "''")) strConnectionString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=xxxxxxxx; DATABASE=xxxxxxx; UID=xxxxxxxx; PASSWORD=xxxxxxxxx; OPTION=3" MyConnection = New OdbcConnection(strConnectionString) MyConnection.Open() strQuery = "INSERT INTO tbl_albumet(alb_Namn, alb_Beskrivning, alb_Mapp) VALUES (?, ?, ?)" myCommand = New OdbcCommand(strQuery, MyConnection) myCommand.Parameters.AddWithValue("?", albName) myCommand.Parameters.AddWithValue("?", Beskrivning) myCommand.Parameters.AddWithValue("?", folderName) myCommand.ExecuteNonQuery() MyConnection.Close() Else labelStatus.Text = "Folder excist, pick another name!" End If Catch ex As Exception labelStatus.Text = "Unable to create folder!"End Try End SubEnd Class

Just useDriver={SQL Native Client}; in the connectionstring

MySQL help in C++

Hey, I'm sorta new at this, but I've been a web developer for many years. I know all there is about the actual MySQL languange, and now I'm expanding into computer programming. I was just wondering if anybody knew of some good tutorials on how to access MySQL databases that are on my server. Also, any extra software that is needed and any other useful information would be appreciated.

Thanks

If you have Visual Studio installed on your computer search on OLEdb. Otherwise search for that term at the MSDN Web site.

MySQL -> MS SQL

Hi there, I'm trying to migrate from MySQL to SQL Server 2000. I found
a white paper on the Microsoft web site that explains how to do this:
http://www.microsoft.com/technet/pro...oy/mysql.mspx.
The MySQL 3.51 ODBC driver was installed. In the ODBC controls if we
hit "Test" the connection checks out okay. I ran the Import and Export
Data tool. When the MySQL db is selected as the data and I try to
connect, a confusing error pops:
"A serious error occurred when connecting to the provider."
The connection seems to work because if we enter the wrong username and
password we get an "Access denied for user" message.
Using the mysqldump utility, we created a *.SQL file of our tables.
Then we tried to use the Query Analyzer tool to import the data. When
the .SQL file is opened, we get another error: "File.sql contains long
line over 64k limit".
Any suggestions as to what we could do to make this work?
If we try to re-import the data back into MySQL using mysql -uuser
-ppassword dbname < file.sql it works fine.
Thanks!
Consider using the BCP utility to bulk import the data, not only is it
faster than Query Analyzer, it can support far more data...
Steve
"Bill Smith" <bsmith@.nospam.com> wrote in message
news:O9xE8mCBFHA.1524@.TK2MSFTNGP09.phx.gbl...
> Hi there, I'm trying to migrate from MySQL to SQL Server 2000. I found
> a white paper on the Microsoft web site that explains how to do this:
> http://www.microsoft.com/technet/pro...oy/mysql.mspx.
> The MySQL 3.51 ODBC driver was installed. In the ODBC controls if we
> hit "Test" the connection checks out okay. I ran the Import and Export
> Data tool. When the MySQL db is selected as the data and I try to
> connect, a confusing error pops:
> "A serious error occurred when connecting to the provider."
> The connection seems to work because if we enter the wrong username and
> password we get an "Access denied for user" message.
> Using the mysqldump utility, we created a *.SQL file of our tables.
> Then we tried to use the Query Analyzer tool to import the data. When
> the .SQL file is opened, we get another error: "File.sql contains long
> line over 64k limit".
> Any suggestions as to what we could do to make this work?
> If we try to re-import the data back into MySQL using mysql -uuser
> -ppassword dbname < file.sql it works fine.
> Thanks!
|||Hi,
in order to import data from mysql you'll need the followind:
- DSN to MYSQL Server using MyODBC-3.51.06 drivers
- Linked Server to the DSN
the following script:
--sp_tables_ex 'linked_server_name'
use [dababase]
dbcc traceon (8765)
if object_id ([table to import]) is not null drop table dbo.[table to
import]
select * into dbo.[table to import] from openquery ([linked_server_name],
'select * from [table to import] )
- after importing all mysql tables you create additional keys, etc...
Tudor
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:%2319us4KBFHA.3140@.TK2MSFTNGP15.phx.gbl...
> Consider using the BCP utility to bulk import the data, not only is it
> faster than Query Analyzer, it can support far more data...
> Steve
> "Bill Smith" <bsmith@.nospam.com> wrote in message
> news:O9xE8mCBFHA.1524@.TK2MSFTNGP09.phx.gbl...
>

My web application is not picking up all the data in the table

I'm facing a strange problems regarding an application my company is hosting.
I'm a system engineer and not a developer, so i'm a little bit lost here.
I have a cluster running W2000 SQL Server, this SQL server has some linked
servers (oracle) with one of our costumers, everyday several SQL jobs update
our SQL tables with info from that oracle servers. But for some reason,
recently the users started complaining some some of the info is not available
on the application, after some investigation, i could confirm that everything
is ok with the data on the costumers servers and that our tables keep being
updated with the info, but the application can't seem to catch any of these
info (vendor information in this case). It seems to me that at some point the
table has some corrupt data or something that is preventing the application
from getting all the data.
Do you guys thing this is something with the SQL table or within the
application?
All the help and suggestions are welcome. (my msn is below)
Best regards
Francisco Batista
Portugal
msn: f_batista69@.hotmail.com
No where near enough information to help you. I suggest you find someone
that knows the application to help you.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"francisco - Portugal" <f_batista69@.hotmail.com> wrote in message
news:955AF918-D80E-4B0C-B626-09733B1BE251@.microsoft.com...
> I'm facing a strange problems regarding an application my company is
> hosting.
> I'm a system engineer and not a developer, so i'm a little bit lost here.
> I have a cluster running W2000 SQL Server, this SQL server has some linked
> servers (oracle) with one of our costumers, everyday several SQL jobs
> update
> our SQL tables with info from that oracle servers. But for some reason,
> recently the users started complaining some some of the info is not
> available
> on the application, after some investigation, i could confirm that
> everything
> is ok with the data on the costumers servers and that our tables keep
> being
> updated with the info, but the application can't seem to catch any of
> these
> info (vendor information in this case). It seems to me that at some point
> the
> table has some corrupt data or something that is preventing the
> application
> from getting all the data.
> Do you guys thing this is something with the SQL table or within the
> application?
> All the help and suggestions are welcome. (my msn is below)
> Best regards
> --
> Francisco Batista
> Portugal
> msn: f_batista69@.hotmail.com
|||Thanks anyway for your time, i will try to reach a developer that was
involved in the built of the application.
Merry Christmas
Francisco Batista
Portugal
f_batista69@.hotmail.com
"Arnie Rowland" wrote:

> No where near enough information to help you. I suggest you find someone
> that knows the application to help you.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "francisco - Portugal" <f_batista69@.hotmail.com> wrote in message
> news:955AF918-D80E-4B0C-B626-09733B1BE251@.microsoft.com...
>
>
|||Its best to work with your developer and troubleshoot the lines of code that
calls for the data and then run the same query in your Query Analyser
window.
Alternatively you could run profiler to help troubleshoot the same. If you
think the table has all the data and the app does not return it, then it
could be capped by number of rows or possibly some rowcount option being
set,etc.
"francisco - Portugal" <f_batista69@.hotmail.com> wrote in message
news:EE601359-B05A-4995-9253-92290C82A3A7@.microsoft.com...[vbcol=seagreen]
> Thanks anyway for your time, i will try to reach a developer that was
> involved in the built of the application.
> Merry Christmas
> --
> Francisco Batista
> Portugal
> f_batista69@.hotmail.com
>
> "Arnie Rowland" wrote:

My Very Own SOAP / Web Service Report Viewer

Well, I've finally done it! The first fully functional prototype of the
report viewer control for Reporting Services 2000 is complete. I am
working on a project that cannot wait until RS 2005, so we bit the
bullet and wrote our own component (URL access will not work for a
number of reasons).
Alon with report selection, I have implemented:
1) Parameter selection (including linked params)
2) Page navigation
3) Zooming
4) Refresh
5) Export to: PDF, Excel, CSV, TIFF, XML, MHTML
6) Printing
I have received a lot of help from the RS community, so may thanks to
those of you who frequent this group!
Kulgan.Congratulations!
I have been struggling to build one too. Would you mind sharing your
code/ideas on how to go on about it?
TIA.
Marlon
"Kulgan" <nickamckenna@.gmail.com> wrote in message
news:1121180309.308222.314710@.g43g2000cwa.googlegroups.com...
> Well, I've finally done it! The first fully functional prototype of the
> report viewer control for Reporting Services 2000 is complete. I am
> working on a project that cannot wait until RS 2005, so we bit the
> bullet and wrote our own component (URL access will not work for a
> number of reasons).
> Alon with report selection, I have implemented:
> 1) Parameter selection (including linked params)
> 2) Page navigation
> 3) Zooming
> 4) Refresh
> 5) Export to: PDF, Excel, CSV, TIFF, XML, MHTML
> 6) Printing
> I have received a lot of help from the RS community, so may thanks to
> those of you who frequent this group!
> Kulgan.
>|||Unfortunately the code belongs to the client I have done the work for,
but I will be doing an open source version shortly (when I return from
holiday in a couple of weeks).
I will keep you posted!
In the meantime, if you get stuck, email me and I'll help wherever I
can.
Cheers,
Kulgan.|||Yes, thats great! I have the exact same issue that I need to resolve, i.e.
using the viewer through SOAP. I would love to see how you did this!
"TechnoSpyke" wrote:
> Congratulations!
> I have been struggling to build one too. Would you mind sharing your
> code/ideas on how to go on about it?
> TIA.
> Marlon
> "Kulgan" <nickamckenna@.gmail.com> wrote in message
> news:1121180309.308222.314710@.g43g2000cwa.googlegroups.com...
> > Well, I've finally done it! The first fully functional prototype of the
> > report viewer control for Reporting Services 2000 is complete. I am
> > working on a project that cannot wait until RS 2005, so we bit the
> > bullet and wrote our own component (URL access will not work for a
> > number of reasons).
> >
> > Alon with report selection, I have implemented:
> >
> > 1) Parameter selection (including linked params)
> > 2) Page navigation
> > 3) Zooming
> > 4) Refresh
> > 5) Export to: PDF, Excel, CSV, TIFF, XML, MHTML
> > 6) Printing
> >
> > I have received a lot of help from the RS community, so may thanks to
> > those of you who frequent this group!
> >
> > Kulgan.
> >
>
>|||Me too.
tnx.
Tom.