PankajGautam's Q&A profile

• SQL Server Lesson 1 - Problems with data formats

  Hello, I'm going through the tutorial lessons and found a major issue in Lesson 1. As I tried to transform the data from the flat file in debugging mode, the sample didn't work correctly. No related data to the dates and times from the flat file could be found in the dimension table dimTime. I discovered that this was due to the different time format that was set in control panel (german time format). After changing the Windows time format according to the flat file the sample worked. But then I found another flaw: The currency rate wasn't transformed correctly. This was due to the different delimiter ...Show All

• SQL Server Failed to generate a user instance of SQL Server

  Hi, I have visual basic team 2005 beta that come with sql server express, and i am trying to connect to a database on my local computer. And i get this message "Failed to generate a user instance of SQL Server due to a failure instarting the process for the user instance. The connection will be closed". If u ever heard of the Northwind database it is the one i am trying to use I don't know much about how to configure server, but i am running this on Window XP Pro and i am using a a user account with administrator privilages. I even tried to create a new database and i get the same message.   ...Show All

• Visual C++ Share Projects in one solution

  Dear all, I create two projects, say A and B, in one solution in VC.net 2003. They are basically 2 executable applications, A.exe and B.exe.   In project A, it uses some classes created in project B. I include the header B.h in A.h, and add Additional Include Directories to which B.h resides.   Compile is OK but when linking it looks like the LINKER does not know where to link obj in B project and gives the error messages like this: ATest error LNK2019: unresolved external symbol "public: __thiscall HelloWorld::~HelloWorld(void)" ( 1HelloWorld@@QAE@XZ ) referenced in function _main I do not want to c ...Show All

• Smart Device Development How to use the eVC Upgrade Wizard ?

  Is there any information regarding how to use the "eMbedded Visual C++ Upgrade Wizard for Visual Studio 2005 Beta 2" http://www.microsoft.com/downloads/details.aspx FamilyID=77ffddbf-b215-4d96-94dd-6ae9b7bb53d2&displaylang=en I have installed it, but then what should I do I cannot see this wizard in Visual Studio 2005.  How do I start it Any pointer would be welcome! In order for the eVC upgrade wizard to add your platform to the VS2005 upgraded project, your platform must be installed and available to the VC project system. There were a couple of bugs in the Beta2 upgrade wizard where it would ...Show All

• Visual Studio Team System I am running out of time with the registration to get the activation key !!

  Nothing I do allows me to actually register and get the activation key. Big game register Now and you simply go to msn passport profile and then they say call 877 256 2495 but when you call that number you get nothing they tell goto the web and then hang up on you immediately before you can do or say anything. I am not really sure what to do at this point I have been posting bug reports for 11 days now and not gotten any feedback at all on anything someone please call me at 604 896 1595 or email me at mdyrnaes@hotmail.com. Help Help Help What was done to help you. I am having the same promblem. Can you help me Please Post Message ...Show All

• Windows Forms What is the event on a listbox when adding/removing items ?

  Hi everyone, In my program, I have two different way to add objects in my listbox. One being by doing mylistbox.Items.Add(Myitem). and the other one by dataSource. As found the event for the onDataSourceChanged but it doesn't triger when adding or removing from the items collection. His there any events I could use thanks.   abuck wrote: Hi everyone, In my program, I have two different way to add objects in my listbox. One being by doing mylistbox.Items.Add(Myitem). and the other one by dataSource. As found the event for the onDataSourceChanged but it doesn't triger when adding or ...Show All

• Visual Basic Querying Active Directory to check if a Username exists

  Hi Everyone, We are doing a lot of work on our Storage server at the moment, and one thing is tidying up users folders. What I am trying to do is to pick up the name of a users folder (from a text file) and query AD to see if that User exists.  In theory !! all folder names are named after the Username. Here is the connection code that I have so far, I wonder if someone could help me, or if I am totally missing the plot and on the wrong lines, steer me in the right direction .................... Dim currentuser As String Dim currentuserpassword As String currentuser = InputBox("Please enter your Username") currentuserpas ...Show All

• .NET Development c#.net XML Request via http and storing results in SQL

  Hi I hope someone can point me in the right direction. What I want to do is build an application in c#.net that will fire off request to a web site that returns the results as XML. The web site that returns the results is already build. I need to know how to go about building an app that sends the request. Then stores the results in SQL. I currently do this with an application that we have purchased, but i'm sure there must be a way to build a simple app that does it. Any advice greatly appreciated. Thanks For the first part of your task you may use the WebRequest class. Take a look at code s ...Show All

• .NET Development Get ValueMembers from a Databound Multiselect ListBox

  Can any one help me I m using the binding the DataSet with ListBox with ValueMember Now all I need is to get the ValueMembers for Multi selected items in the list box. How can i get the value of ValueMember for Each Selected Item If anyone from the .NET development team is seeing this, I would suggest having a SelectedValues property that mirrors the SelectedItems property using the ValueMember. ...Show All

• Visual Basic VB6 - VB.Net 2003 : Forms

  Hello, I have a small vb6 program that I am converting to vb .net 2003 to help me learn .net. I have a function that sets menu options for my forms. In vb6 it is basically as follows: Sub SetActiveMenu(MnuOption As Byte, MnuForm As Form) If (MnuOption = mNew) Then MnuForm.mnuEdit.Enabled = False Else MnuForm.mnuNew.Enabled = False End If End sub I pass a menu option and the name of my form and then the menu items edit or new are used. In vb .net the code is as follows: Sub SetActiveMenu( ByRef MnuOption As Byte , ByRef MnuForm As System.Windows.Forms.Form) If (MnuO ...Show All

• SQL Server MSmerge_genhistory error-515

  Can't insert value NULL into column nicknames. This error generated when I try start sync. SQL Profiler is not helping w/ locating specific error. I tried to allow NULLS in nickname column, for this table, but this table gets dropped and recreated each time. Pls. advise on where to make correction. thx..bt Can you tell us what version of sql server you're using, including Service Pack # (if any) ...Show All

• Visual C# i need help with basic things

  Im new to visual C, but i know the fundimentals of prgramming, and i cant figure out how to make a form pop up or how to change the start screen to another form, any help It does work (tried it before I posted, just in case :) ).  He didnt actually specify he wanted any result from the new form or anything, so I just did a basic example :) for a splash screen (which he sort of references in his first post) he wouldn't need a Dialog (in fact that would be rather pointless wouldnt it :) ). ...Show All

• Visual Basic Error Type 'MarshalAs' is not defined

  I recently converted a project from VB2003 to VB2005.  I am getting this error and I can't figure out why... Type 'MarshalAs' is not defined Here is an example of the code that is causing the error: <StructLayout(LayoutKind.Sequential)> Friend Structure VersionInfoDef    Dim SizeofVersionInfo As Byte    Dim BootVersion As VersionDef    Dim OSVersion As VersionDef    Dim NumOSExtensions As Byte    <MarshalAs(UnmanagedType.ByValArray, SizeConst:=40)> Dim OSExt() As Byte        Public Sub I ...Show All

• Visual Basic Microsoft.Office.Interop.Access - Open Application Non-Visible / Reference Report/Form

  Hi, I have created an Access object (Microsoft Access 11.0 Object Library) and connected to my db, but want to open it without the Dialog Box where you have to select Open - In fact, I don't want to see Access at all - just open it in the background. I then want to reference my Reports and Forms and then reference the controls on them and then reference the properties for each of those controls. I have been trying to do this for a while now and read a number of articles, but still no luck. Would like to do all of this using VB.Net 2.0 - see my code below with what I have so far. Dim oAccess As Access.ApplicationClass ...Show All

• Visual Studio Custom coloring using MPF

  The documentation mentions the following for creating custom colorable items: - Set RequestStockColors to 0 or leave it untouched (Left it untouched) - Define your own ColorableItems in the constructor of LanguageService - Override GetItemCount and GetColorableItem methods of LanguageService I followed the above steps and still the custom colorable items do not show up in Fonts and Colors property page on Options dialog box. I made sure that the names of the colorable items are different from the existing ones. I am using October RTM version of SDK. What else needs to be done Thanks in advance.   ...Show All