cbell's Q&A profile

• SQL Server RECEIVING messages from a Windows service

  I've done a bit of work with the External Activator but I think it may be a bit overkill for what I need to do (which is RECEIVE messages from a single queue and process them with managed code). I've tried creating a Service Broker Interface service that retrieves messages from this queue, but I notice that if I set the timeout to -1 to watch for messages indefinitely, the Service never completes the OnStart code. I notice if I change the ser ...Show All

• SQL Server Passing empty result set to sub report

  I need to pass some ids to my sub report after doing some validations in the main report. The sub reports are generated properly if the result set of the mail report contain some data. But if the result set is empty,still the call to the sub report is done and the report is giving error saying -- "Error in processing the sub report" since the ids are not present and null is passed to the sub report. How can we handle this situation ...Show All

• SQL Server SQL 2005 woes

  I installed VS 2005 & SQL Server 2005. When I use SQL Server Management Sudio,  I can create a new database in SQL Server 2005, but when I try to create a new table in that database, I get the following error: "Class does not support aggregation. Microsoft.Sqlserver.Sqltools.VsIntegration" any help would be appreciated. Thanks Does this happen when you create the most basis table   If not, what is ...Show All

• Visual Studio Where can i get more documents of DLS Tools for developer?

  hello everyone , i am chinese, first, please excuse my weak english; i had work with DSL Tools ,but i am getting a trouble to DSLDD files defines, who can help me ,and indicate me where i can get more documents for developer thanks Matt.Lin Matt.Lin, The DSLTools zip files contains a few documents that provide some background information. Also a little about the structure of the underlying xml files. Maybe that docs can h ...Show All

• Windows Forms How to scope across multiple projects in a solution

  I have created a solution that contains multiple projects in Visual Basic.  One of the projects is identified as the startup project, and that startup project contains a startup module. The startup module creates instances of forms that are defined in&nb ...Show All

• Visual Studio Express Editions How to import a .DLL at runtime?

  How do I import a library contained within a .DLL file at runtime, given its path Is this even possible in VB.Net 2005 Express Do you mean a managed or unmanaged dll If a managed one you can simply load the Assembly with one of the many load functions provided by the assembly class. If on the other hand you mean an unmanaged dll this gets a little tricky as you would need to know the name of the dll, the name of the function(s) you w ...Show All

• SQL Server SQL DataReader Mischief ! HELP !

  Why oh, Why is this happening.. Fastest winner gets a gold star ! hehe Just after i check the value of the data reader against the string in the IF statement, the code skips. If there is a record (=) to my varible everything is fine. However the IF ELSE will not work inside the While loop ! If i remove the record from the database and run the below code the IF statement skips (well skips the (Else)) and bombs out. Public Sub ...Show All

• SQL Server recover deleted data

  I want to learn that if my query deleted all data in the table by mistake, is it possible recovery and how Hi Sinem, If you did taht in a transaction: BEGIN TRANSACTION <DELETQuery> --YOu Can do a ROLLBACK Here If not or you commited it’, you need a backup to restore. If you have a Full backup and kept the transaction log backups you can do a Point in time recovery to the second where you deleted it. No ...Show All

• SQL Server Connecting to SQL2005 Developer edition

  I'm attempting to connect to and instance of SQL and cannot seam to find it. The server logs says its listening on '127.0.0.1 <ipx4> 1545'. Kind of stuck what to check next. Will using pipes help What do I need to do Hi, check if the port listening or not using command prompt as: netstat -an | find "YOUR PORT NUMBER" for exampl, my SQL Server is listening to port 1433: netstat ...Show All

• Smart Device Development doubt in Bootstrap setup.exe

  Hi , I created a setup package for netcf.When i install it from desktop using Bootstrap setup.exe it asks wheather to install framework 1.1 when net framework is not found.I should not get this message but the framework should be installed silently without giving confirmation message. how can i do it Hi Senthil, I have a couple of questions: 1) I am assuming that you have created your deskto ...Show All

• SQL Server SQL Server 2005 Integration Services DTS Package

  Is it possible to create a package in Integration Services under BI to do the following in a project:  (1) Place an envent on an existing database table ,  (2) When an insert occurs to the table a Message Queue Task is executed, (3) Send stats from the table in a message to a Message Queue If so how do yo do this and is there a good example or tutorial that details how Thanks DonH i do ...Show All

• Visual FoxPro Call application from program and trace Menus and Programs within

  Hello, Can anybody help me please Am trying to call an application from another, but having a problem tracing the called program's Menus and Programs. At the beginning it started by having the Encrypted checkbox automatically selected after building project and an application (the application I will be calling) while I de-check it myself. I tried creating the project from the beginning and somehow this stopped, and I could trace again, ...Show All

• Windows Forms Open/ Save/ Print?

  I have created a very simple windows form. A Questionaire!!! Has tabbed pages Has user inputs. text boxes for names and address etc. also has combo boxes that are just " Yes , No, Unsure" All I want is to be able to open and existing file ( if there is one) save the file once the questions have been answered and print the results of the combo boxes and text box. Where to begin Probably with the MSDN. The System ...Show All

• Visual Studio SourceSafe detects different character encodings on different versions of the same project file (.csproj)

  Using Visual Studio 2005 with Visual SourceSafe 2005 (Version 8.0.50727.42). We have a Visual Studio project file (.proj) that has been changed 21 times, resulting in 21 SourceSafe versions. I personally checked in version 20. Now using the history and compare functions on any version (including version 21 checked in by another programmer) as compared to version 20 results in the message: "The character encodings on these files are diffe ...Show All

• Visual Studio CrystalReportViewer Deployment

  I have a problem in the release version of VS2005. When I create a simple Crystal Report application and try to run it, I am fine on my development box, but when I deploy it to another machine and try to run it, before the form's Load event (I have a MsgBox in that event that never appears) I get an error box wanting to send a report to Microsoft; when I look at the contents, I see: Error signature EventType: clr20r3   P1: expirationre ...Show All