GaryR's Q&A profile

• Visual Basic how to access an https server with winhttp

  Hi I habe started to use winhttp to "dialogue" with web servers from a VB.Net app. It works fine as long as the server is a straightforward http server. I now tried to do the same with an http S server URL, and i just can't connect to it. I have tried setting credentials like this: URL =" https://myroot/mypage/script.do " ' Open an HTTP connection HttpReq.Open( "GET" , URL, False ) ' Set credentials for server. HttpReq.SetCredentials( "myuser" , "mypassword" , HTTPREQUEST_SETCREDENTIALS_FOR_SERVER) ' Send the HTTP Request. HttpReq.Send() but that does not help at all (still no response whatsoever from the server) I have looked at the SetClientCert ...Show All

• Microsoft ISV Community Center Forums Outputting to a Listbox

  Hi; I have a list of data, and need for values outside a lower and upper bound to be flagged up to the user. I was thinking of outputting to a listbox, but cant get the code to work. I was wondering if anyone had any ideas for possible code, or a better way of outputting to the user. Ryan My list is in H2:H" & FinalRow & " where FinalRow is defined as FinalRow = Range("A65536").End(xlUp).Row The only problem, my list has empty slots. As in i only want cells with values in to be outputted to the listbox. ...Show All

• SQL Server SQL Server 2000 Query slowing down in SQL Server 2005

  Hi everybody, I have a query slower in SQL Server 2005 than in SQL Server 2000. I have a database in SQL 2000, I put it on the same server, but with SQL 2005 and the query take 5 seconds instead of 0 seconds. The DB compatibility is SQL Server 2000 (I tried with 2005 and result is the same). Execution plan seems right and I tried to change some DB options without results. It is weird, when I remove left join on MandatsEx, it take 2 seconds. The view currentEmployeeLevelHistoric returns 45 000 rows and mandatsex has 0 rows. Here is the sample: Select ls.EmployeNiveau.pk_EmployeNiveauID as NoNiveau, IsNull(nullif(ls.Traduction.Description, ''), ls.TraductionDefaut.Description) + ' (' + ls.currentLevelHIstoric.NoN ...Show All

• SQL Server .dtsx package from Informix using ODBC

  Help! I'm trying to create a simple .dtsx package that imports data to SQL server 2005 from an informix 7.3 db using an ADO.net ODBC connection. I am first creating the groundwork for the dtsx package in SQL server using the wizard, and then editing the file later in visual studio. My data source SQL in the dataflow task is simple and it works great until I hit a locked record on the Informix database. select <coulmns> from <table> Where <condition> The work around syntax for the locked row on the informix DB should be: set isolation to dirty read go select <coulmns> from <table> where <condition> This syntax will return the data correctly using a non-microsoft ...Show All

• Visual Studio Express Editions How to format textbox

  Hi guys, Greetings! Would it be possible to format the textbox in such a way user can only enter numeric data including one period Just like in Visual FoxPro Where the textbox can be pre-formatted during design time such that when user types in, numerals and period are the only valid character that user can only enter. Is this possible If yes on any how, please help. Thanks, Hi ahmedilyas, Thank you! Another question, if MaskedTextBox is possible for textbox entry, how about if I want it in my DataGridView like I have a column there that user can enter the number of items purchase (I prefer to have number separated with comma) just like the validation on my first question : ) ...Show All

• Visual Studio Team System TFS Product Key

  I originally had TFS Trial installed, and have since purchased the Team Suite MSDN that comes with TFS Workgroup Edition. How do I get the product key for the workgroup edition so I can update the trial license Sadly, I don't think Workgroup -> Trial is a supported path. Workgroup to full is though so hopefully your key will arrive in a couple of days. Maybe you can give Keith some pointers as to how you managed the Trial -> Workgroup migration ...Show All

• Windows Live Developer Forums MSR MapCruncher v3.0 released

  We've just released v3.0 of MSR MapCruncher for Virtual Earth, which allows you to quickly & easily overlay your own custom tile-sets for Virtual Earth from PDF, JPEG, TIFF and other image files. You can find it here: http://research.microsoft.com/mapcruncher. For a list of changes, see: http://research.microsoft.com/mapcruncher/changes.html Cheers, the MSR MapCruncher Team Great work. I like "Supports zoom levels up to 32 (approximately .03mm/pixel). " Now i can go a crunch the Core Duo circuit diagram into the lab at intel John. ...Show All

• Visual Studio 2008 (Pre-release) netTcp - The server has rejected the client credentials

  Hi, I'm testing a simple tcp client/server and everything works fine locally. However, as soon as I go over the internet I get: SecurityNegotiationException - The server has rejected the client credentials This is what my config looks like: < xml version="1.0" encoding="utf-8" > <configuration> <appSettings> <!-- use appSetting to configure base address provided by host --> <add key="baseAddress" value="net.tcp://mydomain:8000/servicemodelsamples/service" /> </appSettings> <system.serviceModel> <services> <service name="Microsoft.ServiceModel.Samples.CalculatorService"> <!-- use base address provided by host --> ...Show All

• Visual Studio Reporting objects with internal collections

  Hi, I want to report some a object collection that has some property of colletion type. For example: class Student { Property int Years; Property string Name; ... Property MaterialsCollection Materials; Property TutorsCollection Tutors; } class Material { Property string Name; Property int Code; Property float Calification ... } class Tutor { Property string Name; Property string Address; ... } I want to list all the students showing in one row all the materials collection and tutor collection.Something like this. StudentName StudentYear ... Material1Name Material2Name ... Tutor1 ...Show All

• Visual Studio Team System Datadude and WIX

  I am using WIX to build various installers. In one of them I want to execute the .sql file that is the output from a DatDude project. Unfortunately I cannot do that because the .sql file contains SQLCMD directives such as: :setvar databasename "BipaRepository" and thereafter all references to the database are made via that variable. Hence, it fails when you try and use it in the installer that WIX produces. I can see the advantages of passing in the name of the database but because I am using WIX it is actually a hinderance. Is there any way that I can get the name of the database hardcoded in the .sql file rather than these SQLCMD directives Thanks Jamie Gert Drapers wrote: ...Show All

• Visual Studio Team System Different states if the bug is created by a user in the customer group.

  Is it possible to make the states possible depend on who created the bug in the first place If the bug was created by a person in the "firm" group the bug can be closed after internal test but if the bug was created by a person in the customer group it must go throug both internal test and customer test before it is possible to close it. Best regards, Jens As the link suggests there is no way through the work item type definition to change the workflow based on the value of another field. I'll add this suggestion for "dynamic workflow" as a product idea for future versions. In the meantime one option that may be available to you is to write a web service that subscribes to "WorkItemChangedEvents&q ...Show All

• Connected Services Framework Should Active Directory be a Domain Controller or in a different domain ?

  MCSF uses Active Directory to store user details. 1. But does it need to be in a different domain or a domain controller 2. Can I just install AD and point MCSF to store users there Regards, Sachin Hi Sachin and Tilak, Thanks for your notes - please also note that the CSF Identity Manager component can not be installed on the same server as Active Directory, because the Identity Manager component uses impersonation, and Active Directory does not permit processes to use impersonation on the same server. Many Thanks, Sachin and Tilak!! -Rob. ...Show All

• Visual Basic Converting VBA to VB2005 problem (or my ignorance)

  Hi, I've been in the IT trade all my life. I didn't come to this job as a programmer but after working here a short while, I showed everyone how I could save the company tons of man-hours (money) with a few custom programs. They didn't have any programming languages so I used VBA inside of their Office 2002 suite. They were so impressed, they gave me anything I wanted. I wanted Visual Studio 2005. Suddenly I'm a full time programmer here. The first thing I wanted to do while I familiarized myself with VS2005 was convert an already working, processing intensive, program that I had already written in VBA. This thing literally compares billions of cells in very large spreadsheets, and as you can imagine, it takes a while to process. I spen ...Show All

• Smart Device Development Localize Network Folder

  Hi, I need to localize the Network folder (name). How can I do this Thanks in advance, Stefano With WNetAddConnection3 I connect a PC folder to my device. I'll find this folder under the <Network> folder on my PDA. If the operating system is english, this folder is Network, if it's italian is Rete. I need a function to get the localized name. ...Show All

• Windows Forms Text not showing up in Listbox

  I am having problems populating a listbox and having the text show up. When I first encountered the problem, it was within a more complicated program. So, I began a new C# Windows application program, used the default "Form1" and drug a listbox on it. I renamed the listbox to lstCSAList to match the other program I was working on. In design time, I clicked on the ellipse, under Items where it says "(Collection)". I added, line1 line2 line3 In the Form1_Load subroutine, I placed the following code: private void Form1_Load( object sender, System.EventArgs e) { lstCSAList.Items.Add("Dummy"); } When I build and debug the program, I get the listbox with no text displayed. However, ...Show All