Bob-12's Q&A profile

• SQL Server error: 17194

  I cannot use sql connection. This is my connection string 'Conn.Open "Provider=SQLNCLI;Database=dbname;Server=.\\MSSQLSERVER;UID=username;PWD=test123;" The error message appears on browser is Microsoft SQL Native Client error '80004005' Client unable to establish connection due to prelogin failure /Connect.asp, line 8 in SQL server ERRORLOG, it shows Error: 17194, Severity: 16, State: 1. The server was unable to load the SSL provider library n ...Show All

• Visual Studio Team System PRoject ALert not working in Team foundation Server

  hi Project alert is not working. can anyone tell the procedures to configure that ... Thanks Rithu hi Buck, Oops,It's strange...... I have check all the setting of IIS accroding to the documentation you provided. But it still doesn't work... Any idea Thanks. Frank R ...Show All

• Windows Live Developer Forums MSN Search Web Service SDK Version 0.60 Now Available

  This SDK update includes code samples in VB and C# for Visual Studio 2003 and 2005, an updated online help file (CHM), and several new, important features. The new functionality available through the MSN Search Web Service includes: Support for all markets (CultureInfo) currently available through MSN Search (see http://msdn.microsoft.com/library/default.asp url=/library/en-us/MSN_Search_Web_Service_SDK/HTML/F_Namespace_SearchRequest_Cult ...Show All

• .NET Development obtaining identity from sql server after insert using DA - constraint error

  I am using a DA with individual select, i,u and delete sps. The update sp first updates the fields UPDATE Customer  SET [Company] = @Company,........ then returns the whole row to ensure that calculated columns are refreshed at the client. I used to have a simple select for this and it worked fine : SELECT [Customer].[Company],..............  FROM Customer  WHERE PK = @PK but for ease of applying future changes, I wanted ...Show All

• Windows Forms How did they achieve the Windows XP Look?

  Does anyone know how they got the controls on the forms to take on the Windows XP appearance. For instance the combobox controls take on a flat border style appeareance which isn't even a DropDownStyle option.  All the controls seem to take&nbs ...Show All

• .NET Development datagrid related

  Hello all, Plz help to rectify my code, its urgent public class Form1 ///// class 1 { form2.getProjectedtable(); } public class Form2 //// class 2 { getProjectedtable() { -------------- display a table in datagrid ---- } Public class Form3 //// class 3 { writing query like select * from table where abc>100 retrieves a row no ...Show All

• Visual Studio Crytal Report Compatibilty with Windows XP.

  Hi all, If anybody provide some resolution, that is really appreciated. I am having problem with a report in  crystal report 9.0 when runnning on Windows XP. The report is running fine when I open it in Windows 2000, but in XP I am getting error message when I refresh the data. An error message pops up saying "Failed to open rowset" and  after that another error message pops up saying "Query Engine Error : 'HY000:[O ...Show All

• Software Development for Windows Vista the labs again: why aren't the new custom activities added to the toolbox?

  Hello again. today i've resumed the hands on labs. on lab02, i've just  created a new activity libary with one activity placed inside it. this activity is on a solution which also has a workflow project. the docs say that when i build the activity i'm supposed to see an ew category on the toolbox. well, it just happens that i don't see anything there! is this a bug i'm asking this because as i sai in previous posts, most of the things that ...Show All

• SQL Server INSERT and SELECT in one SP

  I've used this Insert into MyTable (fname,lname)values (@fname, @lname); Select 0 as retval; but the SELECT in not working , how can i do both in one sp Thank you all Kob_Kob Why are you using ODBC to connect to SQL Server Does your application target different databases SqlClient is the most efficient way to access SQL Server from .NET. Below page has samples on how to use the parameter collection: http:// ...Show All

• Software Development for Windows Vista Workflow arrows not showing up - what's wrong ?

  Hi, I just installed WWF Beta on my machine (W2k3 SP1, VS2k5 B2) and tried the "State machine" lab. I could make all the steps that were shown and the project compiles fine (haven't come to the step where I could run the project, though). But when I look at the workflow overview, I cannot see the arrows that mark state changes! The layout is still "all shapes in onw column", so it seems the designer has not caught my "change state" shapes inside ...Show All

• SQL Server Persisting Bookmarks

  Is it possible to persist bookmarks aka what is the intended lifetime/scope of workbench bookmarks This question stems from a chapter I am writing on sql tools. I have used the bookmark feature in the past and upon testing it I see that you can assign bookmarks to any editor and then save/close the file. Later on (so long as you have the same bookmark window open with the bookmarks set) you can reopen the file and the bookmark appears. Wh ...Show All

• Visual Studio Express Editions MSDN Express Library Download

  Is it possible to manually download the MSDN Express Library so as to burn it onto a cd like the other Express software Thank you. Oh. I just reread the sentence on the manual install page and it says "comes with all optional components," so I assume it does. ...Show All

• Visual C# VS 2005 issue: DataView new Row EndEdit() changes a reference of the new Row to the DataView last row

  Hello! Working on migrated to VS 2005 (from VS 2003) UI application I have discovered an unpleasant d ifference in behavior of DataRowView : new row reference is no longer valid after calling EndEdit(). C# .NET 2.0.50727; DataView is Sorted; new row added using AddNew(). New row reference switches to the last row in the DataView after EndEdit(). Sample test code: string sID = "" , sName = "" ; DataTable dtProduct = ...Show All

• SQL Server Excel connection properities -

  In my package I need to change the filename name for my input Excel based on a the contents of an external file.  I want to read the external file, get the filename/location from this file and then dynamically set this as the property for the Excel Connection.  I saw some posts related to this but did not understand which tasks I need to use and in which order.   thanks No I'm not - I had a feeling that I was doing som ...Show All

• Visual Studio Team System How do I do a build ?

  I installed VSTS on the weekend, and moved my project over to it. It is all good, but now I am in the office, and I can't connect to my server. I can open my project disconnected from source control, but the build menu is all changed - I can't see how to set a release build, and the build option just crashes ( I assume because it's supposed to run the build task, which is not set up yet ). How can I do a build before I go home, I need to deliver ...Show All