Billl's Q&A profile

• SQL Server Security Settings

  I want some users to see some reports on RS, but not see other reports. Is this possible From what I can see, if you are a Browser role you can see ALL reports. Tell me this isn't so... Pete On any RS catalog item you can define the security for that item. If you give a user the Browser role on a report they will be able to see that report. You can map users to roles on a per item basis. There is not concept of a user being a Browser for all items in RS, only for each item as that item is configured. It is perfectly fine for a user to have Browser role on one folder but not on another, enabling them to see all the reports in that folder but not the later. Please see the following article for more c ...Show All

• Visual Studio Express Editions VB2005 Express - How to Change the connection properties at run time

  Hi, I'm trying to create an application in VB2005 Express. I'm connecting to a MS Access DB. if I want to change the DataSource at run time, lets say, to let the user chose a specific file, I need to change this property, or else the application will search for the specified file in the connection string. The code on debug is: My.Settings.BaseDadosConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="H:\ISEL\PFC\Bases de Dados Access\BaseDados.mdb"" When I try to change the DataSource propertie I get the following error: Error 5 Property 'BaseDadosConnectionString' is 'ReadOnly'. H:\ISEL\PFC\V 2005\frmDistribEnergia.vb 25 5 PFC How can I solve this problem Help, ...Show All

• Visual Basic How to generate Reports for printing files

  Hai Actually i wanted to know that for generating a report on the vb project , what is the tool which we require to print or generate a report vrabhilash, According to your question, I give you the following suggestion: 1. If you are using BV6, please read the following article. This application shows how to create flexible and robust reports using VB's data report utility. Create flexible and robust reports using VB's datareport utility http://www.codeproject.com/vbscript/datareport.asp 2. If you are using VB.NET, there is a report fasion that is more comlicated than the previous one, just have a look at the following link: Printing a Form in a report fashion (release 2.2) http://www.codeproject.com/dotnet/Printing ...Show All

• .NET Development Sql server 2005 ==> 1000 times slower than sql server 2000 ! WHY ?

  I'm using the developper edition of sql server 2005 with VS2005. Sometimes it works very very slow. I don't know why ! The processor is at 5% but the execution blocks at adapter.Fill(ds). This is the code: public static DataSet GetDataSet( string sql, params SqlParameter [] parameters) { SqlConnection con=GetConnection(); using ( SqlDataAdapter adapter= new SqlDataAdapter ()) { using ( SqlCommand command= new SqlCommand (sql, con)) { foreach ( SqlParameter p in parameters) { command.Parameters.Add(p); } adapter.SelectCommand=command; DataSet ds= new DataSet (); adapter.Fill(ds); command.Parameters.Clear(); con.Close(); return (ds); } } } Is ...Show All

• Visual Studio Catastrophic Failu Visual Studio Crashing like crazy!!! WHAT IS GOING ON!!!

  I reinstalled my whole damn operating system thinking that I had broken visual studio somehow... it turns out that was a collosal waste of time... I have a fresh clean windows xp pro sp2 install, and a clean Visual Studio Professional... and whenever I add a dataset to a project, and right-click the designer and hit "View Code", I get this horrifying error: Failed to view the validation code because of the following error: Catastrophic failure (Exception from HRESULT: 0x80000FFFF (E_UNEXPECTED) and it gives me a blank document. If I click the button to Save All open documents, the whole damn program just crashes!! I've submitted the error reports, but that's not going to help me fix the problem... what is goi ...Show All

• Visual Studio Express Editions I can't get my add new database Source Function to work

  I can't get my add new database Source Function to work. I get this error message:format of initialized string does not conform to specification starting at index 0 I enter the data source configuration wizard. I push the [NEW CONNECTION] button I change the data source from SQL to Access and then press [OK] button and a messagebox appears: format of initialized string does not conform to specification starting at index 0 The question was - is this database file a local access database file or is it residing on a remote machine / mapped drive. ...Show All

• SQL Server Need advice on how to optimize table.

  I have a ledger table that will have many entries for a given invoice, I need a good way to identify the most recent entry for the invoice. I've thought about putting an IsMostRecent flag in the column, but it would still require a table scan to identify the most recent records for invoices. I thought I could build a view over that table that had the invoiceID and max(tableID) and build an index on it, but you can't use the max() function in this instance. The only other thing I can think of us to build another lookup table, with the invoiceID and the tableID, but I don't think that is the best solution. Any tips would be greatly appreciated. Assuming that your Primary Key is CLUSTERED then personally I w ...Show All

• Visual Basic I Have a new question?????

  I have 3 classes that are my companies ok 1 works fine with no problems or quams ok, the other two if I remove the references to the other working class they work fine, However if I add reference to the first class and try to use it I am inundated with messages to send to MIcrosoft so that they can tnker and find the root cause, all I am compiling are classes there are no heavy graphics or aspx pages. these are classes that are migrated from 2K3 where it works fine no warnings no nothing... Now the first class i mention is a comment class, companynameComment, which references CompnayNameutilites, and runs no sweat. CompanyNameUtilities references CompanyNameComment and does not run until I remove this reference, I thought it had something ...Show All

• SQL Server Problem in intranet deployment reports in SQL Server 2005

  Hello Friends, I am using Microsoft Visual Studio 2005 and Microsoft SQL Server Analysis Services Designer Version 9.00.1399.00. My reports behave differently when I deploy them on the Intranet as compared to in the Visual Studio. Problem happens in linked reports. Let me describe the scenario. When I link report A and report B and all parameters on report B are furnished by report A, report B runs fine. But if report B has paratmeter(s) which are not provided by the calling report A, it breaks on the web version. While it runs fine in Microsoft Visual Studio. The top portion of the report B where one can input parameters does not display in the Intranet version of the report. It shows fine in the Visual Studio version. Does any o ...Show All

• Windows Forms A real challenge!

  I have a real challenge. My software is basic a front-end for a database that I created in SQL 2005. That’s the challenge: I don’t want to use the "BindingNavigator", instead of this I want to put the code myself to go to next record, first, etc, in the new icons that I created. But this is not all. Here is the biggest difficult. I have "TabControls" too. So when I click, for examle, next record, the application need to show me the next record, not only in the form, but in the TabControl in the same form and at the same time Did I explained clearly Thanks for those how at least will read this. Hello OmegaMan, Your help was very interesting, but those links you sended to me don’t answ ...Show All

• SQL Server Variable Mapping and Resultset Questions

  I'm just getting started with SSIS and have a couple basic questions. I have a Foreach Loop that iterates over a collection of database names. The collection must include only database names that match a substring. I haven't found a way to filter the SMO Enumerator collection so, instead, I feed the resultset of an Execute SQL Task into the Foreach Variable Enumerator.  Of course this variable (oDBnames) is object type so in Foreach Variable Mapping a string variable (sDBname) is mapped to the only value in the collection (database name). Now sDBname should be available for an Execute SQL Task inside the container. But I keep getting the following errors: Error: 0xC001 ...Show All

• SQL Server Package Configurations

  Hi, I have a package configuration for my SSIS packages to allow me to dynamically change the connection string of the connections in my packages. This was done so that when I deploy my packages to my development or test server, the packages would use either the development or test server name in the connection string. I have set the configuration up to use an environment variable to store the location of the config file (an xml config file). The package however does not seem to be using the environment variable though. If I change the location of the config file in the variable's value, it still points to the old location. Can someone please help. Thanks Okay, sorted that out. Another issue ...Show All

• Windows Live Developer Forums Cannot draw a line, what am I doing wrong?

  I am calling this script from VB.NET, I can plot points and do stuff with the map from VB.NET, but when I go to execute this script, it simply doesn't draw my line: function DrawPoly(id,oLat,oLon,dLat,dLon,width,r,g,b,a) { poly = new VEPolyline( id, [ new VELatLong(oLat,oLon), new VELatLong(dLat,dLon)]); poly.SetWidth(width); poly.SetColor( new VEColor(r,g,b,a)); map.AddPolyline(poly); } From VB.NET: executeScript("DrawPoly", NextPinId.ToString, midLat.ToString, midLon.ToString, destLat.ToString, destLon.ToString, "2" , "0" , "235" , "0" , "1" ) I did have that, but I figured out that I ...Show All

• SQL Server Sql server 2005 sp2 and oracle access

  When I try to create a model in Report Builder based on a connection to Oracle 10g database I get the following error. ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED } Is this a bug in the CTP version or am I missing something I think this is connection properties problem on the client machine where, I assume, you run Model Designer. If possible, could you please zip your model project and send it to me so I could make a quick check. almineev on the msft com ...Show All

• SQL Server multiple partitions management at once

  Hi, I have defined a fixed set of partitions based on queries that dynamically affect quarters of data to each partition so I never have to create or update a partition manually nor I have to use AMO to create these partitions. What i note is that in VS you can select all the partitions and start the aggregation wizard. What leave me confused is that everything looks like the wizard does not use the multiple selection for everything it does. I know for sure that the Count feature only count for the first partition, the rest of them are left with 0. Then, the aggregations seems to be applied to all partitions. What aggregations Are they the same for all partitions So I feel it is safer to define the aggregations partition by par ...Show All