RookieDBA's Q&A profile

• .NET Development how do I change a field having PrimaryKey???

  Dear All; I want to change just a No Duplicate field in a Row having Primary Key. When i follow as given in MCAD/MCSD code snippet as follows: Dim rowChange as DataRow rowChange=m_dtContacts.Rows.Find(m_NextID-1)  rowChange.Item("Workphone")="(555)222-90000)" it threw an exception of type "Dublicate Key.." Is there any helpfull tip for solving such problem Thanks alot   Hi, Try checking the RowState if its percieved as a newly created row. Also check the UpdateCommand if it has the right Update Statement... I don't currently have a VS in front of me now. I'll try your code as soon as I return to my office. I'll gi ...Show All

• Visual Basic Cannot save my.settings if one of the setting fields is a sortedList

  The following gives me a null reference error. Setting: name = Recipe, type = SortedList, scope = User Code: my.settings.Recipe = new SortedList my.settings.Recipe.Add("aKey", "aString") my.settings.Save() < Null reference error occurrs here. I have tried (and failed) with many different approaches to use a sorted list in my.settings. I would love to know the correct way to do this. Steve, I copy and paste your code: my.settings.Recipe = new SortedList my.settings.Recipe.Add("aKey", "aString") my.settings.Save() Into a test app after setting up the use ...Show All

• Visual FoxPro =SYS(1037) on VFP90 no longer allows printer changes

  Can anyone tell me how to work around the changes in SYS(1037)   I used to call this with =SYS(1037) before printing in a batch (checks and invoices) and it no longer allows my customers to change the printer in VFP90 (no 'apply' button).  The 'prompt' option in REPORT FORM works just perfect too, but I don't want to call it in a loop (too repetative.)  Any ideas Thanks The problem was solved by removing ALL references to the printer driver and setup in the report form itself.  Previous versions of VFP must not have been as 'pickey' (technical term) with regard to SYS(1037): Open *.frx with USE Find record with Objt ...Show All

• Visual J# Maybe stupid question but: How to get float out of System.Single?

  What is the method to extract value from System.Single to standard float variable (defined float x = ) when using J# This sounds so trivial that I must have overlooked something when I did not find the way I have to use System.Single when I'm communicating with certain COM controls. This question is better suited for the J# forum. Please reserve the Base Class Library forum for questions related to the BCL itself. I'm moving the thread to the J# forum. In answer to your question Lucian is correct that a float and System.Single are the same type. However in J# there is not a direct conversion between S ...Show All

• SQL Server Getting data from 2 different sources

  Hi, Im using SSRS to create a report which has one table that resumes a state of something. I have this information in 2 diferent tables and im using mdx querys. My inforamtion is like this Table 1 S M L Total Shop Stock 1 4 3 8 shop sales 2 4 2 8 Table 2 S M L T Warehouse stock 2 6 5 13 I would like to have Table S M L T Shop S 1 4 ... Ware S 2 6 ... T ...Show All

• Visual Studio HELP PLEASE: Where is Microsoft.ReportViewer.ProcessingObjectModel.dll?

  Where is Microsoft.ReportViewer.ProcessingObjectModel.dll Its' not on my B2 system, though the other two are. C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\Microsoft.ReportViewer.Common.dll C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\Microsoft.ReportViewer.WinForms.dll ... No ProcessingObjectModel.dll here It does show in the GAC,  and it d/n show in the list of avaialble .NET assemblies to ref. Is this error related to the above issue "Processing Errors" "Failed to load exressions host assembly.  Details: Could not load file or assempbl 'expression_host_601.....' version=10.2.50215.44, culture=nutral,...  Fail ...Show All

• Visual Studio deployment - crystal error

  Hi there, I have an application built using visual studio 2005. there are crystal reports in this application. I built the websetup project and used the merge module embedded reporting.msm and published my website. On every page that there is a crystal report I get the following error: Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) I would really appreciate any suggestions on this. Thanks and Regards ...Show All

• .NET Development Help : "error: 40 - Could not open a connection to SQL Server"

  I'm using VS2005 and SQL2000. I created a database name "myDatabase" in SQL Server 2000 and built a website that connet to this database. When I'm running this website in VS2005 IDE (press F5 or Ctrl-F5), everything is OK. I publiced this site. When I connect to database on my computer, everything is OK also, but when I connect to database on another computer, an error occurred like this : "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, ...Show All

• Visual C++ Visual C++ 1.52

  I need a copy of Visual C++ 1.52 for an application.  Any Idea where to find one The 16-bit Visual C++ 1.52 compiler is available on MSDN Subscriber downloads ( http://msdn.microsoft.com/subscriptions ). I'm not aware of anywhere else that you can get it. Cheers, Kenny Kerr http://weblogs.asp.net/kennykerr/   ...Show All

• Visual Studio unable to deploy vs2003 add-in on another machine

  Hi All, I have created a visual studio 2003 add-in. This add-in works well on my development machine but does not work on another machine. While initializing add-in gives following error. Add-in failed to load or caused exception. Error Message: The system cannot find the file specified. Error number: 80070002 If I create a simple add-in on my dev machine and try to deploy on other machine, it works. But if my visual studio add-in which is using any other user created COM dll then it won't work. Steps followed to install add-in on other machine: 1. Copy add-in dll and COM dll in a folder of target machine. 2. Register add-in dll with regasm ...Show All

• Visual Studio 2008 (Pre-release) Real World Localization of WPF Project

  Hi All, So I have read the articles about WPF localization. The bottom line is that after a 9 step process (create neutral, add "current culture code', add UIDs, update csproj, rebuild, extract with locbaml, translate csv, create target folder, generate target with locbaml) we end up with a YourApp.resources.dll which contains the GUI of your XAML in the target language. OK. Now a real app has some resources such as strings and images. In Windows Forms we learned how to use resx files for them. That was convenient since the resources could be addressed as properties of an object (Sring a = Resources1.ID1). So what now Thi ...Show All

• .NET Development Windows Service using Sockets

  I am experiencing a wierd problem... I have a C#.Net application Server which uses Sockets. It listens on port 11000. and it runs as a Windows Service. -- If I run it as a consple Application, I can connect to that port/Application from any machine on the network as well as from my local machine. -- BUT If i install it as a Windows Service, I cannot connect to it from the network though it works just fine form the local machine. --And one more strange issue, If I install it using the InstallUtil.exe, it works fine ! That is I can connect to that port/Application from any machine on the network as well as from my local machine. ...Show All

• Visual Basic Autohidden code in Visual Studio .NET 2005

  Hi everybody. First of all; NICE work with the new Visual Studio .NET 2005. We have come a long way in intuitive development, but VS.NET still amazes me. My question: Where are all the hidden code in VS.NET 2005 gone to I know that most of all code is hidden into class separation (using the .designer.xx files), but I really used the dropdowns for overriding code etc. The two dropdowns on top of the code, would show all overload able methods as "non-bold", but I can't find these in VS.NET 2005. They do in fact be listed within intellisence, but isn't there any way to switch back to the old classic' Vs.NET 2003 view mode Regards R ...Show All

• SQL Server insert statement

  Hi I am having a few problems writing an insert statement. I have a customer table with lookup values inserted in some of the columns which reference another table customer table name address1 status test high street 0 lookup table code description 0 deleted 1 customer ----------------------------- I need to insert data from the customer table into another but not us the lookup table, the statement i have written is: insert into export (name,address1,status) select name, address1, ( select descritption from lookup inner join customer on lookup.code = customer.status) fr ...Show All

• SQL Server Cannot change naming metadata

  Hello, I've found a bit of an infuriating nuance in SSAS2005. My cube used a view called view1. At some point in time the DSV was changed to use a very similar object called view2 instead. I got a failure when processing the cube. The message was: Errors in the OLAP storage engine: An error occurred while processing the 'view1' partition of the 'foo' measure group for the 'bar' cube from the foobar database. In other words...the name of the object in the deployed DSV is still view1. I've looked at the XML and it has a friendly name of view2 (helpful) but the object name in the message above is really really misleading. ...Show All