CrowleyM's Q&A profile

• .NET Development Connection not Alive

  Sorry to post again, I think the other one has been forgotton I have a Windows Form, (Application). On that I have a TextBox called txtIdNum, a Button, and a TextBox called TxtNombre What i want to happen is when someone types into the txtbox txtIdNum, and press the button, the code will search the MSQL table, and select all the fields where FIELD IDNum is = txtIdNum.Text Straight forward, easy to say. My code is the following System.Dat ...Show All

• SQL Server SCD and populating dimensions and facts

  Hello, This is my first task in attempting to populate a fact and dimension table from SSIS. I have a Fact table Sales and dimension tables Customer and Location. The data I am getting to fill this structure is in one file. where each record contains the sales information as well the customer information and location details on the same row. I am using the SSIS to fill this structure by using the slowly changing dimension for the Customer ...Show All

• SQL Server Flat File Destination

  I have a red link from my OLE DB Destination to my Flat File Destination.  I'm not sure why it's read but the OLE DB shoves some data into a table.  I want to then take that data and move it into a flat file using the flat File Destination step but when I run my project, it shows the Flat File Destination Step green but my flat file shows nothing at the end. I'm not sure what I'm doing wrong but the line linking the two is still red ...Show All

• Visual Studio Express Editions VB E E 2005 and MySQL

  Can i use VB express edition to manipulate data in a remote mysql dataabase Absolutely: http://dev.mysql.com/tech-resources/articles/dotnet/ ...Show All

• Windows Forms How to limit which property driven columns a DataGridView will show?

  Hello! I've got the following simple classical piece of code (where dgvDatabaseNames is a DataGridView and DomainSubstance.DatabaseNames is a BindingList<SomeKindOfClass> ): BindingSource bindingSource = new BindingSource (); bindingSource.DataSource = DomainSubstance.DatabaseNames; dgvDatabaseNames.DataSource = bindingSource;   My question is: The DataGridView automatically shows all properties of the DomainSubsta ...Show All

• Visual FoxPro Using SQL Pass Through to Access my Remote Data Source

  Here's the source code which I copy from QUE Book('The One Source for Comprehensive Solutions' by Menachem Bazian) //*using SQL PASS THROUGH TO ACCESS DATA SOURCE *// LOCAL lnHandle lnHandle = SQLConnect("My Remote text") IF lnHandle > -1    SQLExec(lnHandle, "SELECT customers.* FROM customers","Results")    SELECT Results    BROWS    SQLDisconnect(lnHandle) ENDIF I try that sample, and a ...Show All

• SQL Server Matrix column visibility

  Hello, I have one column group and three static columns. I'd like to control static column visibility property depending on a field value. I.e. Hidden: =Fields!GroupId<>5. But I'm not able to find visibility property in column object. Neither in properties explorer nor RDL documentation. I'm only able to set hidden property in textbox objects. I have RS 2005. Thank you for any idea. Jirka Nouza ...Show All

• SQL Server MSSQLServerOLAPSerice will not start.

  I setup a MSSQL 2005 Cluster running on top of Virtual Server 2005. Everthing was running fine until this morning, when suddenly Analysis Services failed to start on the Cluster. When I looked in the Event Log I see the following: Source: MSSQLServerOLAPService Category: (289) Type: Error Event ID: 0 Description: The service cannot be started: The DOM parser failed to load and parse the stream. URL:'' Reason: 'A document must contain exac ...Show All

• .NET Development SSL/TLS exception when using HttpWebRequest with client certificate

  Hi, I wrote following code to call a aspx page in code (from another aspx page): HttpWebRequest httprq = ( HttpWebRequest ) HttpWebRequest .Create(uri); string certificateName = "SoapProxy2" ; X509Store store = new X509Store ( StoreName .My, StoreLocation .CurrentUser); store.Open( OpenFlags .ReadOnly); X509Certificate2Collection certificates = store.Certificates.Find( X509FindType .FindBySubjectName, certi ...Show All

• Visual Studio Can't install VS Team beta 2

  After downloading this file for 30 hours and getting it to a DVD, I immedialty get an error returned when starting setup.exe: 'Setup was unable to copy the file E:\VS\setup\DeleteTemp.exe to your temporary directory. Please make sure that the file exists and rerun setup.' In checking for this file I found that in does not exist. There is a DELETETE.exe file. I went back to my hard drive and renamed this file to DeleteTemp.exe and ran the setup.e ...Show All

• Software Development for Windows Vista Publish WorkFlow as WebService doesn't work from a VB.Net workflow project?

  I have a simple workflow defined in vb.net which compiles and doesn't generate any warnings. When I right-click the project and select 'Publish as WebService' nothing happens; no web project is added to the solution but also it doesn't write any output or errors. However, if I create the same project in C# everything works as expected, and a web project is added. The workflow exists of a WebServiceReceive activity (activate = ...Show All

• .NET Development DeflateStream throws exception when inflating PDF streams

  Hi, I tried to use System.IO.Compression.DeflateStream to decompress streams from a PDF file. The streams use FlateDecode compression, which is supposed to be compatible with DeflateStream (both are supposed to comply with RFC 1951). In fact, I can successfully inflate these PDF streams using ZLIB library. But when I try using System.IO.Compression.DeflateStream, it consistently throws System.IO.InvalidDataException: "Block length does not ...Show All

• Visual Studio Express Editions Single file database

  Hi, I'm new on .NET platform. Does the .NET 2.0 supports creation and use of a SQL driven standalone single file database or should I install a third party database like SQLite Thanks .NET itself does not contain any databases, but it contains the support. You can use Access for example and withing .NET you can connect to an Access Database with OleDb. No extra components needed, only Access ...Show All

• Visual C++ new and strings

  This program should seperate a string such as 2/3 into 2 and 3. When I run it and enter data for the string, I get an error message, the one that asks you if you want to send an error report. I got the example from a book but the book used char types and I tried to use string types. Note: use_String_Parser() is the equivelent if main. (this is called by another program. #include "stdafx.h" #include <String.h&g ...Show All

• Visual Studio Help crashes Visual Studio 2003

  I am a computer science major at a university that has Visual Studio 2003 available through the MSDN academic alliance. I installed VS without the MSDN library for an assignment and everything was great, then when I later tried to install the library it won't work. If I try to directly open the library, a message comes up saying "updating help..." then Document Explorer crashes. If I open VS the same message comes up and the whole prog ...Show All