Embedding reports in Winform App...

I am looking for options for rendering RDLs in a .Net 1.1 Windows Forms
application using SQL Server 2K.
Thanks everyone.Use fyiReporting component (http://www.fyireporting.com). Is open source and
read RDL files with Windows Forms Viewer component.
[]s
"Terry Mulvany" <terry.mulvany@.rouseservices.com> escreveu na mensagem
news:eh4oCnMqFHA.2072@.TK2MSFTNGP14.phx.gbl...
>I am looking for options for rendering RDLs in a .Net 1.1 Windows Forms
>application using SQL Server 2K.
> Thanks everyone.
>|||Thanks Pedro, do you or anyone else know of any similar 3rd party (pay or
open source) components that actually use the infrastructure of SQL Server
Reporting Services (i.e. ReportServer web service and it's corresponding
security) rather than just simply being able to load an RDL file and view it
as the FYIReporting stuff does.
(I know .Net 2.0 and Yukon will support this but we do not have that as an
option)
Thanks all.
-Terry
"Pedro Jr." <pedro.alvesjr@.gmail.com> wrote in message
news:epT5CvMqFHA.2776@.TK2MSFTNGP10.phx.gbl...
> Use fyiReporting component (http://www.fyireporting.com). Is open source
> and read RDL files with Windows Forms Viewer component.
> []s
>
> "Terry Mulvany" <terry.mulvany@.rouseservices.com> escreveu na mensagem
> news:eh4oCnMqFHA.2072@.TK2MSFTNGP14.phx.gbl...
>>I am looking for options for rendering RDLs in a .Net 1.1 Windows Forms
>>application using SQL Server 2K.
>> Thanks everyone.
>|||You can use web services to return a stream rendered how you want and then
display that (pdf, excel, html, etc). Or you can use URL integration. Put a
IE browser control and set its URL appropriately. With .Net 2.0 where will
be a winform control which will make all of this extremely easy.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Terry Mulvany" <terry.mulvany@.rouseservices.com> wrote in message
news:eh4oCnMqFHA.2072@.TK2MSFTNGP14.phx.gbl...
>I am looking for options for rendering RDLs in a .Net 1.1 Windows Forms
>application using SQL Server 2K.
> Thanks everyone.
>

embedding ASPNETDB into my own db

Hi there,

i wanted to embed ASPNETDB into my own db, so i scripted the ASPNETDB and executed it into my db. the problem is that App Manager of my website can not connect to it,(>i've corrected the connectionstring LocalSqlServer), the problem is that, it says its schema is not as expected, i understand this problem but, is there any way to solve it?

thanks in advance

Hi,

Since you're scripting the ASPNETDB to move it to your own db, I suggest you check if there is anything missing. Because you might not scripting everything.

However, I suggest you seperate the ASPNETDB from your own db, since you might need to perform some configuration on the ASPNETDB using .NET tools, which might affect the whole database.

|||

Hi,

well, as an inverse approach, i embedded (scripted) my own db into ASPNETDB, and it now works. it seems, as you said, i hadn't copied everything, although i had checked the 'copy all objects' choice.

thanks

embed SQL Express in app

I'm new to SQL Sever Express and wondering about using it for a desktop app.
I have a web server and SQL2005 with some web apps, and I'm thinking about
making desktop versions of some.
But, I want to protect the db structure and the way everything hangs
together. Assuming I can make a SQL Express version of the 2005 db, can I
combine that with something like a Flash front end and distribute it to
desktops without risking nosy people looking into what make them tick?
What would be great would be encryption of the db, and some lock to prevent
people from opening it in Enterprise mgr/SQL mgr.
CS
hi,
catsailor wrote:
> I'm new to SQL Sever Express and wondering about using it for a
> desktop app. I have a web server and SQL2005 with some web apps, and
> I'm thinking about making desktop versions of some.
> But, I want to protect the db structure and the way everything hangs
> together. Assuming I can make a SQL Express version of the 2005 db,
> can I combine that with something like a Flash front end and
> distribute it to desktops without risking nosy people looking into
> what make them tick?
> What would be great would be encryption of the db, and some lock to
> prevent people from opening it in Enterprise mgr/SQL mgr.
> CS
http://msdn.microsoft.com/library/de...xpuserinst.asp
http://msdn.microsoft.com/library/de...LExCustApp.asp
as regards encrition, you can use the native features provided by SQL Server
2005 it self, as indicated in
http://msdn.microsoft.com/msdnmag/is...s/default.aspx
http://msdn2.microsoft.com/en-us/library/ms189586.aspx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks very much for the articles. I have read through them quickly and see
that I may be able to embed an SQL Express db in my app, and I can encrypt
the data.
But, if a user had Admin privileges and SQL Server Management Studio,
couldn't she still open the SQL Express db and see the structure? Is there
any way to prevent anyone but me from opening the db at all, even if they
are sa?
CS
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:47q45jFgufr7U1@.individual.net...
> hi,
> catsailor wrote:
> http://msdn.microsoft.com/library/de...xpuserinst.asp
> http://msdn.microsoft.com/library/de...LExCustApp.asp
> as regards encrition, you can use the native features provided by SQL
> Server 2005 it self, as indicated in
> http://msdn.microsoft.com/msdnmag/is...s/default.aspx
> http://msdn2.microsoft.com/en-us/library/ms189586.aspx
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi,
catsailor wrote:
> Thanks very much for the articles. I have read through them quickly
> and see that I may be able to embed an SQL Express db in my app, and
> I can encrypt the data.
> But, if a user had Admin privileges and SQL Server Management Studio,
> couldn't she still open the SQL Express db and see the structure? Is
> there any way to prevent anyone but me from opening the db at all,
> even if they are sa?
the encription protection available in SQL Server 2005 is for data only...
at the schema level you can prevent, via GRANT/DENY statement permissions on
"VIEW DEFINITION" at the objects level as at the schema level it self,
http://msdn2.microsoft.com/en-us/library/ms176128(SQL.90).aspx , but a
sysadmin member can not be cut off...
you say:
>Is
> there any way to prevent anyone but me from opening the db at all,
> even if they are sa?
but ... "who are you?"... when you distribute a database to end users they
will not care about "you"... their system will care about their
acconts/logins... or better.. their principals
(http://msdn2.microsoft.com/en-us/library/ms181127(SQL.90).aspx)... and you
will not be enlisted there at all..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I think if you carry this through to it's logical conclusion you won't want
to totally block access. If you did, that would mean you would be
responsible for all backup and restore, maintenance, patching, upgrading,
etc. If the customer had a SQL Server problem, you would have to fix it
because CSS wouldn't be able to access their database to fix it. Are you
really willing to sign up for that?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"catsailor" <hullflyer at gmail.com> wrote in message
news:e27f3$441833a9$48f535c4$29530@.msgid.meganewss ervers.com...
> Thanks very much for the articles. I have read through them quickly and
> see that I may be able to embed an SQL Express db in my app, and I can
> encrypt the data.
> But, if a user had Admin privileges and SQL Server Management Studio,
> couldn't she still open the SQL Express db and see the structure? Is
> there any way to prevent anyone but me from opening the db at all, even if
> they are sa?
> CS
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:47q45jFgufr7U1@.individual.net...
>
|||yeppers, that would be part of the deal.
CS
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:OfVy9NGSGHA.4944@.TK2MSFTNGP10.phx.gbl...
>I think if you carry this through to it's logical conclusion you won't want
>to totally block access. If you did, that would mean you would be
>responsible for all backup and restore, maintenance, patching, upgrading,
>etc. If the customer had a SQL Server problem, you would have to fix it
>because CSS wouldn't be able to access their database to fix it. Are you
>really willing to sign up for that?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "catsailor" <hullflyer at gmail.com> wrote in message
> news:e27f3$441833a9$48f535c4$29530@.msgid.meganewss ervers.com...
>

EM error connection forcibly closed by the remote host (ouch)

I am getting this error in Enterprise Manager:
TCP Provider: An existing connection was forcibly closed by the remote host.
But, my web app can still connect just fine to the db, so it's still inthe same place with the same login/password. And my registrationin EM was working just fine (for years) until yesterday I got thiserror. I've tried deleting the registration and re-creating itbut the same thing. What could have gone wrong to cause this tohappen?
Thanks for any pointers, I have no idea where to start looking on this one, the host says they haven't changed anything...
Well, in case this bites anybody else on the butt, here's what it was:My login didn't have permission for my DEFAULT database on theserver. Apparently EM checks my default db before checking the dbI'm actually trying to connect to! So making my db also mydefault db fixed it.

Either SQL or VB is automatically applying time offsets on my data

I have a windows app which is used in australia and uses web services to communicate with the database located in new zealand. I have a problem where dates that are returned from SQL are automatically modified to suit the timezone and i dont know how to turn it off.

For example, i insert the value '10/Jan/2006 20:00' into the database from a PC located in australia. When that data is selected back out, a 4 hour time offset is automatically applied to it and the time is returned as '10/Jan/2006 16:00'.

My current workaround is to modify my queries to say;

"Select convert(varchar, tb_date) tb_date from tablename"

Which returns the date as a string rather than a datetime which means the time offset is not applied.

This is a really poor solution and i'd be really keen to find out a better way...
Thanks

This is not problem with VB or SQL. This is because of the way DateTimes are serialized in XML when sent over Web Services. For information read this excellent article on working with DateTimes in TimeZone involved applications.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/datetimecode.asp

Efficiently Inserting 1 Million records

I have an app that needs to insert 1 million records into a table. The tabl
e
is very basic thus far, with no triggers or indexes on it. The procedure
takes in excess of an hour, which I am willing to accept if I have to, but I
would like to know what tools are available to streamline this process.
I am using VB.Net code to do the work with basically 1 million loops and an
insert for each one. Are there great gains in terms having Stored Procs do
the work vs Native insert statements or any fancy database tuning techniques
.
I know that indexes add Select efficiency but what can be suggested for the
insert?
Thanks in advance for any assitance.
--
RyanRyan,
1. BULK INSERT
2. BCP (IN)
3. DTS
--See SQL Books Online for more information on each
HTH
Jerry
"Ryan" <weeims@.nospam.nospam> wrote in message
news:CE654CF4-AF12-453E-A552-D80336685BEB@.microsoft.com...
>I have an app that needs to insert 1 million records into a table. The
>table
> is very basic thus far, with no triggers or indexes on it. The procedure
> takes in excess of an hour, which I am willing to accept if I have to, but
> I
> would like to know what tools are available to streamline this process.
> I am using VB.Net code to do the work with basically 1 million loops and
> an
> insert for each one. Are there great gains in terms having Stored Procs
> do
> the work vs Native insert statements or any fancy database tuning
> techniques.
> I know that indexes add Select efficiency but what can be suggested for
> the
> insert?
> Thanks in advance for any assitance.
> --
> Ryan|||Use a bulk insert, BCP
http://sqlservercode.blogspot.com/
"Ryan" wrote:

> I have an app that needs to insert 1 million records into a table. The ta
ble
> is very basic thus far, with no triggers or indexes on it. The procedure
> takes in excess of an hour, which I am willing to accept if I have to, but
I
> would like to know what tools are available to streamline this process.
> I am using VB.Net code to do the work with basically 1 million loops and a
n
> insert for each one. Are there great gains in terms having Stored Procs d
o
> the work vs Native insert statements or any fancy database tuning techniqu
es.
> I know that indexes add Select efficiency but what can be suggested for th
e
> insert?
> Thanks in advance for any assitance.
> --
> Ryan|||Inserting the rows one at time from a client application would be the
absolute slowest method of getting the work done.
You can create a DTS package to import the data. This might be the best
option if data transformations are involved and/or the process needs to be
scheduled as a job. Also, there is the bulk copy T-SQL command or DOS
executable command.
Importing and Exporting Data with DTS and BCP
http://www.microsoft.com/technet/pr...s/c07ppcsq.mspx
Using the DTS Import/Export Wizard
http://www.microsoft.com/mspress/bo...p/4885c.asp#126
Using the Bulk Copy Program (Bcp) and the BULK INSERT Transact-SQL Statement
http://www.microsoft.com/mspress/bo...p/4885e.asp#150
SQL Server 2000 Incremental Bulk Load Case Study
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
"Ryan" <weeims@.nospam.nospam> wrote in message
news:CE654CF4-AF12-453E-A552-D80336685BEB@.microsoft.com...
>I have an app that needs to insert 1 million records into a table. The
>table
> is very basic thus far, with no triggers or indexes on it. The procedure
> takes in excess of an hour, which I am willing to accept if I have to, but
> I
> would like to know what tools are available to streamline this process.
> I am using VB.Net code to do the work with basically 1 million loops and
> an
> insert for each one. Are there great gains in terms having Stored Procs
> do
> the work vs Native insert statements or any fancy database tuning
> techniques.
> I know that indexes add Select efficiency but what can be suggested for
> the
> insert?
> Thanks in advance for any assitance.
> --
> Ryan

Edition Question for Analysis Services

Hi All

I come with Oracle background and we are planning to use SQL Server 2000 Analysis Services for OLAP.

Brief background on our app: The largest of our fact tables has about 500,000 rows per month. We plan to store three years worth of data. We will have other smaller cubes that we will have to build in addition to this. The source data will come from Oracle tables.

I am struggling to decide between the two SQL Server editions (Standard and Enterprise). I'm highlighting the things that I need some help with in order to make the decision:

Memory Limitation
------
Standard Edition only supports up to 2GB. Considering relatively large cube size (is it?), is this a limitation in our case?

Calcualted Cells (only in Enterprise Edition)
------
I didn't fully understand this one in the documentation, not having spent a lot of time. We do have a number of calculations such as the Revenue/Expense, Margin calculations, etc. Is this an important feature that I should consider?

Partitions:
----
I doubt that we will be partitioning across multiple servers (may not need distributed partioning, linked cubes). However, within a single database/instance, do I have the option to partition the cube (does it help to do so for cube manageability) if I went with Standard Edition? Also, given the large fact tables, I may want to incrementally add monthly data to the cube. Would it help to partition the cube in this case and, do I need Enterprise Edition for this?

HTTP Internet Support: (Enterprise Edition only)
-------
I would think that the HTTP access is applicable to intranet applications (ours is one). Does this support in Enterprise Edition automatically means that the data is available for analysis over the web? What tool would I use to access the data (other than the third party tools such as Crystal Analysis, Brio, etc)? I am trying to see what this means and how this relates to my decision on Std Vs Enterprise Editions.

I really appreciate any input you may have on this.

Thanks in advance
Murthy JarugumilliI would suggest to adopt Enterprise Edition as you already know the limitaitons of Standard edition.

In general Standard edition is used as a database server for a small workgroup or department.