John_Cronan's Q&A profile

• SQL Server Programatic Fuzzy Lookup

  I want to use Fuzzy lookup to search a table for similar matches. I would like to do this from code in Visual C#. How do I do this or can I If I cannot, will this be something available in the future You can run a package containing fuzzy lookups from C#. Do a search in help for "Running an existing package using Visual Basic". The code can easily be ported to C#. What you can't do is take SSIS functionality out of SSIS and use it elsewhere - it must all run within a package. -Jamie ...Show All

• SQL Server SSIS custom component will only partially update in VS causing debugging to fail

  When I try to debug the break points will always say the source code is different from the current version, but the custom component in the GAC has the new version number. The other strange thing is the toolbox will not reset to the original version meaning it will not remove the custom components. The funny thing is after I compile the custom components and restart VS the custom component runs with the new code changes. I can see the new features I added, but the debugger and toolbox still seem to be broken. I have tried the following 1) Reset the tool box. 2) uninstall all my custom dll from the GAC “C:\WINDOWS\assembly ...Show All

• Visual C++ Port in use!

  Hello, I am working with a database program(client-server) developed using visual studio.When i install the program and open the database, i get the error message "Port in use".But this is not the case when i run the program from the visual studio.In my code     m_server.ConnectTemplate(clsid, pDocTemplate, FALSE); Can anybody explain me, whether setting the parameter to TRUE could help in anyway I have very less experience with VC++. The error message can be avoided if i set in my ini data EnableWebService to 0.But i need that for my client programm to accesss the database.I tried setting Port in ini data to "nobinding". ...Show All

• Windows Forms Thread question

  Hi, I have a winform application that fire a thread that verifies a database, if the database has some new entry, the thread needs to communicate the main thread.. How can I do this via message via event via fire balls =P Thanx! To see an example of the BackgroundWorker in action check out the Application at the bottom of the page - http://www.windowsforms.net/Default.aspx tabindex=9&tabid=3 App Summary - This application uses the BackgroundWorker component and the DataGridView control (both new to Visual Studio 2005) to asynchronous load data into the DataGridView. The sample performs a “find in files ...Show All

• SQL Server Using 2 connections and DB in a query

  Hi, this is proberly a really stupid question, but I am new at this, so here goes: Is it possible to use two connections in a SELECT, i.e. SELECT * FROM p WHERE pno IN (SELECT pno FROM sp) where p is from one connection, and sp is another. Why Well I am trying to stage some data, (my very first attempt at it), and want data from the foreign table where a date is higher than a date stored in my "settings" table located in my stage DB. I am not sure if I am doing this the "right" way, if not, advice is always welcome. Generally I could really use a "best pratice" tutorial on DW and SSIS. Hope the ab ...Show All

• Visual C# Wireless Provisioning Service

  I'm using the WPS API to create a new wireless profile dynamically, however I'm running into a problem.  When running this: hrStatus = pPPW->CreateProfile ( ( BSTR ) bstrXml,   //my wireless configuration in xml format ( BSTR ) NULL, ( LPGUID ) &pGuids[ dwIndex ],   //GUIDs of my NICs ( PULONG ) &wpsResult   //error code ) ; My bstrXml is an exact copy of a sample file that the API comes with, yet after this line of code wpsResult always returns with error 33, which is WZC_PROFILE_API_ERROR_FAILED_TO_LOAD_XML. The MSDN site for this error says that the xml might not be prope ...Show All

• Windows Forms Need an EXE to open custom IE windows

  Hello. I need code to write a simple Windows Forms program that will, upon execution, just open the Internet Explorer browser with custom settings (e.g. certain IE size, no buttons, certain interanet webpage...etc). Thank you. J. S. Alfi Internet Applications Hi MarcDeVegas, To use Internet Explorer Kiosk mode in an autorun file, just use winopen in an autorun.inf as follows: [autorun] open=winopen iexplore.exe -k $EXEDIR$\index.h ...Show All

• Visual Studio 2008 (Pre-release) Error creating proxy for a Java Web service

  Hi I want to consume the web services exposed by the java application ITracker ( http://www.itracker.org ) When I ran svcutil on the WSDL to create a proxy I got the following error: Warning: Unable to import wsdl:portType Detail: An exception was thrown while running a WSDL import extension: System.ServiceModel.Description.XmlSerializerMessageContractConverter Error: Fault named ProjectException in operation getProject cannot be imported. Unsupported WSDL, the fault message part must reference an element. XPath to Error Source: //wsdl:definitions[@targetNamespace='http://WebServer/itracker/api/services/ITrackerProjectService']/wsdl ...Show All

• Visual Studio 2008 (Pre-release) Border arround a Rectangle and Polygon

  Hi all, Can anybody please tell me how I can draw a border arround a rectangle and a polygon Both are parts of a ControlTemplate. Thx!!! It's not particularly good but is this what you wanted to achieve <Page xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x=" http://schemas.microsoft.com/winfx/2006/xaml " Width="215" Height="106"> <Page.Resources> <Style TargetType="{x:Type Button}" xmlns:x=" http://schemas.microsoft.com/winfx/2006/xaml "> <Setter Property="Template" ...Show All

• Visual Studio 2008 (Pre-release) use xaml pages in asp.net project

  hi folks I created asp.net project and want to navigate through it to xaml page by using hyperlink when I did  it, I got exception "System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed."     used VS2005 and MS windows SDK beta2.0 how I can fix this problem   XAML Web Applications are a particular type of application, which are executed in a sandbox If I'm correct, it's not possible to link directly a XAML page in a ...Show All

• SQL Server Can not Subscribe a Report

  Hi, I just create a report using Whidbey and deploy it to the Project reportserver. And I can access that report correctly, but I can not subscribe that report, what's going on Additional, I create that report using Shared Data Source (connected to Analysis Service of my TFS DT) which I created in Whidbey. The exception info is below: The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting) Thanks. I understand why credentials are needed for subscriptions in R ...Show All

• Windows Forms Visual Inheritance Context Menu Bug?

  I want to use VI in a context menu, but it doesn't seem to work. In my base class I have a context menu, which is set to protected. In my derived class designer, I can see the context menu and add things to it. When I compile the code and show the context menu, only the original items appear. In the derived class' InitializeComponent function, I can see the new menu item being created, but it never gets attached to the base class context menu. Is this a bug in VS2005 I can bypass this problem by desiging a seperate context menu and adding it to the base class during the constructor, but it doesn't feel quite right to me. Am I doing somethin ...Show All

• SQL Server Framework 2.0 changes - TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.

  If you connect to a server and open a query in SQL Managment studio (2005) and looses connection and then regain the connection, when you try to run the query it gives me a "TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host."   This happens against both 2005 and 2000 servers.   If I re-run the query it works.   However, this happens in our VB.NET app as well for clients with Wireless connections.   So, something has changed in Framework 2.0 regarding this, does anyone know how to tell the client to not throw this error and just try connecting the server instead which will work ...Show All

• SQL Server Look up transformation

  Hi, we are trying to implement this logic in SSIS data flow task We have 2 datasets Dataset 1 has Emplid and Actiondate. (from Oracle Database instance I) Dataset 2 has Emplid, ProjectID ,Project Start_Date ,Project_End_Date (from Oracle Database instance II) Logic is select ProjectID from Dataset 2 where Dataset 1.Emplid = Dataset 2.Emplid and Dataset 1.Actiondate between Dataset 2.Project Start_Date and Dataset 2.Project_End_Date. for first condition we have used merge join between 2 datasets. for second condition we are trying to use look up transformation... it did'nt help ...Show All

• Visual Basic minutes to hours and minutes

  Hi everybody! for example; label1.text=1655 --minutes I want to see this like; textbox1.text=27 --hours textbox2.text=35 --minutes How can I do Try this: Dim allMinutes As Integer = 1655 Dim hours As Integer = CInt (Int(allMinutes / 60)) Dim minutes As Integer = allMinutes Mod 60 ...Show All