comspy's Q&A profile

• SQL Server Identifier! [problem in passing a lengthy string to an SP]

  exec sp_SearchProductAdvanced "(name LIKE '%a%' Or name LIKE '%b%' Or name LIKE '%c%' Or name LIKE '%d%' Or name LIKE '%e%' Or name LIKE '%f%')and (salesprice between 3 and 10) " ,null after executing i got this error: The identifier that starts with '(name LIKE '%a%' Or name LIKE '%b%' Or name LIKE '%c%' Or name LIKE '%d%' Or name LIKE '%e%' Or name LIKE '%f%')and (salesprice ' is too long. Maximum length is 128. how can i solve this problem. so that i can use more values . my lenght exceeds 128. is there any way to get rid of this. in my SP i have declared the parameter variable as @criteria nvarchar ( 1000 ) Just in conjunction with the above post, ...Show All

• Visual Basic Side-By-Side deployment of COM Components

  I'm trying to deploy a COM application written in VB6 on XP machines in a side by side mode.   The application consists of EXEs, DLLs and OCXs. The DLLs work fine however, the OCXs give a problem.  If the OCX is drawn on the EXE screen it loads & shows OK (suggesting the the manifest for the OCX is ok).  However, dynamically loading the control using Controls.Add gives a runtime error of 336 - Component not correctly registered.  This happens only for Public controls and not the private ones. Does anyone know why and is there a workaround   I can't make the controls, that give an error Private, since there are being accessed from several other external components. ...Show All

• .NET Development Dataview.Sort not working.

  This is weird. I have a DataView that I create from a DataTable like this: ------------------------------------------------------- DataView masterDv = new DataView(masterTable); ------------------------------------------------------- Column #12 is called 'CLIENT': ------------------------------------------------------- masterDv.Table.Columns[12].ColumnName="CLIENT" ------------------------------------------------------- When I set the sort property of the DataView, the Dataview doesn't change. masterDv.Sort = "CLIENT"; ------------------------------------------------------- Am i missing something thanks. doug Hi there, I think th ...Show All

• SQL Server Report Manager not responding

  Hi, I'm hoping to get some help here. I've spend countless hours trying to get Reporting Services running without success. When I run the Report Manager it does not respond. Coming up with Opening page http://localhost/reports/Pages/Folder.aspx . . . The progress bar ticks along but the page never actually loads. The Configuration tool shows green icons everywhere. No errors in the Event viewer. I am running Windows XP Professional with SP2. I have uninstalled and re-installed IIS, ASP.NET and SQL2005 numerous times. Varying the order, all without success. What else is involved I have loaded Service Pack 1 and the latest hotfixes. What else can I try Thanks in advance, Claude Some further ...Show All

• SQL Server Error 15401 Adding Domain Group to SQL Server

  I have tried rebooting the system, I have ran the script to look for duplicate sids and am still having the issue when trying to add a domain group to SQL. I get the Error 15401: Windows NT user or group'mi\Trust Legal' not found. Check the name again. Running SQL 2000 Std, with SP3a, and the collation is set to SQL_Latin1_General_CP850_BIN, which makes this instance case sensitive, and the group name is spelt right and am following the case sensitivity of the name as well. Interesting idea, now when I try to add a user MI\15451a it works fine, when I try to add another group MI\Trust Technology Services it works just fine, just an issue so far with this one group MI\Trust Legal, arrgghhhhh this sucks. @ this point, if I cant get it ...Show All

• .NET Development cs0006 error.

  Hello I have a single website. And I got this strange error. CS0006. Afer that I delete some temporary files on  this folder. C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files I restart the vs2005 and it works. but its driving me crazy is that a bug I have no references on my website or strange things. It only  has some pages with webparts. I managed to get rid of this issue by deleting the bin directory completely.  As mentioned by PeteL, all content in there should be replaced automatically during a rebuild.  The wierd error simply stopped appearing once I did this. I have no idea why it happened. ...Show All

• Visual Studio Team System Creating different versions of the same project

  Is it possible to create different versions of the same project without having to save the entire project with a different name every time For instance, if i have a file called Main.aspx, is there a way to have Main.aspx version 1 and Main.aspx version 2 Thank you! Like Luis said, this can be achieved through source control functionality. Take advantage of the branching capabilities if you want separate versions of the same project/file(s). ...Show All

• Visual Studio 2008 (Pre-release) launching a WPF window from a windows forms app

  I have an exisiting winforms app and I want to open a WPF window. So I tried: Window1 wpfWindow = new Window1 (); wpfWindow.Show(); and I get the exception "The calling thread must be STA, because many UI components require this" . So I did some reading and found out why WPF needs to run in STA, but I can't find an example on how to launch my window so that is does. The way I did get it working was to do this: public static void button_Click ( object sender, EventArgs e) { Thread thread = new Thread ( new ThreadStart (CreateUIInAnotherThread)); thread.SetApartmentState( ApartmentState .STA); thread.Start(); } private void CreateUIInAnotherThread() { Window1 wpfWindow ...Show All

• Visual Studio 2008 (Pre-release) Does this model look "feasible"?

  I want to setup a "chain" for a business application model and this is what I envision: Database > TCPchannel or named pipe > DataLayer Service > TCP channel or named pipe > Business Object Service (Using Business Object library) > TCP Channel or named pipe > Business Presentation Service (Using Presentation Library & Business Object Library) > wsHttpBinding with two channels > Certificates only (intranet/ VPN) & server certificate with UserName (typical web access) > Web Hosted Client and Winforms Client (Using presentation library) Essentially, I have a third-party ORM that works very nicely to create the data la ...Show All

• Smart Device Development Type is not defined

  Hi, I have a create a new project (Control Library). And I am using this code. However it returns the following error: Type 'PasswordDeriverBytes' is not defined regarding the SetKey function. (highlighted in bold) What am I missing out. I originally took this code from a windows form (for a desktop not PPC). I really need to get this fixed. Thanks in advance Imports System.Security.Cryptography Imports System.IO Public Class PDACrypt Public Sub New () MyBase . New () InitializeComponent() clientRC2CryptoServiceProvider = New RC2CryptoServiceProvider() End Sub Public Shared clientRC2CryptoServiceProvider As RC2CryptoServiceProvider Private Function SetEncKey( ByVal pwd As String ) As Byte () Dim dr ...Show All

• Smart Device Development How to update mobile application easily

  I have a Smart Device Application (Compact framework 2.0). How can I update it easily With Click Once (Supported by compact framework ) With Web Services Others solutions Which is the best solution to update mobile application easily Thanks I don't believe clickonce is supported. if you're connectivity dependent to begin with, keep as much functionality as you can within web services. if you need to update a local binary, you don't have a lot of options -- do an md5 digest comparison between installed and remotely maintained binaries, download as necessary. a separate executable that's called after a binary download should handle the job of replacing the existing binary after the app shuts down ...Show All

• Smart Device Development UPNP Argument

  Hi Alex ! Thanks again for all you help. I manage to go further. The problem of SID (0x80040207) is solved. To help me understand some stuff, I compiled the sample that we can find in the platform SDK (upnp/netds/genericucp). But it seems that there is some trouble with argument of actions. Here what I'm doing : - Launching GenericUCP.exe - Start DIscovery (It found a windows media connect server of mine, that is on a computer on the local network) - I select the following service : "urn:upnp-org:serviceId:ContentDirectory" - I type the action I want to invoke (i.e: GetSearchCapabilities) - I fill in the argument (i.e: SearchCaps) - I click on the "invoke" button, and I have the following mess ...Show All

• Internet Explorer Development IE 6/7, restart computer on plugin update

  Hello. I noticed that after some Windows Update, IE6 (also 7), XP, asks to restart the computer after some plugin was sucessfully updated. The plugin is not in use at the moment when the webpage (that requires the plugin) is loaded. Do you know why And, most important, does anybody know a way how to avoid the restart Thank you. Cosmin Some install programs will ask you to reboot even when it's not strictly necessary. But if we're talking BHOs and extensions, you should make sure all iexplore.exe processes are terminated before upgrading. Some BHOs/extensions may be locked by the explorer.exe process as well, though. In that case you probably can't avoid rebooting. Troels ...Show All

• Visual Studio Express Editions tableadapter convert or something else

  hi, for a task at school I need to make a program that calls up data from the database with a barcodescanner, th problem is that the fill of my tableadapter needs an integer but the barcode number is to big to be an integer any one got some advice doubletrouble, The TableAdapter object is filled by dataset, I suggest you to redesign your DataTable in DataSet, firstly make the barcode number to string, then convert it to integer in your memory datatable. Actually, there is soomething wrong with your database. I suggest you to change the certain data type for your field if it is possible. ...Show All

• Visual Studio Code examples are indented

  I have written some code examples using a code element within an example element in my XML comments. When the documentation is generated using the vs2005 styles, the code is indented compared to the rest of the text. Is this a known bug Hi ploeh, This was an item in a thread back in Sept 2006. For starters, you can try this and see if it works: In Visual Studio 2005, go to Tools > Options > Text Editor > XML > Formatting: In the "Auto Reformat" dialog section, uncheck the "on completion of end tag" checkbox (it's checked by default). This should keep your intended indentation format, but I don't know if Sandcastle will reinterpret it. Here is the link to the thread: http://forums.microsof ...Show All