BubbaHasty's Q&A profile

• SQL Server SQL Server 2005 Express SP2

  Can anyone tell me when SP2 of SQL Express will be available Cheers Its not in the beta yet, so it will take some time. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual C++ C++/CLI /CLR Managed Support in Native Library

  Hi, I have a C++ project, a .dll project in Visual Studio 2005, which uses all native C++. I was able to compile the project with the /clr option (just /clr for common language runtime support). I am able to add the a reference to the dll with another C++ project, which is also compiled with the /clr option, and the entire application runs fine. The problem comes when I try adding the .dll project reference to a test C# project and add a "using MyCPPNamespace" to my C# class. I don't see the new C++ project namespace anywhere within my intellisense in the C Sharp project and I can't just add it as a using. I thought compiling my native C++ project with the /clr option allowed us to add references to these projects in other manage ...Show All

• SQL Server DB2OLEDB for SQL Server 2005 Standard Edition

  The Microsoft OLEDB provider for DB2 (DB2OLEDB) is available in the "Feature Pack for SQL Server 2005 – April 2006." The installation routine, however, will only install on the enterprise edition or the developer edition. Is the DB2OLEDB provider not available for SQL Server 2005 standard edition If you want a Microsoft OLEDB provider for DB2 you have to install client tools from Host Integration Server. You can choose it under custom install. i ...Show All

• SQL Server Migrate 2000 -> 2005

  I've got the responsibility over a small SQL server with 8 Database and approx. 100GByte data online. Most database are used and need to be available 24*7*366. Also a number of local data transformation packages are defined and used on a regular basis. Furthermore a number of third party applications rely on this database. My question if it is worth the effort to migrate this to 2005 I know there are all kinds of nice migration wizards but do they really work What if one of the 3rd party apps don't like 2005 Love to hear both good and bad experiences migrating -> 2005 . Thanks Chen, did not know 2000 and 2005 can run side by side but this will greatly increase the possibility of a migration. I d ...Show All

• .NET Development .NET Framwork 3.0

  After I install .NET Framework 3.0 update from MS site, I am unable to open my McAfee security center. I can’t even uninstall it from Control Panel (nothing happens when click change/remove button). Anyone knows why TX After a series of trials and errors, it is NOT the .NET Framework 3.0 update that causes the problem, it is the Root Certificate update for IE 7 that disables the McAfee Security Center and blocks internet access. Don’t download the Root Certificate update for now. ...Show All

• Software Development for Windows Vista Storing Data In SetState Activity

  I have a requirement where: When I transition to next State I have to write some data (A string column) to my database Table. I tried to inherit from the class SetStateActivity But it is a sealed class . public sealed class SetStateActivity : Activity Is there any other ways/code example like creating a custom SetState Activity Thanks in advance. sam-pan, The StateFinalization Activity can intercept the state machine transitions out of a state. It's a sequence activity with a child activities inside. That is a place to put your custom code. If you want to build your SetState activity, the following is an example of the Execute method for quick test purpos ...Show All

• Visual Studio 2008 (Pre-release) PixelFormat: why is the difference?

  Hi Everone, I have a question about the bitmap functions in GDI+ and WPF. I have a jpg file called "photo.jpg" in my E drive. This first line use WPF System.Windows.Media.Imaging BitmapImage bmpimg = new BitmapImage ( new Uri ( "E:\\photo.jpg" )); the bmpimg loaded has a pixelformat of "Bgr32". If you copy the bitmap data to a byte[], you'll see it's in "BGRABGRA..." format, each pixel consists of 4 bytes. This next line uses GDI+ System.Drawing namespace, loading the same jpg file System.Drawing. Bitmap bmp2 = new System.Drawing. Bitmap ( "E:\\photo.jpg" ); the bmp2 loaded has the pixelformat of "Format24bppRgb". If you copy the bitmap data to a by ...Show All

• Smart Device Development Unauthorized access exception

  Hi, I have a WM5 application that runs fine when debugging through VS2005 but throws an unauthorized exception once I have deployed to the PDA via a cab file installation. The application uses a third party dll that I package across in the Cab file. Am I missing a trick here - Do I need to register this dll any ideas thks Turns out that it was the config.xml file that was the prob, as i built the cab from VSS the file was packaged as read-only, hence the unauthorized exception. ...Show All

• SQL Server Analysis Services 2000 SP3 or SP3A - how to identify ?

  Hi, Is there a way to identify whether I have Analysis Services 2000 SP3 or SP3A Thank you very much. Code wise, you can read the registry on the server's LOCAL_MACHINE \ Software\Microsoft\OLAP Server\CurrentVersion and look at the VersionNum and CSDVersionNumber ...Show All

• Software Development for Windows Vista socket descriptor to a write() function

  Hi all, I am developing a windows application which is going to communicate with a unix application which is using read() instead of recv() funtion to receive data on the socket. Other problem is that i am not suppost to chagne the server side. Can any one tell me how to replace read() with recv() write() with send() It doesn't really matter if the server side is using read or recv so you don't need to change it anyway. As for using read instead of recv in the windows application it's quite easy: In UNIX you have something like: int socket; int bytes_read; char buffer[1024]; ... bytes_read = read(socket, buffer, sizeof(buffer)); and in Windows you have something almost similar: SOCKET socket; i ...Show All

• Internet Explorer Development Tab close or window close?

  When I close  a web, how can I do to juage it was closed by a tab or a window     Well how the English version of IE7 operates is >>  when you go to a website and and click on some thing to open it -- some times it opens in a new tab and some times it opens in a new window.  If it opens in new tab -- you could end up  having several tabs open and if you go to close out the web by clicking on the big red X  in the very top right of the window - it will ask you if you want to close out all tabs --- if you don't want to close out the web site, but just the present one you are looking at -- click the "no" button and then go look at the tab bar to the r ...Show All

• Visual C++ can no longer drag arrow to change next statement to execute in vs05

  [Moved this discussion from " Visual Studio Debugger" due to no responses there.] I recently migrated from VS03 to VS05 (using VC++). Using the debugger to break into my code, I used to be able to drag the little yellow arrow to change the next executed statement. After switching to VS05 that functionality seems to be broken. Specifically: I set a breakpoint. In the debugger I can step through the code just fine (with F10). If I hover my cursor over the yellow arrow, the tool tip reads: "This is the next statement that will be executed. To change which statement is executed next, drag the arrow. This may have unintended consequences." However when I try to click and drag the arrow, I am unable to move it ...Show All

• Visual Basic ADO Recordset Filter Query

  Hello, I have a recordset that will have data looking something like the following C1 C2 C3 C4 C5 C6 AAA BBB CCC DDD EEE FFF AAA BBB AAA DDD EEE FFF AAA BBB DDD DDD EEE FFF I want to consolidate the ADO Recordset on C1, C4, C5, C6 and discard C2/C3 . If this was pure SQL I would write a query something like: Select Distinct C1, C4, C5, C6 ... Is there a way to do this to the ADO Recordset maybe using the Filter() method The recordset I am working with is quite large (10,000+ records) so I wanted some optimized way of doing this. Thanks. Dwight Hi Dwight, I am assuming in this answer that C1, C2, etc are columns in the database. I would suggest using ADO.Net as opposed ...Show All

• SQL Server Newbie Merge replication question

  Hi! I'm setting up a merge replication for sql ce. Ten guys with windows mobile 5 pocket pc works as service technicians and need to synchronize data in the field. The backend database is huge and I just want each person to have their own data on the pda and synchronized, they have unique userid's in the database. Is it possible to filter data for each person or do all have to have all data that's in the backend database /Magnus Could I use a "translator" table to translate suser_name()'s to applications userid's Then in the filter query against this table to identify the user One solution could be to have one Publication for each employee Yes it would become messy to administer. But my problem can't be unique. Ho ...Show All

• SQL Server Variable Locking

  I have the following scenario: 1) A package PkgA calls another package PkgB through vbscript task named TaskVB. 2) I have enabled the OnError eventhandler at package level in both packages. And I used a vbscript task to process the error. 3) Both packages have also a local level package user variable called DWErrorMessage which is used in write mode, in the OnError event control flow. 4) I force a failure result on TaskVB so as to test the onerror eventhandler control flow. 5) I received the known error "variable deadlock" on system variables and on user variables also. So, I proceed to unlock all the variables in TaskVB just before returning the dst.results.failure and inmediately after executing PkgB, using ...Show All