ParanoidX2's Q&A profile
SQL Server Export Report
Hi, How can i export a reporting services "report" without using a report viewer From C# code NB: i am using SQL server 2005 (RS 2005 too) Thanks Tarek Ghazali SQL Server MVP have you tried doing it through the url it's pretty straight foward you pass what ever values and then say &rs:Format=HTML4.0(or what ever format you want) here's a link further explaining it http://msdn2.microsoft.com/en-us/library/ms154040.aspx ...Show All
Visual Basic unable to cast COM object error
Hello, I am having a strange problem that I can't seem to figure out. I am using visual studio 2005, visual basic, .net 2.0. In my application I am using the Microsoft Internet Controls COM object to automate an Internet Explorer instance. The whole application runs fine in debug and release on my development WindowsXP machine. When I publish the project to Windows Server 2003 to run as a release, I receive the following error. I was reading some posts on registering COM components, etc, but I was not sure why this would run fine on my dev machine and blow up on the release box. Both machines have the same versions of .Net on them. An ...Show All
SQL Server Problem with displaying image on the report
I have a webservice which creates an image returns that image in the form of Byte array. I want to consume this webservice and display that image on my report. When I see my report in the Preview tab of the report designer, it displays that image but when I deploy my report on the report server, image doesn't show up. I have copied app_code.dll (dll for the webservice) to the following locations: C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PublicAssemblies C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin Here is the code ...Show All
SQL Server Remote Access To Report Manager Failed.
Hi All, I'm using Express Edition with Advanced Features. All working fine except I'm not able to access the Report Manager from client pc. When I type http://xxx/Reports$SQLExpress in the machine where the Express Edition with Advanced Features is install, I can get to the home page of the Report Manager (xxx being the machine name). However, if I type the same address in the client pc, I got the "Page cannot be displayed" error. I check remote database access from the client pc and connection is ok (after following the advice provided in msdn). I also pinged the ip address and all seems ok. Would appreciate your kind ass ...Show All
Visual Studio Express Editions Mouse following question
Hi, I know GetCursorPos() is used to get the current x,y coordinates of the mouse cursor. My question is how to write program that always displays the x,y coordinate next to the mouse cursor. Is a Win32 program needed or can I actually write a console program to do it What is the easiest way to do this Thanks a lot! KL You'll have to be able to handle the Control.MouseMove event if you're writing a CLR application (so you'll have to do it in a Windows Forms application) or the WM_MOUSEMOVE message if you're writing a native app (so, you'll have to create window for the message to get posted to). Basic ...Show All
Visual Studio VS Beta2 crashes and restarts when I try and run it in debug mode.
When I try and run my web application in debug mode, the IDE will build my application, but when it comes time to display it using the IDE's development server, the IDE displays a warning message, that I should save everything and VS will shutdown and restart. If I just do a build of my application it builds successfully. Is anyone else having this issue Does anyone know of a fix Thanks Found the solution. It seems to be a problem with the window layout in the IDE. I was able to run the debugger after I went to the Window Menu and selected Reset Window Layout. Hope this helps. ...Show All
Visual C++ Moving GraphicsPath objects with mouse
Hi, I recently started a little project on my own which purpose is the following: - Having "furniture" modules displayed on screen by pressing specific pushbuttons. - Being able to select modules by the mean of a mouse click and then move them. - Being able to insert module between others. For displaying modules, I use Graphicspath objects starting from the fact that each module can be of any kind of shapes starti ...Show All
SQL Server SP3 Upgrade seems to have disconnected our Analysis Manager
HI, we just loaded the Analysis Services SP3 on SQL Server 2000. This upload was tested in a single server environment and worked correctly. However, our production environment is a triple server environment. We are able to connect to our Project Server DB. Our Cube data is also still available. However, no matter what we have tried, we are unable to get the Analysis Manager to connect to the Cube DB area. I'm in our PMO. Our DBA is not terribly comfortable with the admin of the Analysis services pieces, so this has fallen into our lap. Everything I have searched on today indicates failures with the service and such. However, th ...Show All
Visual Studio Express Editions Need help with for and pictureboxes
I'm making a map editor to make maps Every tile is a picurebox. In the menu there is a command "New" wich will load all the default pics into the picturebozes, so you can make a new map i created this for statement dim i as integer For i = 0 To 391 PictureBox(i).image = My.Resources.Image_default Next i But this doesn't work. There is something wrong with the PictureBox(i).image Please help me. I'm using vb2005 Thanks in advance, Radexxion "There is something wrong with the PictureBox(i).image" doesn't really give much idea of the problem you are having. Have you created an Array called ...Show All
Windows Forms datagridview basic understanding
hello, I have an array of strings: Private datasource1() As String datasource1 = New String () { "Pete" , "Joe" , "MaryLou" } this works fine: ComboBox1.DataSource = datasource1 This gives me a list of the length of the strings DataGridView1.DataSource = datasource1 I understand that Lenght is the only property of the String object (If I use an array of Integers I get nothing) The question is how do I get the values of the strings in the DataGridView. This should be simple. I know I can use an unbound control and put the values in there...not the answer I am lookin ...Show All
SQL Server Funny problem (bug?) using MAX() on SQL Mobile
This sure looks like a bug, but I'm still new... First I create a simple database: SqlCeEngine eng = new SqlCeEngine ( @"Data Source=\My Documents\test.sdf" ); eng.CreateDatabase(); eng.Dispose(); Then I put something in it: SqlCeConnection conn = new SqlCeConnection(@"Data Source=\My Documents\test.sdf"); SqlCeCommand cmd = new SqlCeCommand("CREATE TABLE myTable (ID int, name nchar(10))"); cmd.Connection=conn; conn.Open(); cmd.ExecuteNonQuery(); cmd.CommandText="INSERT INTO myTable (ID, name) VALUES (1,'bill')"; cmd.ExecuteNonQuery(); Then I try to get the maximum value from th ...Show All
Visual Studio Team System Sample Templates
I downloaded the MSF Sample Tempates v3 and tried to open the MS Project files. I can't see nothing in there, altough the files are prety big. Can someone tell me how can I see for example the Gant chart Can I also get a copy of these samples that you have been referring to Email is ponce.kenton@per-se.com Thanks in advance. Ponce ...Show All
Visual Studio Express Editions How do I get this registration Key I read about?
Where do I get the registration key for the express release I registered but all that got me was some access to tutorials, but no key for visual basic 2005. Is there still a key requirement Does VB 2005 expire in 30 days or something or did I just misread this at some point Thanks. You can find a FAQ about it here . ...Show All
Smart Device Development win ce 4.1 and seting / getting timezone in c#
I have an app that needs to be on the correct time of day and time zone. I have the code to set the time by a pinvoke call. I found an API call for Get and Set Time Zone but it wants a C/C++ struct that I am not sure how to create in C# the msdn docs call for WCHAR blah[32]; which if I am thinking right means an array of 32 UNICODE chars not a pointer to a string. and C# will not let me declare a struct with a fixed array size like char[32] foo; can someone give me the right struct or class to pass to this platform call thanks! Hi! I can only give you the VB struct: ...Show All
.NET Development RowFilter Performance Problem in VS.NET 2005 !
Hi, I have a Project in VS.NET 2003 which uses DataView.RowFilter. When I compile it in VS.NET 2005. Performance of the RowFilter Command decreases dramatically. I am in the first stages of migrating my project to VS.NET 2005. But this is a big draw back. I would really appreciate it if you could help me in this. No need to mention that Microsoft has indicated that RowFilter performance has increased in this new version. Thanks, Mehdi Thanks man, The Performance degrade which I experienced, was on a table with more than 100K rows, and that's big enough for a table in memory (in my o ...Show All
