Luigi Fonti's Q&A profile

• SQL Server Looking for ideas

  Hi everyone   We've got currenlty around 500 dts 2000 in production.   In order to know in what ETL processes we have Oracle connections, or FTP tasks or whatever, we did a VB6 app using dtspkg.dll which load all the properties for each DTS into Sql server tables. So that, then you could see from a specific DTS how many connections, Sql Tasks it had and so on..   How to accomplish the same with SSIS I know, doing the same but using .Net, of course, but is there any else approximation I am little bit concerned when we will have hundreds of them up.   Maybe 2005 is offering this feature automatically, I don't know.   Thanks in advance for your time/advices/ideas, ...Show All

• Visual Studio Express Editions Connect to word and get form data?

  I recently began working on a Word macro to send data from form fields to an Excel spreadsheet. The project went well and I decided to create a Windows Application with VB 2005 EE to do the same thing. The basic premise would be I would point the application to the appropriate Word document containing the forms and it would send the data to the appropriate Excel spreadsheet. I have been searching for quite some time now (including on this forum) and I can't seem to find a way to correctly connect to a Word doc of my choice and then get the form data. Any help in this area would be greatly appreciated. I need: 1. How to connect to a Word document in VB 2. Once connected how to get data from Word document I ...Show All

• Smart Device Development Bluetooth Virtual Serial Port Problem

  Hello. I am writing a NETCF 2.0 application for my Motorola Q phone running Windows Mobile 5.0. I am using Visual Studio 2005 to develop my application. So basically, what I want to do is send a simple string from my phone to my pc's hyperterminal says "Hello world from the Motorola Q phone". I found that the documentation for the Motorola Q phone says that COM1 is reserved for the Bluetooth serial port. So as for a test, I wrote a simple Windows Mobile 5.0 smartphone app that uses the NETCF 2.0 serialport control. All I do is open COM1 and close it when the application is closed. Everything works well initially. The Motorola Q phone notices that my app is trying to open the Bluetooth serial port and prompts me if I wou ...Show All

• Visual Studio Putting ReportViewer on Hosting Site- How-to-do

  I am running a VS 2k5 with SQL 2005 standard on a hosting site. I wanted to run ReportViewer local, to me its OK to work slow with reporting then not at all and from how I read the web site: http://www.gotreportviewer.com/ they seem to say that local is free. Please verify this 1st point then I ask a 2nd question. Are there references that I can add to a VS 2k5 project so a hosting service does not have to run " C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\ReportViewer.exe" THanks for any help. ...Show All

• Software Development for Windows Vista What do i have to do in order to use SqlWorkflowPersistenceService

  I tried to add SqlWorkflowPersistenceService with a valid connection string (an existing DB) , but once i create an istance of workFlow i got an exception with could not find stored procedure RetrieveNonBlockingInstanceStatsId. is there any process for creating those tables and stored procedure Thanks Amit Hi Amit, Follow the steps below to create tables and stored procedures for sqlpersistenceservice. To create and configure the SQL database Using Microsoft SQL Server 2005 Express, Microsoft SQL Server 2000 or later or Microsoft SQL Server 2000 Desktop Engine (MSDE), create a new database named SqlPersistenceService using the SQL query statement: CREA ...Show All

• Visual C# HOW TO: Spilt Text File After Specified Line

  Hi All, How can I split a big text file (e.g. 4525 lines of data) into pieces of smaller text file after a specified number of lines (e.g. it will gives us 10 smaller file if the smaller file has maximum 500 lines of data; the last piece will have only remainder 25 lines of data.) Thanks in advance. Thanks. I was very grateful of your help here. Another few questions here. 1. What if I would like to split the file by its smaller pieces file size (e.g. 2MB for each pieces.) 2. How do I save the first 5 lines from the original file into the  first 5 lines of the smaller peices of files Thanks in advance. ...Show All

• .NET Development DataColumn Expression Support for Byte Array

  Is there any support for the System.Byte[] datatype in DataColumn expessions I would like to at least be able to get the length as in: col.Expression = "LEN(ImageColumn)" . The LEN function only works on Strings and converting a byte array with the CONVERT function returns "System.Byte[]" The documentation does give any mention of handling byte arrays. Does anyone know of a solution ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Can someone reliable give me the relase time of XNA GSE in GMT?

  Hi guys, Just wanna know from someone reliable or someone that can tell me if it'll be relased at midnight, or if I don't bother sitting through the night for it. Its just to save me waiting till early moning 30th August, and finding it ain't up until say America reaches midnight. thanks again, Jonathan Have you registered to receive notification when it's available If not, I suggest you do. That's the most reliable way to know when it's available it seems. ...Show All

• Visual Studio Express Editions FTP Uploading

  hi. i just wanna know the code for uploading a file usnig an ftp, a code that will let me enter the server, password, username, and the file to be uploaded. tanks the link you need to put there is the website/ftp url you wish to upload the file to and including it the filename you wish to name it to. Example if I had a file on my computer called "text.txt", and I had an ftp site called "myftp.com", then I want to upload it to that ftp site and name the file to "text.txt", I would enter this: ftp://myftp.com/text.txt this will upload the file to the ftp site in a file called text.txt ...Show All

• SQL Server sql server 2005 setup error

  hi.. I am getting the following error while installing SQL Server 2005 Eval edition on Win XP. I am the administrator on the system. Error: SQL server Setup was unable to add user NT AUTHORITY\SYSTEM to local group SQLSERVER2005MSFTEUSER$COMPUTERNAME$INST ANCENAME. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Program crashes immediately after launch...

  I'm trying to get a window up using unmanaged dx9. It compiles, but for some reason it never actually gets to run() and breaks where it says if (msg.message == WM_QUIT). I'm sure I've gotmost of it right, but am missing something stupid.... Here's what I have: // cppdx9demo001.cpp : Defines the entry point for the application. // #include "stdafx.h" #include "cppdx9demo001.h" #define MAX_LOADSTRING 100 // Global Variables: HWND hWnd; HINSTANCE hInst; // current instance TCHAR szTitle[MAX_LOADSTRING]; // The title bar text TCHAR szWindowClass[MAX_LOADSTRING]; // the main window class name // Forward declarations of functions included in this code module: ATOM MyRegisterClass(HINSTANCE hIns ...Show All

• .NET Development CAS Policy Problem

  I have an assembly deployed which demands a certain permission. This assembly is strong named and lives in the \bin directory. To make configuration "easy", I figured I'd add a new Code Group to my Runtime Security Policy using the .NET Configuration tool which grants Full Trust to my assembly. The Code Group is under All_Code and the Membership Condition of the Code Group looks for a strong name of an assembly using the public key of the assembly (derived by importing the .dll). I disregard name and version. Straightforward, right It just doesn't work, though! Every time, my assembly fails the permission demand! In theory, it should have full trust, right What could be going wrong You ...Show All

• Visual C# MessageBoxIcon.Hand not working as expected

  I have a MessageBox that I would like to use to advise users that a DataGridView has no records in it that can be modified. I've written the code for the MessageBox to look something like the following... MessageBox .Show( "No records are available for editing." , "No records to modify" , MessageBoxButtons .OK, MessageBoxIcon .Hand); The problem is that the Hand icon does not display when this message box displays. Instead, I get the standard error icon that consists of a white x in the middle of a circular red background. I've noticed that the tooltip that appears while I'm writing my code even tells me that this is what will display. Is this a known bug or am I having this problem for some other rea ...Show All

• SQL Server SQL 2005 Express on Server 2k3 Enterprise

  After a few failed installs I have gotten SQL2k5Exp installed. I have update my .net and my XML. I had the server running fine for about a week. The server still 'runs' fine, but when I connect to it with Server managment studio express I can't do anything with it. It will not allow me to expand the 'System Databases' It gives the error: "Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum) Additional information: An exception occured while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.) (Microsof ...Show All

• Windows Forms How to find the installation folder for the ClickOnce application

  I was wondering if there was a way to find the application installation location installed with ClickOnce. I wasn't sure if the ClickOnce creates a registry entry or has any environment variable that keeps a track of this path. Currently, I have a way to know the application path from within the app, but for that the app needs to be executed atleast once. I am looking for a way to store the folder where my app would be installed with ClickOnce either during the installation process or after the installation. The app I am referring to here is a smart client that I need to open by passing an XML file as the input parameter or have the XML file stored in the directory of the executable. However, after I install the app using ClickOnce, ...Show All