arrayhunter's Q&A profile

• SQL Server RS 2005 run on SQL Server 2000 Database?

  Our product currently works with Cystal Reports but we decided to enhance it so it works with another reporting platform (MS Reporting Services).   We are in the beginning stages of developement and trying to decide which version of RS (2000 or 2005 ) to build the reports and integrate our web UI with.  Most of our clients are using SQL Server 2000 for their database platform and we don't anticpate them upgrading to 2005 in the near future.    If we built everything using RS 2005 could our clients deploy RS 2005 Report Server on a SQL 2000 Database    Is the licenses ...Show All

• SQL Server What's the easiest way to copy tables from one 2005 DB to another 2005 DB?

  I've tried creating a simple SSIS package but I get the error: [Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Cannot apply value null to property Login: Value cannot be null..". THis is a known bug and while we wait for SP1 to fix this error, is there another way to simply copy tables (with indexes and without having the identity column renumbered) Any help is appreciated! Scrip the source table and use this script to create the destination table. Then use the import-export ssis wizard and allow identity insert. (in the solution explorer, right-c ...Show All

• Visual Studio Express Editions ObjectARX and DLL Project

  I am trying to build some AutoCAD ARX extension suing VS 2005 Express but when following most of the tutorials I find I am told to make a DLL project.  This option is missing from VS 2005 Expreess.  Is this because of the Express "Streamlined User Experience" or is it something to do with the jump from VS 2003 to 2005. Does anybody know how It is best to go about building ARX projects Hi, Are you trying to use Managed Extensions for ObjectARX If so, just create a ClassLibrary and add the needed dlls for reference. But if your planning to use the Native ObjectARX, sorry to say but its not supporte ...Show All

• Visual C# C# define question?

  I want to be able to do something like this #if WINDOWS #define CONNECTIONTYPE OdbcConnection #else #define CONNECTIONTYPE MySqlConnection #endif Then later I could have a function such as CONNECTIONTYPE connection = new CONNECTIONTYPE ( "blahblah" ); But I have read that in C# you cannot define things as variables... Does anyone know of any other way to do what I am trying to accomplish I think this is where you should use the Factory Pattern. Do this (let's consider Connection to be a base interface/class of both OdbcConnection and MySqlConnection: Connection connection = ConnectionFactory.Cr ...Show All

• Windows Search Technologies Indexing Business Contact Manager

  Will WDS (any version) index entries in the Outlook Business Contact Manager I'm guessing not, since I searched for a name and couldn't find it using WDS but found it immediately using Outlook's built in search feature. If WDS doesn't have that functionality, any plans on adding it in the future Hi R. Nargang, WDS does index entries in Outlook Contacts. Here are some things to try: Make sure that Outlook is open and running when you are indexing If your contacts are stored in a .PST file, make sure that the file is actively loaded in Outlook Make sure the contacts that you would like WDS t ...Show All

• SQL Server Where is the Northwind SQL scripts for SQL server 2005

  I am looking for the northwind install script in my SQL server 2005 directory and cannot find it. The introduction to VB 2005 uses it for an example and I would like to walk thru it. Does anyone have the sql If so could you send it to me. I am going to see if I can get it off a 2000 install. Thanks. Hello, Northwind does not ship with SQL Server 2005.  It is available from the Microsoft download site: http://www.microsoft.com/downloads/details.aspx FamilyID=06616212-0356-46a0-8da2-eebc53a68034&DisplayLang=en See the topic Downloading Northwind and pubs Sample Databases in SQL Server 2005 Books Onli ...Show All

• Visual Studio -Y<username>,<password> Doesn't work

  I am using ss.exe from the command line and I would like to be forced to enter the username and the password. however even if i hard code in -Y<username>,<password> it still acts as if the option was just -Y<username> meaning that it disreguards the password and still prompts for it. I would like to be able to prompt at the beginning of my script for a password and then put that variable in the <password> part myself but at this point I can't even hard code the name and password to get it to work. any ideas thanks. Singee, You should be able to set the SSUSER and SSPWD variables ...Show All

• Visual C# Getting rid of excel.exe from memory

  I use excel interop to load in data from excel file. After the loading is done, I call myExcelInstance.Quit(). But in task manager I can still see an EXCEL.EXE for each file I opened, eating up a fair bit of memory. These instances don't go away until I close my application. What am I doing wrong ~S You can try to decrements the reference count of the runtime callable wrapper with the Marshal.ReleaseComObject method. Marshal.ReleaseComObject( myExcellInstance ); myExcellInstance = null ; You should release all your COM object like the _Workbook and/or _Worksheet objects. ...Show All

• Windows Forms I need a ReadOnly CheckBox and ReadOnly RadioButton

  Does anyone know where I can find a ReadOnly CheckBox control and a ReadOnly RadioButton control    Thanks! This seems to work for me: Put the control you want to make readonly in a panel.  Then shut off all mouse and keyboard input to the panel by p/invoking EnableWindow.   [DllImport("user32")] static extern bool EnableWindow(IntPtr hWnd, boo ...Show All

• Windows Forms How do I create a GridView/edit screen?

  Newbie question. I have DataGridView that has a list of records. I want to double click on one row and bring up a NEW form with a detailed edit form for that record. 1) How assign a KEY to the DataGridView 2) How to I access the key and pass it do the new form 3) How do I create all this on a row double click (not cell double click) Thanks. you can do it by the following I have answered based on your question number 1. Key = DataGridView.CurrentRow.Cells(columnindex/name).value 2.You can declare the Key as public in your Form1 and call it in Form2 in Form1 Public Key as string/anydatatype in Form2 ...Show All

• Visual Studio Team System Unshelving error

  When I try to unshelve one of my shelvesets I get: "Error - No changes unshelved."  Any ideas what might cause this First, if I wanted to update my older unshelved file set with what is currently checked into the repository without having to check the files in, how do I do that from VS >> Unshelve your changes, do a get (this will cause a merge), then reshelve your changes. From the pending checkins tool window (which is my current homebase for VCS) I didn't see a way to do that.  I had to go to source control explorer to undo pending changes.  It might be nice to be able to do that fr ...Show All

• Windows Forms DataGridViewComboBoxColumn Bug?

  I have a DataGridViewComboBoxColumn bound to a collection. I have the DisplayStyle set to Nothing. When the user clicks into the cell, the drop-down appears, and it appears as if the first item is selected. (The TextBox portion of the drop-down is filled-in with the first entry and the first entry is highlighted). If that is the item the user wanted then they just move on to the next cell without "picking" anything. When the user moves into the next cell the drop-down goes back to looking empty. The visual cues are VERY confusing. It appears to the user that the item is picked, and yet its not. Is there any way to stop the Data ...Show All

• Software Development for Windows Vista Workflow Persistence

  I have created a workflow.I am able to persist it. Thanks to help from the forum. But How will I load the persisted workflow, after shutting down the application and restarting it. I could see many records in the InstanceState table. Which entry will be loaded when I call the load method. How to ensure that I load the instance state of a specific instance Please help. Regards You have to keep or get the InstanceId. When you call WorkflowRuntime.GetWorkflow passing in a specific ID - the WorkflowRuntime searches its live list - and if a live instance isn't found - it goes to the PersistenceService ...Show All

• Windows Forms How to get the object by a string object name?

  hi, guys, I think I did this before, but forgot how. For example, we know there is a checkbox named "checkbox29" How to get the contorl object by a string "checkbox29" In asp.net, there is a FindContorl(string), how to do that in a c# win32 app Thanks. By default the designer sets the Name property to match the underlying variable name. Assuming that this remains true then you can enumerate through the child controls looking for the control with the Name property of "checkbox29". Therefore you'll need to enumerate the children of your control using the Controls ...Show All

• Visual Studio Express Editions Free VB Book

  http://msdn.microsoft.com/vstudio/express/register/ is a page on registration benefits that says to get " Microsoft Visual Basic 2005 Express Edition: Build a Program Now!" at the Registration Benefit Portal. How can I get the book How can I find the portal hi, you can try this link https://connect.microsoft.com/downloads/downloads.aspx SiteID=40 hope this helps ...Show All