Aaron Leiby's Q&A profile

• SQL Server <Host System.Messaging in CLR>

  Hi All, i am trying to host the system.messaging.dll in SQL Server. I get the usual warnings about not being fully trusted. I am prepared for MS not supporting. But, when i execute my trigger (which writes to message queue), the trigger fails with an exception of 'That assembly does not allow partially trusted callers'. So. is there no way for me to write to MSMQ using triggers Do i have to rethink my strategy imports System.Messaging Dim msmq As MessageQueue = MessageQueue.Create( ".\TestQueue" , False ) msmq.Send( "Test" ) Thanks for the help Did we ever get an update on this I'm also trying to solve is issue. Trying to use the system.messaging with ...Show All

• Visual Studio Install VS2005 after SQL 2005: Report Designer package fails to load

  I installed SQL2005 with Reporting Services and Analysis Services. It installed a stub version of VS2005 for the Report Designer the the BI Designer. Now, after installing Visual Studio Pro, the Report Designers and other designers installed by SQL2005 will not load into VS2005. VS2005 was not listed in the Add/Remove programs after installing SQL2005, so I did not uninstall anything prior to installing VS2005 Pro. How can I fix this Is there a way to "reregister" these packages so they will load, or do I have to reinstall everything in some particular sequence I'm not at that site today, so I can't reproduce the exact package names and GUIDs from the messages, but the error messages were of this form: ...Show All

• Visual Studio Express Editions Detecting a serial pinchange, and the pin it rode in on.

  Hello, I've been trying to piece together an event handler for a serial pinchange event. I have what one would expect: Private Sub SerialPort1_PinChanged(ByVal sender As Object, ByVal e As _ System.IO.Ports.SerialPinChangedEventArgs) Handles SerialPort1.PinChanged msgbox("pin change") end sub which works great. But I don't know how to tell WHICH pin is changed. I know that VB knows, but I can't figure out how to get it to tell me if it's the DCD, DSR, CTS, or RI pin. I'm in my 3rd week with Visual Basic, trying to do my own version of the infamous KegBot. When I look to the reference material on pinchange events it still all seems like gibberish to me. I just don't speak the language yet. an ...Show All

• SQL Server Create a custom login.

  Hi all, I need an user to do the following tasks. What kind of login I could provide him and how do I give him rights to do them without providing hin the SA (sysadmin role) Create Login Create Database Create Tables ( with Pks, Fks & Indexes) Create Stored procedures Create Functions ( table valued / scalar valued) Insert Master data Create Jobs Execute Job for first time Populate sample Thanks in advance, DBAnalyst Refer to books online about database fixed roles for the steps you have asked such as: 1) db_accessadmin 2,3,4,5,6 & 7) db_owner ...Show All

• SQL Server multivalue parameters - is this possible ??

  i am trying to build a report that uses multivalue parameters - the report is a simple listing report that lists out a list of cases as a table - the data is obtained from a view which just returns all details for all cases there is no user input for the selection details - am going to be calling the report and passing over the parameter values directly to it. there are several parameters for the report - they all default to "All" for each of these parameters, i need to be able to either use the default value of "ALL" or to enter a list (comma separated ) q1) could i just enter the list as a string comma separated list (rather than as multivalued parameters) and then use this list to filter the data usin ...Show All

• SQL Server Group age by a parameter and find out the value corresponding to that.

  Hi guys... My goal is to change the given stored procedure so that I can find out the different age gorup according to users parameter and find out sumof these values for that group: s.TVmins, s.Notional$, COUNT(*) AS Qty, SUM(s.TVmins) AS TVMinsAmt, SUM(s.Notional$) AS NotionalAmt For that I am planning to put another parameter @count for the group interval and I need to group accordingly. So my answer should look like: if the user give the @count value as 10: the result should: age group TVMins Notional 1-9 1560 125632( the sum of that particluar group) 10-19 -- -- --- 91-100 -- --- I have a field DOB( Date of birth) , I have to extract age from that field first and then g ...Show All

• Visual Studio 2008 (Pre-release) How do I pass credentials in an IIS Hosted WCF Service

  How do I pass credentials in an IIS Hosted WCF Service Can I pass the credentials in the client code instead of the client config. What would that look like What do I do to get the Service to accept those credentials I am sorry. I am a beginner. Most of that went over my head. I have the following client code: // Open channel to the service Uri uri = new Uri("http://10.14.1.50/JOHN1/service.svc"); // ChannelFactory<HelloService> factory = new ChannelFactory<HelloService>(new WSHttpBinding(SecurityMode.None)); ChannelFactory<ICalculator> factory = new ChannelFactory<ICalculator>(new WSHttpBinding()); ICalculator p = factory.CreateChann ...Show All

• SQL Server What system stored procedures have changed between SQL 2000 and SQL 2005?

  What system stored procedures have changed between SQL 2000 and SQL 2005 I don’t know such paper either, I think the main internals was, that they changed the access to the system tables, as they are now put into schemas, rather than just owners. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Application hangs on SqlCeConnection.Dispose()

  Hi, I'm having the problem that my application hangs on SqlCeConnection.Dispose() when I'm closing the app. public class DatabaseManager : IDisposable { private DbConnection connection = null ; // Singleton private DatabaseManager() { this .CreateConnection(); } ~DatabaseManager() { this .Dispose(); } public void Dispose() { if ( this .connection != null ) { this .connection.Dispose(); } } // ... } This only happens when I'm calling Application.Exit(); and Dispose is called through the destructor of the DatabaseManager class. When I'm disposing the connection during normal work the call works as intended. BTW I'm using SQL Server Mobile 3.0.5214.0 on a PPC 2003 AKU2 (Symbol PPT88 ...Show All

• .NET Development Using a Dynamic Assembly built using Reflection.Emit at compile time

  I have built a dynamic assembly using very similar code to the sample in the TypeBuilder documentation. I am saving the dynamic assembly by calling AssemblyBuilder.Save. http://msdn2.microsoft.com/en-us/library/system.reflection.emit.typebuilder.aspx Can I use this dynamic assembly at compile time I have added a reference to it in my project, but I am unable to get any intelisense on it, and any use of the types or namespaces in the dynamic assembly produce compile errors. I have run peverify.exe against the saved assembly without error. Andrew Feldman wrote: Can I use this dynamic assembly at compile time I have added a reference to it in my project, but I am unable to get any intelisense on it, ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA - Microsoft lack of vision

  Its real sad that Microsoft, once again, shows this lack of vision for a games development tool: 1: Get visual: Don't force users to write such a lot of code to do just very little. It reminds the Charles Petzold's "Hello Window" hell of code days. 2: Provide visual tools: Let users choose the components, change their properties and write just the required code for the events. 3: Quick development means quick prototype and minimum learning curve. XNA has a lot of things to learn. Definetively it is NOT for students and hobbists. We will have to wait until someone encapsulates XNA framework into a group of visual components, that can be easily drag & dropped, inspected and tested very easily without having to learn lots of n ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to distribute a PC-based XNA game?

  I looked in the documentation about releasing a PC-specific game and all I got was XBox 360 distribution. I'm working on a PC game that has no need for the XBox 360, just to be clear. I'm curious in what runtime files I need I'm sure it requires .NET 2.0, DirectX 9.0c, but are there some extra dlls that I need Thanks in advanced. Note that beta runtimes in general are not redistributable. You should probably wait until the final XNA is released, and then include the redistributable that comes with them. For XInput and XACT, you can include those DLLs by using the redistributable installer from the DirectX SDK (make sure you get the same version as the XNA SDK is using!) If you assume that the user already h ...Show All

• Windows Forms Problem referencing items in a different project in solution

  I am creating an Outlook style application with email and contacts. I have my mainForm which is in its own project. The main form has a splitter. One on the left for the tree. And one on the right for a grid. In the Contacts project, my contacts tree is a user control, with a treeview added to it, and it has another user control with a grid added to it. In my main project, I add a reference to the contacts project. When my program starts up, it programatically adds my contactsTree control to the left side of the splitter, and my contactsGrid control to the right side of the splitter. And so on, for the email it adds the email controls etc. When a user chooses email, the email controls are set to Visible, and the rest of the controls are hi ...Show All

• SQL Server export to excel - formatting number output

  Hi all, Once again, SSIS is giving me a 'F.U.N.' time (ask for definition of the F.U.N. acronym another time ). I have a relatively simple task - create an excel spreadsheet with 3 columns of data - Id, Description and Sales. ID and Description are text, sales is int. So my SP aggregates and creates my resultset in my OLE DB Source in the Data Flow. It proceeds to the Excel destination, and that all seems fine. My issue is that the data is being written as text. Looking at the excel destination in Advanced editor: the Excel Destination Input, Input columns are formatted as I expected: DT_WSTR 8 for the ID, DT_WSTR 100 for the Description and DT_I4 for the Sales. Excel Destination Input, External columns refuse to fall in line, tho ...Show All

• SQL Server IS service won't start after installing SP1

  I have just installed SP1 and now the IS service will not start at all. I have tried using the LocalSystem account and an account with domain admin rights that I use to run all the other SQL Server services. Before the SP was applied the service was running fine. I have tried starting it from the command prompt, services and configuration manager but none of them work, I get the following error message: "The service did not respond to the start or control request in a timely fashion" This message is also in in the System Event Viewer, but there are no messages in the Application Event Viewer for the IS Service so I am now officially stumped (not to mention frustrated) Please help! ...Show All