DenversAllenB's Q&A profile

• Visual Basic Error in Creating a Serializer, is it my code?

  Here is a small code example that will consistently create a run time error in my VB .Net environment.  I am curious if others will have similar results. Imports System Imports System.Xml Imports System.Xml.Serialization Public Class Group     Public DataSet As Integer     Public DataSetSpecified As Integer End Class Public Class Run     Shared Sub Main()         Dim myMapping As XmlTypeMapping = (New SoapReflectionImporter().ImportTypeMapping(GetType(Group)))         Dim mySerializer As XmlSeri ...Show All

• SQL Server Licensing for a web server

  What kind of license do I need to run a single web site on a web server that needs SQL server to operate it's a public site that runs DotNetNuke but it's the only site on that box. *BUMP*.. Still need to know what kind of SQL license I need to run a web server with one website that requires a SQL server. ...Show All

• Visual Basic XML comments

  My group is attempting to standardize on XML commenting for all of our classes and methods. We like the "Insert comments" option in VS 2005 but would like to add an additional tag <history> to the comments section. I know that we could probably do this manually each time we add a new class, but I would like to be able to have this new section come up automatically when we insert the comment. Is there a way to modify the XML comment block that is produced when you use the "Insert comment" function so that the new <history> tag will be included in the text Hi, awperli, No ...Show All

• SQL Server Import a COM+ application That depends on SQLNCLI on 32 bit XP Fails.

  We have a 32 bit COM+ application that depends on SQLNCLI.DLL for BCP functionality. We are upgrading to the SQL Server Native client and moving away from ODBCBCP.dll. Anyone running 32 bit XP attempting to import the COM+ application gets the following message: The DLL could not be loaded. Check to make sure all required application runtime files and other dependent DLLs are available in the component DLL's directory or the system path. If I revert the DLL back to using ODBCBCP.dll the application will import and run fine. Here is the interesting part. If I import the application with the ODBCBCP.dll then rebuild the DLL so it links agains ...Show All

• SQL Server Automatic Activation - Message is null/Monitoring of Readers

  I have created a queue with automatic execution of a stored proc with the attribute Max_Queue_Readers = 5.  While processing data, I can select from the queue and see that messages are backed up in the queue.   I have two questions:    1) How do I monitor how many readers SQL is activating   I would like to at least confirm that SQL is indeed using 5 readers as messages back-up, and get some idea as to the overall resources being used.    2) I have noticed that after the RECEIVE TOP(1) command, occasionally the message is actually null!  Not sure if this is to be expected or not.  A ...Show All

• Visual Studio Express Editions Using Classes and Structs

  I am confused on using Classes and Structs. Can anyone shed light on what MS has changed about them example this code generates a ton of weird errors #include <windows.h> class CIGECORE { public :     LPSTR sAppTitle;     int iPosX;     int iPosY;     int iWidth;     int iHeight; };   That would be Gdi32.lib.  FWIW, I just googled GetStockObject, the first link is MSDN, and the MSDN page at the bottom tells you what to link to ( if you ever have these sort of troubles again ).  I tried a couple from ...Show All

• SQL Server rs drops first column in data set

  I started having this problem some time ago when trying to build a report using a stored procedure.  Existing reports work fine, it is only new reports that result in this error: The data set ‘WeeklyManagement’ contains a definition for the field ‘BrewNumber’. This field is missing from the returned result set from the data source. I get this error when I try to preview the report.  The missing field is always the first column in the dataset.  I have tried everything I can think of, including repeating the column, rewriting the sproc, rewriting the report, everything.  I cannot find any reason why this should be happen ...Show All

• Windows Forms Update database structure

  Hi, I am exploring Clickonce and Im wondering how I would update the database with it. How can I convert data from the old database to the new one AFAIK there is no "data merge" function with Clickonce, so you'll have to make a custom solution. If you're replacing an entire database then if it's SQL Express you can detach the old one and reattach the new one (make sure you use AttachDBFilename in the connectionstring). If it's an incremental update (e.g. some object changes and/or some new data), then you can script those changes and add the sql file as a resource. During application load examine ...Show All

• SQL Server "Creating a Mobile Application with SQL Server" Tutorial Problem

  I am attempting to go through the "Creating a Mobile Application with SQL Server" walkthrough found in the SQL Mobile Books Online help file. Towards the end of this document (under SQL Server Mobile Tasks), they show how to create a new subscription. Unfortunately, after step 10--when you are asked to click finish--I get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect. HRESULT 0x800040 ...Show All

• SQL Server metadata driven SSIS package--table variable

  Is there anyone know if a simple SSIS package (moving data from source table to target table) or task can be called repeatedly using a variable that obtains value once a time from a metadata table containing only table names. Basically, I would like to pass in a table variable to the SSIS package or task to start the ETL for different tables. Thanks a lot! Oliver Patrick, Can you give some rough ideas as what you are using in terms of programming languages, scripts or SSIS tasks to create metadata driven SSIS packages. Many thanks! Oliver ...Show All

• SQL Server WCF Transport Channel for Service Broker

  I saw a posting or read a blog somewhere that mentioned custom WCF transport channels where created for interacting with ServiceBroker. Has anyone read or heard something similar If so, where can I get them Thanks. Phil There was a prototype of a WCF channel done a while back, but nothing production worthy has been built and shipped to-date. What is your specific interest here I'm interested to know what you would value most in this realm. For example, are you seeking a rich object model that exposes the Service Broker semantic; including features not found in other queuing systems Emphasis: ...Show All

• SQL Server sp_indexes_rowset

  I have this problem with a program connected to SQL 2000 Server Enterprise via ADO . The problem is that the program runs faster on smaller servers than on larger enterprise servers. One would expect that larger and faster server should have faster performance. However, the software is taking twice as long on the larger server. Some symptoms are: a.     The larger server has several databases and a number of other software programs connected to these databases. There is plenty of CPU, memory, hard disk and network bandwidth. b.     Occasionally, the program experience connection timeouts a ...Show All

• SQL Server Multiple parameters

  I want to use a dropdown parameter to actually populate another dropdown parameter As in department dropdown parameter populates the division dropdown parameter. Is it possible to do this in SQL Reporting Services 2000 Please check this link on MSDN (scroll down to the section about "cascading parameters"): http://msdn2.microsoft.com/en-us/library/ms155917.aspx Although that site also describes RS 2005 features, cascading parameters is also available for RS 2000. -- Robert ...Show All

• Visual Basic What project type?

  I want to create an application which can be run from the command line and so be run as a scheduled task, but also can be run as normal GUI app. I have done this before in VB6, but a long time ago. I am now using VS2k5 and I can't work out how to do it. I have created a console application and added forms, but they do not display properly. I have created a windows form project, but then I can only have the form as the startup object. I guess there is something missing from the console application which is why the forms don't work. Does anybody know what I am doing wrong thanks Ryan What exactly do you mean ...Show All

• Visual Studio URGENT: Error with Microsoft.Reporting.WebForms.LocalReport.InternalRender

  Brian We are experiencing some internal errors with the reporting services engine in the local mode. It seems to be working fine on all our dev boxes but seems to blow up in our production sites. Here are some messages found in the System Event log. Let us know if something pops up as you see the message. Basically, the code does the report render is given below. Call me stupid, i must have put a try/catch around the render method as it is the one that is blowing up Appreciate your prompt response. Thanks private byte [] GetImage() { Warning [] warnings; string [] streamids; string mimeType; string ...Show All