CCJJ's Q&A profile

• SQL Server Problems attaching to database from VWD

  Hi Mike, I hope you can help me with my SQL Server Express problem. I have a database that was created in VWD Express 2005, that is currently in C:\web projects\project name\App data...etc. I have been able to connect to and use the database with an application that I am building as a learning exercise, ( I'm a complete newbie to .NET and SQL Server) but now I can't connect to the database from SQL Server manager. I have tried attaching the file which has worked a few times, but now that won't work either. I keep getting a message that the file can't be found or I do not have sufficient permissions to access it. I can connnect to the file fine from within VWD, but because of the above problem I can't now run the application (it throw ...Show All

• SQL Server Drillthrough returning sets of duplicate rows

  Drillthrough appears to be showing multiple rows for each single record that should be displayed. For example, in my fact table, there is a single record for each trip. The following MDX query returns a single cell with a trip count of three. SELECT NON EMPTY { [CP Date].[Date by Month].[Year].&[2002] } ON COLUMNS , NON EMPTY { [Commodity].[Commodity by Type and Group].[Commodity Type].&[Other] } ON ROWS FROM [Barge Trip] WHERE ( [Measures].[Trip Count] ) 2002 Other 3 If I drill through on that cell, exactly three records should be returned. However, in actuality, 12 rows are returned - three sets each having four identical rows. To drill through, I am simply adding the D ...Show All

• SQL Server Saving a package to the package store vs. SQL Server?

  There must be a difference, but I don't know what it is. Can someone please explain the advantages and disadvantages of each method Thanks in advance. Very interesting question. :-) I would like to add one more poin to this. Does execution of a package depend on SSIS service Jagan ...Show All

• Visual Basic How to not get combobox SelectedIndexChanged be executed on load

  Hello, As what the subject line is.... What is the method to not allow combobox SelectedIndexChanged to be executed on load... and only make it to be executed when a "USER" changes the selection value. Thanks Why not set the handler for the event to nothing, load the control, then set the handler to the routine you want to handle the event, a lot simpler than watching booleans and also reduces execution time as the handler is not executed for each add. Try: [code] RemoveHandler cboTerm.SelectedIndexChanged, addressof cboTerm     With Me.cboTerm             .DataSource = Me.MiscDataTableTableAdapter.GetDataByTerm ...Show All

• SQL Server problem using System.Data.Oledb.OleDbDataAdapter for importing Excel

  Hi All, I am facing this weird problem of partial data being fetched when using oledbadapter for fetching data from a Excel spreadsheet. A few cells containing text values are not being fetched..I get an empty string. When i replace this text value by an integer, the problem is no more a problem... Anyone having faced this problem or having knowledge about this..pls respond.. Thanks in advance ...Show All

• .NET Development key container security

  I'm trying to make an asymmetric key available across all users of a machine. Dim cp As New CspParameters() cp.KeyContainerName = "Red Pill" cp.Flags = CspProviderFlags.UseMachineKeyStore Dim rsa As New RSACryptoServiceProvider(cp) rsa.PersistKeyInCsp = False rsa.Clear() cp = New CspParameters() cp.KeyContainerName = "Red Pill" cp.Flags = CspProviderFlags.UseMachineKeyStore rsa = New RSACryptoServiceProvider(cp) First of all, is that the correct way to do it Second, if I run this from an admin account, and then run it from a limited account, I get an "Object already exists" error. What can I do to make it so any user across the machine can access ...Show All

• .NET Development WCF Installation Error

  [08/29/06,16:03:00] ========== Logging started ========== [08/29/06,16:03:00] ===================================== [08/29/06,16:03:00] No language specified in ini file default to OS language [08/29/06,16:03:01] Set lang to 1033 [08/29/06,16:03:01] Pending Reboot Table state : Logging start [08/29/06,16:03:01] _________________________________________ [08/29/06,16:03:01] (, ) c:\641d25ecce0074d39296aa2498 ( ---- ) ( Tue Aug 29 16:00:47 2006 ) Delete [08/29/06,16:03:01] Pending Reboot Table state : Logging end [08/29/06,16:03:01] _________________________________________ [08/29/06,16:03:01] Logging property values [08/29/06,16:03:01] PROPERTY ProductName Microsoft Indigo Beta 2 Runtime [08/29/06,16:03:02] PROPERTY c:\dd5a351bb9df65c ...Show All

• SQL Server rows per batch vs. maximum insert commit size

  This has to do with an OLE DB destination with the fast load data access method. 1. I have an intuition about what rows per batch means, but I've read that -1 is the default value -- which means simply that it hasn't been set. In that case, how many rows are buffered into each batch 2. What are the units for maximum insert commit size (bytes, kilobytes, megabytes, gigabytes, ...) 3. I'm working on a package for a large bulk load that has about a dozen concurrent data flow tasks, each of which uses the same OLE DB destination (well, a copy). Of course I've disabled the destinations' table locks so these tasks don't deadlock. Given that each of these data flows is writing several million pretty small rows, how should I set those op ...Show All

• Software Development for Windows Vista Adding Custom ExternalDataExchangeService via web.config

  Was really excited when I read the following in the "What's New" doc for the VS WF Extensions install.. 10.1.1.2 Host and Services Migration and Code Changes The host won’t need to manually add services to the ExternalDataExchangeService. All of this can be done via the Application or Web configuration files. So... while leaving the existing ExternalDataExchangeService line in my web.config file, I added the following line (eager with anticipation... :D) < add type= "custom.assembly.MyCustomServiceType, custom.assembly, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" /> But alas, as soon as I removed the code I had been using to "manually" add my custom service and restarted the app ...Show All

• Visual C# How can I move a property from a control to another form already shown?

  I have form1, form2 on-screen, both of them already shown. When I press a button on form1, I want : form2.txt2.text = form1.txt1.text Note: form1, form2 are already on -screen, so something like: form2 f2; f2 = New form2(); f2.Show() would produce a second form2 form, and I really don't want that ... Please .... you have a couple of options from your example: make the textbox public in form 2, so your caller can access it better way would be to make a public property in form 2, so you can get and set the textbox value from the caller. Example: //form 2: //global public string SetTextBox1 { get { return this.textbox1.Text;} set { this.textbox1.Text ...Show All

• SQL Server Job Fails on Linked Server

  I've got a job running on a SQL2005 box (server07) that modifies data on a SQL2000 box (server05). The databases on the 2005 were imported from an older box running SQL2000. The step that is failing is: update server05.xtender.sysop.ae_rf4 set field3 = sname from server05.xtender.sysop.ae_rf4 x inner join allscholarships..studentsindb_table s on x.field1 = s.ssn where x.field3 is null or len(field3) = 0 The history shows this for the failed step: Message Executed as user: Domain\Administrator. Access to the remote server is denied because the current security context is not trusted. [SQLSTATE 42000] (Error 15274)Unable to open Step output file. The step failed. Domain\Administrator is a sysadmin on both boxes. This job had been running ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Creating a GUI builder in visual studio

  I'm curious as to #1 if it's possible and #2 how to get started building a GUI creator where you can drag and drop gui controls in 'design time' to create code files or a form of XML How do I tap into vs.net to create my own design time/code time pages The GUI controls wouldn't be .net controls, but controls that inherit from a custom gui control class and so on. Thanks, Jonathon More specific to designers and serialization of code, you may want to read this: http://msdn2.microsoft.com/en-us/library/aa720032(VS.71).aspx You'll note that this is all about designers for Winform controls and Components, which is not what you want to do. However, you can read this to get an idea of what a visu ...Show All

• SQL Server PROBLEM: Report parameters can not be set. Default values always take priority.

  I am trying to create a report with parameters which are prompted by the user and are initially populated with default values. However, whenever I edit the parameters in Report Viewer and click 'View Report', the parameter values revert to their default value. The user-specified parameters never "stick". Please help! The xml looks like this: <ReportParameters> <ReportParameter Name="ConnectString"> <DataType>String</DataType> <Prompt>ConnectString</Prompt> <Hidden>true</Hidden> </ReportParameter> <ReportParameter Name="FromDate"> <DataType>DateTime</DataType> <DefaultValue> <Values> <V ...Show All

• SQL Server SQL variable and IS variable in Execute SQL Task

  Hi,   I have an Execute SQL Task (OLE DB Connnection Manager) with a SQL script in it. In this script I use several SQL variables (@my_variable). I would like to assign an IS variable ([User::My_Variable]) to one of my SQL variables on this script. Example:   DECLARE @my_variable int , <several_others> SET @my_variable = <do_some_stuff>   Of course, I also set up the parameter mapping. However, it seems this is not possible. Assigning a variable using a only seems to work in simple T-SQL statements. I have several reasons for wanting to do this: - the script uses several variables, several times. Not all SQL variables are assigned via IS variables. - For read ...Show All

• Visual Studio Team System Webtest configuration settings

  Hello, is there anywhere to store configuration settings in an XML file format within a webtest as I need to deploy the webtest solution to multiple environments - ideally with no changes (and no recompile) - just the existance of a pre-created config file that is not copied over when the solution is deployed. I can't put all settings into a database as I still require a parameterised connection string to get to the database. I don't want to use context parameters unless I can change them via configuration settings. Deploying to another environment requires these to be changed as they exist within the .webtest files. I don't want to use the properties\settings as this is csharp code and would require a modification and compile af ...Show All