Can I redistribute SQL Express?
http://blogs.msdn.com/sqlexpress/archive/2004/07/04/172952.aspx
Okay. Simple request. I have a local report in my VS2005 project. I want to embed my company logo in the header. How do I do this? When I put an image item on the page it wants me to put something in the value for this? I've tried sending through a dataset but SSRS can't load data set information into the header! Why is this so complicated? I don't want to embed a dynamic database image, just a static image that will be embedded in my program. Any help on this would be appreciated.
Thanks,
Jon
Drag and drop an image control to the page header. Select embedded image. Click New image. Select the image that you want to embed. Then click finish. Build and deploy the report. Voila!
|||This works fine for .rdl files. For me, the image wizard does not come up for .rdlc files. Does anyone know why this is?
|||I've noticed this too. That's what prompted my original question. So basically, here is what I've figured out.
1. Click on Reports > Embedded Images.
2. Add your new image, remember what you named it.
3. Add an image to your report.
4. Click on the image.
5. Change the Source property to 'Embedded'
6. Change the value property to the name of your embedded image.
That's it! I'm still not sure why the wizard doesn't work.
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
I am trying to figure out the way to embed a plug-in (Chime for Windows)
into my report, so that I can display a certain object from a database, that
is stored there as a string. This Chime plug-in would read the input string
and convert it to video display.
This embedding is easily done in simple HTML:
<embed type='chemical/x-mdl-molfile' display2d=true width=200 height=200
hlabels2d='terminalhetero' structure= [encrypted string from the database
follows]>
I am wondering is there a way to do such embedding straight into my report
by using the report designer features or by modifying an RDL file for my
report?
If I am able to place my <embed...> string somewhere in my report and when the report is rendered as HTML this string is interpreted as an HTML tag, this would be awesome! So far I experimented with displaying <embed...> string in one of my textboxes, but HTML renderer for report obviously interprets my string as a text not as a tag, so instead of seeing plug-in in action I just see the text of my string.
Probably another approach would be to embed an HTML in a report.
That would also be an exiting idea.
I would appreciate any help on this.
Thanks in advance!
Anton.Reporting Services does not support embedded HTML or object tags. The only way you could do this is to post-process the resulting output.|||
Hello,
Can you detail the approach to be taken, please?
Thanks
I am trying to figure out the way to embed a plug-in (Chime for Windows)
into my report, so that I can display a certain object from a database, that
is stored there as a string. This Chime plug-in would read the input string
and convert it to video display.
This embedding is easily done in simple HTML:
<embed type='chemical/x-mdl-molfile' display2d=true width=200 height=200
hlabels2d='terminalhetero' structure= [encrypted string from the database
follows]>
I am wondering is there a way to do such embedding straight into my report
by using the report designer features or by modifying an RDL file for my
report?
If I am able to place my <embed...> string somewhere in my report and when the report is rendered as HTML this string is interpreted as an HTML tag, this would be awesome! So far I experimented with displaying <embed...> string in one of my textboxes, but HTML renderer for report obviously interprets my string as a text not as a tag, so instead of seeing plug-in in action I just see the text of my string.
Probably another approach would be to embed an HTML in a report.
That would also be an exiting idea.
I would appreciate any help on this.
Thanks in advance!
Anton.Reporting Services does not support embedded HTML or object tags. The only way you could do this is to post-process the resulting output.|||
Hello,
Can you detail the approach to be taken, please?
Thanks
Hi,
I am getting an error when doing the above.
I create a new SSIS package, drag in an Execute DTS 2000 Package Task, select and embed a DTS package which consists only one one task (as above), and then change the source & destination details (svr + user/pwd). Then when I go to the Copy tab, I get the following error when I hit Select Objects, to view the objects which the embedded DTS package should copy:
SQL-DMO error 21776: general error.
On further inspection, none of the objects selected for copy within the atomic/original DTS package, remain selected for copy within the embedded DTS package.
I have googled to search for an answer to this one, but to no avail. Any ideas would be greatly welcomed.
Thanks,
Tamim.
Off the top of my head I am not sure...but I wonder if there is more to this or perhaps what the real goal is?
I ask because if your only dealing with one transfer task from a dts package, then why not just create a new SSIS package using the new ssis transfer tasks? Prehaps you have 100s of said DTS packages, and you need to keep them going rather than rebuild all. However, we should always keep in mind that while the Execute DTS 2000 Package Task is nice for 'keeping things running' from the old version, over time you will want to rebuild any DTS pacakge as a 'native' SSIS 2005 pacakge allows you to do a lot more AND DTS is considered a deprecated technology, which does mean its fading form the picure. If you want you can read more about that here.
http://msdn2.microsoft.com/en-us/library/ms403408.aspx
Hope that helps.
|||
'...if your only dealing with one transfer task from a dts package, then why not just create a new SSIS package using the new ssis transfer tasks?...'
Sure. And that's exactly what I did, thus reducing the problem to being merely academic - but it's still there....
Thanks Craig,
Hey everyone,
Is there any way to embed a video in a report? It doesn't seem like it but I thought I may be missing something. Maybe directly editing the xml code? Thanks.
-Keith
You may want to look at Sharepoint & possibly PerformancePoint rather than just Reporting Services. You could display the report and display a video in a separate webpart.
I am curious what the video requirement is for.
I don't believe there is a way to embed video - only to link to a page containing the video, or display outside of the report.
There is a way to create a custom control and bring it into Reporting Services, however I think this just renders html & images.
cheers,
Andrew
Good Afternoon.
I am trying to write a short application within which I would like to embed a SQL Server Express database, all of which would be deployed via ClickOnce through a web site. The installation process seems to be working without trouble, including installation of the .NET Framework 2.0 and SQL Server Express 2005.
When the application launches on the new machine, however, I get a big Microsoft .NET Framework "Unhandled exception" error dialog box that indicates the database already exists and that the database file could not be attached. I am working with a clean virtual machine that I know has never had the database installed on it.
I fear I am overlooking something quite straightforward, but since this is the first time I have ever attempted to build a data-bound application, I am not sure where I am going wrong.
Perhaps the source of the problem, or a related problem, might be revealed even when I run the application in debug mode from within Visual Studio. I can run the application once, but if I try to run it again, I get an error when I try to open the database connection that is similar in content (database already exists...could not attach). I can run the SSEUtil and detach the database and then run the application again in debug mode and it works no problem (the first time!).
Lastly, if I install the application on the machine on which it was developed and make sure the database is detached, it will run without any trouble (even repeatedly). But, on a new blank machine, there is no database listed that matches my database name, so I cannot try to detach anything!?
My apologies for such a novice question!
Sean
Hi Sean,
I would suggest removing the ‘Initial Catalog’ keyword from your connection string. Among the things that are stored about a database when it is attached is the Name/Path pairing; SQL Server gets a little upset if you try to attach a database using an existing name but with a different path. Enter the |DataDirectory| macro…
I’m guessing you’re using ClickOnce deployment for this application. There are things that will cause the install directory of a ClickOnce deployment to move, when this happens, VS magically fixes up things as far as the application goes, but it cannot fix up the fact that SQL Server has recorded your explicit database as being linked to the old file location. When you attempt to open the application now, the attach fails because there is already a database named JMU_2007 listed in the master database, but it is associated with a different path, so you get the error that the database already exists. I’m guessing this is the problem you’re hitting.
By removing the ‘Initial Catalog’ keyword, you’re forcing SQL Express to give the database an autoname based on its path. If the database moves as a result of VS behavior, the name will be changed because the path has changed, so it will appear to be a different database from the SQL perspective. Hopefully this helps.
Mike
|||Thanks very much Mike. That did the trick...I can't believe I overlooked that after spending too much time trying to fix this problem.
Sean
Select table.* from (table left join query1 on field1=field2)
Now I want to make a change in query1 to change the behaviour of query2. But
this cannot be done in a live environment because I have to shut down the
application, make the change in the database and start the application
again. What I can do is make a query 3 in my application (instead of in the
database) that is initially does the same as query2 like this:
Select table.* from (table left join -->some SQL code to embed query1<-- on
field1=field2)
Once I know how to do this, I can change the "embedded" sql code to my
needs.
Question is: how do I "embed" SQL code in another statement?"John Kenickney" <spam.trap@.bigfoot.com> wrote in message news:<b0909e7389d49cec0cf4ddf5330bce77@.news.teranews.com >...
> Suppose I have an MS access database with query1 and query2. Query2 uses
> query1 something like this:
> Select table.* from (table left join query1 on field1=field2)
> Now I want to make a change in query1 to change the behaviour of query2. But
> this cannot be done in a live environment because I have to shut down the
> application, make the change in the database and start the application
> again. What I can do is make a query 3 in my application (instead of in the
> database) that is initially does the same as query2 like this:
> Select table.* from (table left join -->some SQL code to embed query1<-- on
> field1=field2)
> Once I know how to do this, I can change the "embedded" sql code to my
> needs.
> Question is: how do I "embed" SQL code in another statement?
You should probably post this in an Access forum to get a better response.
Simon
I'm trying to embed SQL Management Studio in an installation package and although the SQL website says that it CAN be embedded there are no instructions on HOW to embed it. I can only find instructions on embedding SQL Express edition. If anyone can help with this I'd appreciate it!
Karen
You can NOT distribute SQL Server Management Studio with SQL Server Express. That would be a license violation. And I believe that because of the EULA, Management Studio Express requires the end user to install the tool.
sqlI changed to a fixed-pitch font to ensure that the text records align properly in VS (which they do), but when I render to HTML, the spaces collapse (of course). PDFs render correctly, but we were trying for HTML output.
Is there any way to replace the native spaces with so it will render correctly in HTML? From the other posts, it seems not, but I want to double check.
If anyone knows of a way to do this, I would appreciate any insight.
Thx.See http://blogs.msdn.com/bimusings/archive/2005/12/14/503648.aspx.sql
