Philippe Delodder's Q&A profile

• SQL Server Error on build solution, if SSIS project is part of build

  Hello, we have automated build on every night. In our solution is SSIS project, where each package is encrypted per password. We call build process per command line like this.. C:\Programme\Microsoft Visual Studio 8\Common7\IDE\devenv.exe (c:\Development\X3\\X3.sln /build Release)' in 'c:\Development\Projects\DailyBuild Through build process we get a error: External Program Failed: C:\Programme\Microsoft Visual Studio 8\Common7\IDE\devenv.exe (return code was 1): We think a reason is, that on build of SSIS project must be entered a password. You can wonder for what we need that SSIS packages are part of our build. We hope that on build process is also created Deployment Utility, if so set in dtproject.user ...Show All

• Visual Studio 2008 (Pre-release) Convert .NET 2.0 Windows ap to use 3.0 WCF Service?

  I have an existing .NET 2.0 Windows application that I would like to add a .NET 3.0 WCF service to. Is there some way to convert the 2.0 Windows ap to 3.0 easily, without having to go to WPF Thanks, Kevin Thanks. I do know that they are separate. But when I try to add WCF stuff into my 2.0 application (even on a machine with 3.0 and VisStudio extensions installed) the development environment cannot see the WCF classes etc. Maybe there is something simple I am missing here (probably), but what I want to do is just add WCF classes into the Windows ap (it is a test tool). I am proceeding now by having separate projects, and passing through a wrapper layer, but that is a pain... Kevin ...Show All

• .NET Development phantom "=" signs?

  I have an xml reader thats reads an xml string onto it, this works fine but when i try to call the individual elements to enter into my database using an sql string some of them have the = character in them. They seem to have appeared from no where any ideas string before: "<Client><ID>WEBCLAFFKD722164086454497T</ID><DateTimeAdded>10/30/2006 13:51:00</DateTimeAdded><CompanyName>Test</CompanyName><Position>Test</Position><Title>Test</Title><FName>Test</FName><LName>Text</LName><EmailAddress>test</EmailAddress><Telephone>85763866733</Telephone><WebSite>test</WebSite><Mobile>06987354266</Mobile> ...Show All

• SQL Server DataTransfer Error

  I have written following lines of code, but when TransferData() method is called, it generates error "Property LoginSecure cannot be changed or read after a connection string has been set."  Can anybody help me Thanks in advance.... Code: //1. Create Transfer Object Transfer transObj = new Transfer (); //transObj=new Transfer(server.Databases[fromdatabasename]); transObj.DestinationLoginSecure = false ; transObj.DestinationLogin = "sa"; transObj.DestinationPassword = "test"; //Set Destination Server //Build a "serverConnection" with the information of the "sqlConnection" destSrvCon = new ServerConnection (sqlCon); //The serverConnection is used in the ctor of the S ...Show All

• Visual Studio Express Editions How do I convert .NET 2.0 Coding into VB 2005 Express Edition coding?

  How do I go about understanding and converting the coding of .NET 2.0 into the coding that Visual Basic 2005 Express Edition can understand Could you possibly figure out these next two for me. That would be great. THANKS! public NumberedTextBoxUC() { InitializeComponent(); numberLabel.Font = new Font(richTextBox1.Font.FontFamily, richTextBox1.Font.Size + 1 .019f); } private void richTextBox1_VScroll( object sender, EventArgs e) { //move location of numberLabel for amount //of pixels caused by scrollbar int d = richTextBox1.GetPositionFromCharIndex( 0 ).Y % (richTextBox1.Font.Height + 1 ); numberLabel.Location = new Point( 0 , d); updateNumberLabel(); } ...Show All

• Visual Studio Express Editions print on screen

  hello this is the dumest questin u will ever here... how can you print things on the form. i tried print "" and it dosnt work. how can i print on my forms. thanks You cannot print directly to the form, as you did in VB6. You need to direct the text to a label or multiline textbox. Note: You must include a line feed between the text to continue to the next line. For example: mytext = "Four score and seven years ago" & vbCrLf & "our fathers brought forth on this continent" _ & vbCrLf & "a new nation" etc. ...Show All

• Visual Studio 2008 (Pre-release) Linq implementation sample

  Is there available sample of implementation of Linq interfaces for own data storage You may take a look at my sample Linq to Amazon implementation . It shows how to implement IQueryable to query a web site. Querying you own data storage would require the same implementation steps. ...Show All

• Visual Studio Express Editions Registration Benefits

  Where is the web site I go to read E-Books and Articles and Corbis Image Pack, IconBuffet Studio Edition Icon Suite you can email at kc8pdr@kc8pdr.info Sure, here you go... https://connect.microsoft.com/downloads/downloads.aspx SiteID=40&wa=wsignin1.0 ...Show All

• Microsoft ISV Community Center Forums How to copy pivot table RESULT from Access to Excel

  I need to produce a highly formated pivot table report in Access and can only achieve so much. However, if I could programatically select the pivot table (equivalent of keys [Ctrl]+ ) then copy and paste into Excel, I can use VBA to format the report in Excel. My problem is that I cannot find a way to programatically select the pivot table in Access. I have tried Sendkeys "^A" as a last resort but this doesn't work. Exporting to Excel doesn't work either as it exports the pivot table, not the result . Hi Rick, Suggest that you try send the recordset (if it is small enough) to an Excel spreadsheet with can contain your pivot table . I have an App which is too large for this so I work t ...Show All

• Internet Explorer Development Using Client Certificates

  I need to authenticate user credentials (on a button click). I need to read the certificate subject present in the user's browser. I am using the "HttpClientCertificate" class. I have installed the client certificate in my browser (I can see it in the "Personal" folder). When I make a request to the login page, first the server certificate pops up, then a dialog pops up asking me to choose from a list of client certificates, but the list is empty (I cannot see the certificate I have installed). I observe that "certificate.IsPresent" returns false. protected void btnLogin_Click(object sender, EventArgs e) { HttpClientCertificate certificate = HttpContext.Current.Request.ClientCertificate; if ...Show All

• SQL Server Error: Subreport could not be shown.

  I have a problem with a report containing a number of subreports not running successfully when deployed to the Report Server. The report runs successfully every time in the VS Development environment, so parameters are all setup correctly and the result is as expected accross the whole report. No errors or warnings are listed when building or deploying. All subreports are in the same project as the main report and deployed to the same folder in Report Manager. All the individual subreports run successfully both in VS Studio (Preview Tab) and in the Report Manager portal. About 50% of the time, the main report runs but shows the error "Subreport could not be shown" for some or all of the subreports. Running S ...Show All

• Visual Basic Desktop folder question

  Hello, I was using the "My" namespace to reference the Desktop folder, like this: My .Computer.FileSystem.SpecialDirectories.Desktop but it was not showing all the contents of the folder. Another person said that the "My" value returns the filesystem folder corresponding to the desktop and not the Windows shell desktop folder. Is there more than one Desktop What does this mean Thanks for any suggestions. sorry how do you mean its not showing the contents of the folder This should do the same thing if you are retrieving say files/folders of the desktop: Dim theFiles() as String = System.IO.Directory.GetFiles(Environment.GetFolderPath(Environment.SpecialFolder ...Show All

• .NET Development Reading XML not as easy as writing...

  I understand how to write xml and I have implemented the code below. I do not however understand how to read the data. How exactly can I have an XML Reader find the data contained within the 'Value' attribute in the StudentNumber element and store it in a variable I have explored the XmlReader Class for days and I have no idea what I'm doing! With Writer .WriteStartDocument() .WriteStartElement( "QueryIndexes" ) .WriteStartElement( "StudentNumber" ) .WriteStartAttribute( "value" ) .WriteValue(0000000) .WriteEndAttribute() .WriteEndElement() .WriteEndElement() .WriteEndDocument() .Flush() .Close() End With The resulting XML file: < xml version="1.0& ...Show All

• .NET Development Does AxImp support creation of 64-bit assemblies?

  Hi there, I tried asking this on the 64-bit MSDN newsgroup but didn't get any responses. Has anyone used AxImp to create 64-bit Interop assemblies from an (64-bit) ActiveX control When I do the following, all I get are 32-bit assemblies: C:> aximp my64bitActiveX.ocx Generated Assembly: MY64BITACTIVEXLib.dll Generated Assembly: AxMY64BITACTIVEXLib.dll Both the generated dlls are 32-bit. AxImp doesn't seem to have any options to specify the target machine type. TlbImp does provide that option, but I can't use TlbImp to create the necessary interop wrappers for the ActiveX component. I've made sure that the typelib information in the ActiveX control is indeed 64-bits. I'm running on Windows XP64, and am using Visual Studio.Net 2005 (not SP ...Show All

• SQL Server SQL query problem....newbie question

  So, I have never worked with SQL in my entire life, but have some basic programming skills. I was given a job to run through two tables, sort some of the information and return the two most recent enteries for the job number. I can sort everything but I am having a hard time just returning the two most recent enteries. I have two tables in which to look from and I think a subquery WHERE with the TOP would work.... yet I have tried everything i can think of and after a good 10 hours of research, im hoping to get some help! The two most recent enteries that i need returned is "start date" with all the other information... Here is my code that is from designer (which i have played with to no avail) SELECT Table1.[Inquiry # ...Show All