Robbertos's Q&A profile

• SQL Server Query Optimizer Oddity - Very worrisome

  Hello Everyone, I have two questions about the query engine. One is easy, one not so much. First, I am looking into how estimated query costs are calculated. I know the BOL answer of "estimated seconds to complete the query", but I am looking for more detail on how that is calculated. Can anyone throw me a link, etc Secondly: I work for a company testing SQL 2005 prior to announcing support as a backend for our calculation. In ...Show All

• SQL Server Getting some more information of email-delivery errors

  Hi, I am wondering if there is any way to get some more information if there have been errors during a data-driven subscription with the email-extension for delivery. I want to send about 20Mails for one subscription, that works fine using a data-driven subscription, but if there is an error I only get "... 1Error" in the status-column, how could I get some more information Are there any logfiles, or is there any way to setup ...Show All

• Visual Basic The type initializer threw an exception. - For no reason

  Hi, Im developing a timetable like program which was all working fine until i installed some security updates for windows xp. This might be p urely coincidental but i keep getting the exception, pasted below, when i try to call ModPublic.GetSett(). I even removed all code from inside the public modpublic.getSett() sub but i still get this error on each debug/F5 run. System.TypeInitializationException was unhandled   Message="The ...Show All

• Visual C# interacting sql server 2000 and c# .net

  hi, i have a number of database tables created through sql server 2000 and i have created an application in c# using visual .net 2003. could anyone teach me how to interact my c# application and sql server 2000 so that i can make a query using my c# application. thanks Hi, You'll need to work on System.Data and System.Data.SqlClient namespaces respectively. http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/fr ...Show All

• Visual C# Declaring Arrays

  Hello, I have a question about declaring arrays. Here is my array I’ve declared which contains 3 string. string [] strName = new string [3]; I am trying to pass this string array to a DLL that is created in Delphi and the declaration is looks like this. strName : Array [0..3] of String[128]; As you can see in Delphi, they can declare a string array that has ...Show All

• Visual Studio Express Editions Fire up methods between User controls

  Halo, I have done User Controls in my application, the way to do them I found in Template in Movie collection starter Kit. When run some method in First control(insert user), I want to run some method in Second control to update the Listbox(of users). The instance of Second control should stay only one if possible. class Admin { //is driving the control panels to hide or show } class AddUser { // User Control Panel with some methods and me ...Show All

• Visual Studio How i can sort runtime Crystal Report 8 reoprts using Vb

  hi How i can sort crystal reports 8 using vb6 runtime.User want to select the sort field from the VB application,then reports should sort in that order Please give me some help waiting reply shiyas Hello Shiyas, Here is a search done on the Business Objects kbase: http://support.businessobjects.com/search/results.asp summary=1&ct=livewww-all&output=xml_no_dtd&filter=0&radioGroup=kbase_search& ...Show All

• Visual Studio Team System TFS and Domain Controller

  Hello, I read that Domain Controller on beta 3 and RC are no longer supported. If I want to install TFS on a Domain Controller, It seems I have to use two 2003 Server. But I don't understand one  which server I have to install the DC, the prerequisites and TFS, (For Single-Server Deployment) Does it mean I have :one server for the DC and the other one for IIS, SQL server ...Show All

• Visual C# Date

  How do I get today's date and put in an object/variable Thanks Just to expand Webmonsta's post above: To put it it a variable, you would do the following: using System; namespace Examples {    public class DatetimeExampleClass    {       [STAThread]       static void Main( string []args)       { &nbs ...Show All

• Windows Forms Special Characters

  Where can I find a composite list of special characters that I can use when printing out info on a windows form  For instance, if I wanted to tab over, what would I use  What about a carriage return/single-line break >but ...Show All

• Visual C++ Graphs in VC++

  I'm trying to draw a Graph within a Dialog Box and Without using an ActiveX. I have tried to use a CStatic control or Custom control unsuccessfully. I have tried to use a CDC object and attached the pointer on CWnd from my control but i don't manage to make it display anything. It is written in MSDN that i Should use OnDraw() to recover the right DC pointer but no Control release this event. Am i trying to do something impossible I guess n ...Show All

• Visual Studio Express Editions Data Samples 101

  During installation of this sample I get an error message saying the product.cab is corrupt. Is there a work around Thanks, Richard Either Microsoft have posted a corrupt file or it has become corrupted either during or after download. Download it again. If it still doesn't work then it may be that the original is corrupt, although I'd say that that is very unlikely. ...Show All

• SQL Server Databound image in report header

  After finding out that SSRS doesn't directly support databound items in the header or footer, I found the workaround from Microsoft yesterday at http://msdn2.microsoft.com/en-us/library/ms159677.aspx . The problem is that their solution only works for the first page of the report, so it's basically useless! Because this is an image, it also means the workaround of using a parameter doesn't work, either. Does anybody have any advice Is there a ...Show All

• Software Development for Windows Vista Frame Grabber

  Hi I intend to develop simple frame grabber (avi File / usb camera). I want to do it in C# .NET which API I should use and where should I download it. Thanks Miki u mean capturing from camera to avi Don't think directx is ment for that. Think u will need some other kind of sdk ... maybe search msdn for media ... maybe the media player sdk can help u. ...Show All

• SQL Server Win 2003 x64 - SSIS error Importing xls and access data

  I am having a problem importing data from xls and access into my SQL2005 DB using SSIS . Would appreciate any help in getting this resolved.   Environment: Xeon 64 bit processor machine/Win 2003 64 bit (x64)/SQL 2005 64 bit   Some of the resources that I have dug up so far have pointed to Jet Engine SP8 and WOW64.   A search on the box shows this: C:\Windows\SysWOW64\Msjet40.dll – File version is 4. ...Show All