BlackMan890's Q&A profile

• Visual Studio Express Editions Connecting to sql server

  I am wanting to write a visual basic front end to my sql server 2000 database. I have downloaded visual basic express 2005 and it only seems to want to connect to an sql server express database. Is it possible to connect visual basic express to sql server 2000 and if not whats the best way to go about this You should be able to access the database through code.  I am running vs 2005 not the vb express so I can not test this.  Try droping a datagridview on the form.  Add this code to the forms load event <code>     Private Sub Form1_Load(ByVal sender As System.Obj ...Show All

• SQL Server Can SSIS work in a Cluster

  We have just installed a new SQL 2005 Clustered server and loaded integration services. However it appears that integrations services may not work properly in a clustered environment. So can integration services be setup on a clustered SQL 2005 server Funny, someone asked the same question earlier today. Is it clustering day :) Go here anyway: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=366352&SiteID=1 -Jamie ...Show All

• Visual Studio Express Editions How Export table as .csv file

  I need export the data. Please help-me. Thank's You can use ADO.NET to interact with CSV files, although I've never used it to write on from scratch. I'd guess that it would be possible though. Alternatively, you can just use a StreamWriter, as you would for any normal text file. Just use an outer loop to iterate over the rows in the table and an inner loop to iterate over the fields in the row. ...Show All

• Visual Studio Team System MSF Agile: What about business rules?

  I'm starting a project with MSF Agile. I've read almost all the Process Guidance and found it very detailed, very interesting. But the thing I don't find where to put are the business rules that are present in many of my scenarios. The guidance says that the system behaviour show be described in high level in the scenarios, so I cannot give much detail there about the business rules the system must follow there. But, after scenarios, there is no other place where I can put those rules before developers start coding. So where do I put the business rules Thanks. Julio Casal .Net Solution Developer MCAD Grupo Lebed Thanks Will. That's a g ...Show All

• Microsoft ISV Community Center Forums how much

  I don't exactly understand all MSDN offers... trying to figure if it's worth membership costs, and what that cost is. We develop software that integrates with MS MapPoint, and are looking into developing a solution for inventory/accounting/servicetrends/etc, for which our customers would need to buy the Microsoft compents to plug in. How much is each msdn user license Hi, I just wanted to let you know that I'm looking into this for you and will post what I find as soon as possible. -brenda (ISV Buddy Team) ...Show All

• SQL Server AS400 password request

  Hi all, I'm loading a working SSIS package in VB.NET and executing it programmatically. As the 'Persist Security Info' is set, it executes fine, presumably because I executed it previously with valid login info. But, when I update the connection info (programmatically) it prompts me for a password at runtime. The connection string will be provided by the user (DB Admin) and this is running as a Windows service, so what I want to do is, in the case of invalid login info, just receive a rejection, that I can respond to in the code. I'm using the IBMDA400 data provider to connect to an iSeries. Ideally, I need a generic solution that will ap ...Show All

• Visual Studio Creating a report to show future outlook

  I was wondering if someone could help me out a bit with an idea on how to go about writting this report . Essentially I need a report to show me when certain pieces of equipment are due for maintainence for a year.  I can get it for the most part but it only shows me when the equipment is due next, but I need it to show me when the equipment is due all year. i.e. - if something is due every 30 days it should print that record 12 times but every 30 days. The only thing that should change is the Next_Date but eveything else should be the same. For now it's just print the one record that is in my database, but I was wondering if there ...Show All

• Visual Basic modal dialog active...

  Any news on the "Microsoft Visual Studio cannot shut down because a modal dialog is active. Close the active dialog and try again." I have had this happen several times and its a pain in the butt! ME TOO ... now this is happening almost every time I try to shut down visual studio. There is absolutely NOTHING open on my pc except VS and there is NOTHING open in VS ... I have closed down EVERY window possible and it still wont end without me having to go into task manager and cancel it off (which ISNT good !!) I have a new pc and I dont want to start cluttering it up with aborting applications the WRONG wa ...Show All

• Software Development for Windows Vista Turn on computer to see a backround...and that's it

  Hi! Today I turned on my computer(Windows XP; Dell Desktop) and was greeted with my backround...and nothing else. I did Ctrl+Alt+Delete to see if there was a problem and explorer was running it said, but the list was a lot shorter than it usually is. I think I might have downloaded a virus, not positive, but definetly not ruling it out. It just happened, the computer was working fine an hour before hand, and it looks like all my files are still there(I think). The only solution I can think of for this is to do that thing where you set the computer to be like it was on a certain day. Can someone explain to me how to do tha ...Show All

• Visual C++ VS 2005 B2 getting exe files to work on other computers

  When i try to run a file created by visual studio 2005 beta 2 on a computer other than the one i have visual studio 2005 on, i get an error message saying (translated from swedish into english): This program could not start because the programs configuration is wrong, the problem could be solved by reinstalling the program. on one computer (i think it was indows 2003 server) i solved it by copying msvcp80.dll, msvcp80d.dll, msvcr71.dll msvcr80d.dll msvcrt.dll  sdl.dll sdlgfx.dll and SDL_mixer.dll to the same directory as the game. But on other computers it still doesn't run even tough i have these files. I have tried both debug and r ...Show All

• Visual FoxPro return from a form.

  Still struggling to communicate with some of my secondary forms. This problem, again, happens only in StartMode = 4. Everything is fine interactively. LOCAL cUserReturn AS String DO FORM <formName> WITH par1, par2 TO cUserReturn. I get an error message that there is operand/operator type mismatch. I tried to define cUserReturn as Variant - the same thing. The expected type of return is String . According to the Help FoxPro is supposed to create a return variable when it is not defined. I tried to leave it undefined only to get another message: cUserReturn not found. Catch-22. I suspect there is something here I do not kn ...Show All

• Windows Search Technologies WDS from a .NET Service or ASP.NET page?

  Has anybody yet managed to directly call WDS from within an asp.net page or get it running in a .net service rather than executable I always get the dreaded QueryInterface for interface Microsoft.Windows.DesktopSearch.Query.ISearchDesktop failed. Error. I'm trying to build a service that will query many desktop search engines at once and combine the results and provide them to other front-end applications via a remoting service or soap service but as of yet I havent been able to get WDS to work in anything but a stand alone exe. I read earlier that this might have to do with threading models or contexts and that microsoft was working on it b ...Show All

• SQL Server Can't set varbinary(MAX) in Visio 2005

  Why can't I use the new types in Visio 2005 When ever I type in MAX - it complains that MAX is not an integer You need to do the following ( I will assume that you are creating a database model diagram): 1. Create new database model diagram 2. Go to Database -> Options -> Drivers 3. Select "Microsoft SQL Server" in the default driver for Visio 4. Click Setup 5. Pick "SQL Native Client" for ODBC drivers to use 6. Go to preferred settings tab and select 2005 in the preferred version drop-down under DDL script generation 7. Now when you create an entity and create a new column will see varchar(MAX), nvarchar(MAX), varbinary(MAX) a ...Show All

• Visual Studio Team System Customization of MSF Agile?

  Has anyone been able to successfully customize the Process Guidance templates, incorporating attributes of your own software development lifecycle into MSF Agile This is become a critical problem for us, as we are trying to initiate a project using TFS, and would like to have the Process Guidance portal reflect how we really do things. I am looking for help from someone that has been able to either 1) modify the individual XML files (e.g. Roles.XML) or 2) modify the ProcessGuidance.XML file. I have had only mixed success in being able to add items like Tracks. And, some of my generated pages end up looking a "little different&q ...Show All

• Visual Basic Displaying Key / Value Pair in A ComboBox

  Hi Everybody Call me a little bit dumb but I have a problem in VB2005 that I cannot solve. I have a Field in a Database Table (called AddressType), that stores a tinyint value. There are four valid values allowed (1 or 5 or 10 or 20). Each of them has a different meaning. Now I want to display a databound ComboBox on a userform, where the user can change the Value. So far so good, but the key Values are not very descriptive, so when the user drops the Box down, he sees values 1,5,10 and 20 that I have entered in the Items-Property of the ComboBox. What I am looking for is that I can display a descriptive Text for each of the p ...Show All