Andrea Giovannini's Q&A profile
SQL Server Basic: Starting SQL Server
Hello, I am having trouble just starting SQL Server 2005. When I try to use Management Studio, I do not see any server name. I just need to be able to start it up! Thanks, pagates Hi pagates, One of the easiest ways to start SQL Server 2005 is go to Start -> Control Panel -> Administrative Tools -> Services . Look up for a service by the name SQL Server or SQL Server (your instance name) , right click -> Start . If you do not see this service listed, it is likely that you have installed only the client tools for SQL Server 2005 and not the server. Hope that helps, Amol. ...Show All
Visual Studio Express Editions How to add Help Balloons to the application
Hi, I have set the Help Button Property on a form to true. This adds a question button to the form. If I then run the project and click the qustion mark button the move the mouse the question mark follows the mouse pointer to allow me to click on a control to then display help on the control. My question is how do I code this so when I click on a control it displays help either in the form of a balloon or dialog. Can not seem to find any help on this subject. Ron Still needs the 'help workshop' and then 11 more confusing steps with this software! I may just list my telephone number as help in my programs. ...Show All
SQL Server Validation Warnigns Occurred - where are they?
On of my Control Flow Items (which is a data flow task) has a little yellow warning icon on it, when I hover over it I get a 'Validation warnings occurred' pop-up. However in the Errors List for the Control Flow or Data Flow there are no errors \ warnings (). How do I find the valiation error - or force the package to re-validate Well that worked, but in my case the cause of the validation error was that the source view was not available. After creating the view in the source OLE DB connection, the red X went away from the Data Flow task, but the yellow ! stayed in the Control Flow pane. Isn't there a way to refresh this task or the underlying connection without restarting Visual Studio ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Managed DirectX reference for C# project
If I install a project from "DirectX Sample Browser" the references for DirectX (december 2006) are like this: C:\WINDOWS\assembly\GAC\Microsoft.DirectX\1.0.2902.0__31bf3856ad364e35\Microsoft.DirectX.dll But this folder path don't exist, exist only until C:\WINDOWS\assembly where I found all library, DirectX too. If inside Visual Studio I click "Add Reference" I find only folder path like this C:\WINDOWS\Microsoft.NET\DirectX for Managed Code\1.0.2902.0\Microsoft.DirectX.dll and this folder path exist. Both version of dll work very well on my PC, but the second don't work if i try it on other computer. Don't work the exe and don't work if I open project too: wrong reference. SDK is installed also on second computer (alw ...Show All
SQL Server Bookmark in Code not working.
I have a report in reporting services that has a bookmark value asigned to each row. In the following Page_Load event for the page, I'm getting the following error on the ReportViewer1.JumpToBookmark("6") statement: "An exception of type 'System.InvalidOperationException' occurred in Microsoft.ReportViewer.WebForms.dll but was not handled in user code Additional information: Some parameters or credentials have not been specified" Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not IsPostBack Then Dim strReport1 As String = "/ReportDirectory/CurrentWeekSales" ReportViewer1.ServerReport.ReportServerU rl = New System.Uri(CStr(Session.Item(&qu ...Show All
Visual Studio 2008 (Pre-release) Non-Generic ChannelFactory
We can use the generic ChannelFactory class to instantiate a proxy given a contract type, such as an interface declaration. Suppose I want to build an extensible system and declare my contract types in a file or a database - as string values. Obviously, you can't do something like ChannelFactory<"typename">. Is there a way of creating a channel based on an implicit type name - "assembly, typename" format Or even if you can specify a Type.GetType() I know "configuration" is probably the generic answer. But we have requirements that extend beyond using simple app.config files. Thanks! You can instanciate a generic type by Reflection. Type __channelFactor ...Show All
Visual Studio Team System Can I use one account instead of three accounts when I setup VSTS?
I'd like to use only one account -- TFSSETUP to set up VSTS. I don't want to use TFSSERVICE and TFSREPORTS accounts, because it's hard to manage. Due to our company policy, I have to change our password every three months. One account is easy to us to handle the server I tried that, but it didn't work, because TFSSETUP is required to be an administrator, while the other(s) are required not to be an administrator. best regards, /Tomas PS. As some other post mentioned, there is a tool for changing passwords in TFS. ...Show All
Visual C# User controls
Hello, I have more than one user controls in my project. However, when I add the new one and re-run the project, the newest user control will be running, not the one I want to be run. How can I set default for the user control I want it to run when I run my project Thanks, Tammy Hi, Tammy, not sure what you mean by running a user control. User controls are usually put on a form (dragged from the toolbox). If you want to change which *form* should display when you run your project (startup form), open your program.cs file and replace the name of the form in the following line: Application.Run(new Form1()) to, let's say: Application.Run(new Form2()) Andrej ...Show All
Windows Forms ClickOnce Fails with "Value does not fall within the expected range."
I have a ClickOnce-deployed application installed in offline mode across a range of Windows 2000/XP machines on my network. I now receive an 'Application cannot be started. Contact the application vendor.' error message when I attempt to run the application on my development machine. (It works still on the production machines.) I've run mage -cc, and renamed the '2.0' directory to '2.0x' to ignore its presence. Add/Remove Programs still shows it, and clicking Change/Remove pops up a window for a moment, but otherwise does nothing apparent. I've changed the installation path to be a network path instead of a website, and it still fails. The following is the error log: PLATFORM VERSION INFO Windows : 5.1.2600.131072 (Win32NT) Comm ...Show All
Visual Basic OCR - Optical Character Recognition
Hi Everybody, I was recently pursuing code that would allow me to read machine text off an image. The text will only consist of characters a-b, 0-9 and a few special characters (+,=,-,@,&). I have pursued a few third party OCR controls however all require licenses to be fully functional, would anyone know of any third party OCR controls that does not cost anything If not is there anyway i can build my own OCR control that will read machine text Thanks In Advance, TheDarkestShadow Okay cool, ill go check out the Office forums. I actually used the OCR in Microsoft Document Imaging (Start Menu>Programs>Microsoft Office>Microsoft Office Tools>Microsoft Document Imaging) and after ...Show All
SQL Server How to use the Microsoft OLE DB Provider for DB2.
I follow the steps: 1.In configure OLE DB Connection Manager dialog, I click New. 2.In Connection Manager dialog ,I choose Native OLE DB\Microsoft OLE DB Provider for DB2. 3.In Connection Manager dialog I click the "Data Links" button. Now I am on "Data link property" dialog. 4.On connection tab, I enter fmdb for data source, which is my remote database name. On Network section I choose TCP/IP Connection and set the right IP/Port. Uncheck Single sign-on and enter the user and password. Then comes the Database section. Database name fmdb for Initial catalog,"fmdbrun" for Default Schema, then what is Package Collection (My db2 database is in a AIX/RS 6000 box). 5.On advanced tab, I choose DB2/6000 fo ...Show All
Windows Forms Closing ChildForm in an MDI Application
Hi, I need assitance in closing a child form under certain circumstances. What I need to accomplish is when the child form opens it checks a value in the registry, if this value is absent I need the form to stop loading and return to the Parent from. How can I acheive this Here's my code so far.. <Code> namespace Mort { public partial class frmFuneral : Form { public frmFuneral() { InitializeComponent(); } private string myPath; private void frmFuneral_Load(object sender, EventArgs e) { CheckRegKey(); } private void CheckRegKey() { RegistryKey myKey = Registry.LocalMachine.OpenSubKey("Software\\Mort", true); string myPath = (string)myKey.GetValue("DBP ...Show All
SQL Server mysql limit equivalent
Hi, I need the equivalent for below mysql query : select *from test limit 5, 20 I know that the below is possible in SQL Server : select top 20 * from test where column1 not in (select top 5 column1 from test). But my problem is I want a generic solution wherein I will not be aware of the columns available within the table. i.e I need a equivalent query without using any of the column names Please advice Greetings. select * from (select *, ROW_NUMBER() OVER(ORDER BY t.column1) as seq from test as t) as t1 where t1.seq between 24*25 and 25*25 Is this best practice for "get page 25 with pagesize 25" http://search.msn.com/results.aspx q=bill&first=625 http://searchpalette.com/spalette/24/25/bill ...Show All
SQL Server Mirroring ASPState
Hello Does any one have any information on how to mirror the ASP.NET 2 ASPState database we have set the connection string to allow custom DB and failover partner but this is still not working. Regards Matt. Hi Kaloian, The problem that we are having is that the ASP.NET connection does not get re-routed to the failover partner after auto-failover. This is the connection string that i am using. <sessionState mode="SQLServer" sqlConnectionString="data source=Test; Failover Partner=Test2; initial catalog=Credit; user id=State;password=password" cookieless="AutoDetect" timeout="61" allowCustomSqlDatabase="true" /> The databse ...Show All
Visual Basic Compiled app failing in InitializeComponent
I have created a WinForms application that runs fine in Debug mode, but when I deploy it to a server, it fails when it executes InitializeComponent while loading its first form. How do you debug something like this if the .NET Framework is not installed on the server, the application wouldn't run at all (AFAIK). Perhaps some UI Component is not fully supported on a particular OS (it can happen but do not quote me) what OS is this server you are running the application on how are you deploying it As suggested, if you can, post the stack trace - would give us more help (hopefully) ...Show All