MPCProgrammer's Q&A profile

• Microsoft ISV Community Center Forums VBA Compatibility and creating EXEs

  I have an excel project (2002, VB version 5.0) that has lots of sheets, forms and code.  I just downloaded Visual Basic Express and discovered that it couldn't import my VBA exported forms.  If i wanted to create an EXE from this application down the road, does a migration path exist, or would i have to rewrite everything from scratch Hi, I think this article has the information you want: ...Show All

• .NET Development HOU INSERT DATA ACCESS como inserto datos en access

  Me sale debe usar una consulta actualizable, consulto lo mas bien, pero no puedo insertar. The message is "must use consults updateable" Dim cn As OdbcConnection cn = New OdbcConnection("Driver={Microsoft Access Driver (*.mdb)};" & _ "DBQ=c:\1\bd1.mdb;UID=;PWD=") cn.Open() Dim xdataset As New DataSet Dim xcomando As New Odbc.OdbcCommand vsp="insert into tabla1(nombre)value ...Show All

• SQL Server Need to create <Query> statement programmatically

  I am creating a web application that uses a using a web service to get data for my reports. Since the webservice only accepts 1 parameter called "sql" (the sql select statement), I am using the report's query string to get the data. Here is the data source and dataset info I am using: DataSource Name: WebService Type: XML Connection string: http://localhost/myWeb/myWebService.asmx Credentials: No credentials DataSet ...Show All

• SQL Server SQL Server Stored Procedure Transaction Problem

  Hi, I got a problem when executing a stored procedure in SQL Server 2000 Query Analyzer. The first time I run it without using 'Begin Transaction' & 'Rollback Transaction', the stored procedure works fine. The second time when I use 'Begin Transaction' & 'Rollback Transaction' to test it, the procedure keeps running but halts at the end of the cursor and never jump out from it.  However, no error return by the query analyz ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. NullReferenceException

  I keep getting NullReferenceException when I create a spirte. It only happens when I close the application, but strangely not the first time I run the application, only after that. I must not be disposing of the texture properly. Can anyone help Here is some of my code:         private void OnDeviceLost(object sender, EventArgs e)         {     & ...Show All

• Windows Forms Eject CD

  Hi, I am making an application that allows user to eject CD through pressing some button. How can I do this  Do I have to call some API  which API would that be  any alternative ways  any pre-built DLL from some website  Thanks, ...Show All

• SQL Server How do I load the Sample SSIS Components?

  Especially interested in the CodePageConvert. Installing the .msi just creates a project folder in my Visual Studio directory. I'm unclear how to get from this point to being able to choose this component from my Toolbox items in SSIS. There was a readme file that talked about gacutil.exe and .snk files that was a above my head. Can anyone dumb it down for me One doesn't need full VS to build the projects ...Show All

• Software Development for Windows Vista How do you handle Persistence with WWF Beta 2.2?

  Tom, I am unable to raise events in WWF Beta 2.2 (unlike WWF Beta 2.0). When I set UnloadOnIdle = " false " (from "true"), I am able to raise the first event without an error, but am unable to get the XOML only State workflow assembly reference via persistence. The problem is that I am unable to persist a State XOML workflow when using WWF Beta 2.2. Everything worked fine with WWF Beta 2.0 State workflows (non XOML on ...Show All

• Visual Studio Team System TF output not conducive to efficient use from scripting

  Our builds are heavily scripted.  TF seems to output extraneous information which causes us to have to do unnecessary string parsing.  For instance, in over SCM tools usually there is a very easy way to get just the items in a directory that are under version control.  But in TFVC, if the best I can do is this: tf dir C:\proj\somedir but then I get this output to deal with: -------------- $/Proj/somedir foo.cs bar.cs baz.cs 3 item ...Show All

• Visual Basic Visual Basic Visual Studio 2005 Debug.Write doesn't work

  I recently purchased Visual Studio 2005, and am trying to learn Visual Basic .net via an on-line class. Most of the less on s are very simple short programs to write messages to the Debug Output Window. For example: Public Class Form1 Private Sub Form1_MouseMove( ByVal sender As Object , ByVal e _ As System.Windows.Forms.MouseEventArgs) Debug.WriteLine(e.X & "," & e.Y & " " ) E ...Show All

• Visual Studio Team System System Health Check stops install because of processor

  Any way around this Trying to build a VPC for education purposes. Laptop is 1.86GHZ with 2GB of memory. Giving 1+GB of memory to the VPC, but cant get past System Health Check. Is there any command line switch to turn this test off or any other way to get around this I tried setup.exe /no_bsln_check and the install wasnt bypassed Yup, you got it. We do generate the report dynamically in order to give you the big ...Show All

• Visual C++ ComboBox most basic question

  I gues this may be stupid, but I really couldn't find answer to this in MSDN: In ComboBox " OnCbnSelchange" handler I need to check what item is selected. Can I check for item number or must I only check item string (I do this in MFC) This is ceirtanly not working: There is a method for CComboBox which is CComboBox::GetCurSel(). It returns the currently selected item from the list, or the value CB_ERR if nothing is se ...Show All

• SQL Server How to make a datawarehouse?

  Hello, as far as I know for making cubes I need forst a Datawarehouse or I can even make a cube based on an OLTP database, but I think this option is not recommended because its the transaction database. The Analisys Services Projects let me create cubes very easy based on  a datawarehouse or a relational database. The question is How do I make the datawarehouse based on the relational database How does the datawarehouse refreshed from the ...Show All

• SQL Server Unable to execute DTSLookup

  I have a pretty simple lookup query that returns an error that I can't figure out. It states that the query has too few parameters (2), but only 1 is required. I've investigated every component and everything seems correct. I have another lookup just like this and it works fine. Here is a simple description: I have an Access table with values that have to be loaded into a SQL Server table. I defined a Row Transform task with an ActiveX script ...Show All

• Visual Studio 2008 (Pre-release) An interesting post about some flaws in DLinq...

  Just for your bug-fixing/refactoring attention. http://www.matshelander.com/Weblog/DisplayLogEntry.aspx LogEntryID=87 , after an author of NPersist ...Show All