Sandman13's Q&A profile

• SQL Server Creating a double entry book keeping system

  Can anyone please tell me how to create a basic double entry book keeping system database using SQL Server or Access. I need to know what tables amd fields I need to create, and what relationships need to be defined. I just need to know the db structure here. Also how should I go about designing the forms ( I use visual Basic 2005 Express and SQL Server 2005 Express, and Access 2002 ), the front end user interface for creating journal entries, how should I display the ledgers, and how do I calculate the totals for the ledgers, because we also need to take into consideration the opening and closing balances as well. I tried a lot using Acc ...Show All

• Visual Studio Tools for Office OUTLOOK ADD-IN

  I have Visual Basic 2005 And I try develop Outlook Add-In. MAIN project = SHARE ADD-IN (taken from template) Inside the project there is another project OUTLOOK ADD-IN (taken from template VSTO) I did it  because I can not access all Outlook objects from SHARE ADD-IN project ) I need to call from MAIN project  --->  procedures  in OUTLOOK ADD-IN project How can I do it in multi-project invironment  Thanks in advance   I'm not sure if I correctly understood your scenario, but I hope I got it right.... Here's the scenario that I think you're trying to achieve: ...Show All

• SQL Server Variables Window

  Hello All, I am wondering if someone can shed some light on how to display "Variables" window in Integration Services. I am trying to add a new variable by clicking SSIS menu, and choosing Variables. However, the Variables window never showed up. Is there some property settings that I need to set before I could view the Variables window Your help is much appreciated! -Lawrence There shouldn't be. It should be there. Try right-clicking on the control-flow surface and select "Variables..." -Jamie ...Show All

• Software Development for Windows Vista Problem passing parameters from workflow to custom activity using dynamicly compiled xoml workflow

  We have created a Win Form app that programmatically builds a workflow. It contains one sequential workflow object, and has activities implemented in a separate DLL. The generated workflow definition is then serialized out to a xaml file. We then compile the xaml definition to an assembly, and executes the workflow using dharmas compiler sample. The workflow library is a class library wrapper for the runtime, and both the workflow library and activitiy library dlls are strong named and placed in the GAC. The dynamic compilation and execution all works fine until we try and pass parameters from the ...Show All

• .NET Development FTP usage

  Hi. Using .NET 2.0 and its the first time im using the FTP protocol in development. I am trying to issue a few commands, firstly it works fine such as listing a directory however if i wish to disconnect from the server using, lets say "QUIT" or perhaps I wish to upload /download a file, I get an error saying: "This operation cannot be performed after the request has been submitted." Am I doing something wrong or must I create another FtpWebRequest object per command Other thing is, if i explicitly specify a method with a NEW FtpWebRequest, a command to "QUIT" or even "CD dir " it gives me an exception that the method is not sup ...Show All

• Visual Studio Express Editions Replacement of Winsock in Visual Basic 6?

  Hello Microsoft. Is there anyway to make any replacement of the Winsock Protocol in Visual Basic 6   I find that the WebRequest class and associated System.Net classes are great. I would recomend that you learn to use the Object Browser. The ObjectBrowser is your friend!!!!! ...Show All

• SQL Server Could not load file or assembly SQLXMLBULKLOADLib

  Greetings, I'm in the process of migrating several SQL Server 2000 DTS packages to Integration Services packages. One of the old 2000 DTS packages used the SQLXML Bulk Loader component. In order to use the new SQLXML 4 COM object in my Script Task (to initiate the Bulk Loader using .NET code) I've used the tlbimp.exe tool to create a .NET wrapper DLL. I've placed the DLL in the appropriate directory (C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies), successfully added it to my project (with Intellisense working), but when I run the package it fails with the following error: Could not load file or assembly 'SQLXMLBULKLOADLib, Ve ...Show All

• Visual Studio Changing FileReferences to ProjectReferences in .csproj files when compiling Multiple Solutions

  First, I would like to thank the MS-Build Team for being pro-active in providing support to our MS-Build issues. Here's what I am trying to do - What I have I have 3 VS 2005 C# solutions (A,B,C). Each of the solutions contain 4 csproj files (1,2,3,4) No VS Project is contained in more than 1 solution. VS projects in one solution have file references to assemblies emitted by VS projects in other solutions (e.g., A1 has a file reference to B2. What I want to do We have a Continous Integration environment, and we would like to "integrate" new code as and when it becomes available. Therefore, I would like all the file reference ...Show All

• SQL Server URL access

  Hi, Is it possible to send the parameters from a report in an url, if the report is based on a cube With a normal database this is possible. But how can I do this for a CUBE This is what I got, but it won't work. http://server.url.be/reportserver /testCUBE/CUBE02&rs:Command=Render&Budgethouder=dummy You shouldn't have any problems with passing parameters via URL just because you are using AS as your datasource. What is the error you are getting ...Show All

• SQL Server SMO Connection String conversion

  Hi, I am using SMO in my application to retrieve data from SQL Server in order to display it in the UI (such as DB list, tables list, etc.). Eventually the user has a connection definition screen, in which he inserts his data. The thing is that in the background my application needs to use this data to connect via OLE DB. Is there a way to convert the connection string generated by SMO to an OLE DB connection string Thanks. Hi, if you use the Microsoft.SqlServer.Management.Common. ServerConnection to create a server connection, you can use the constructor with the SQLConnection class and its appr ...Show All

• Visual C++ Timing the compiler

  The Visual C++ 2003 linker has an undocumented /TIME option which reports how much time the linker has spent on each phase. Is there a corresponding option for the compiler   It would be helpful to know exactly how long each file took to compile.  I have a 146-file project taking nearly 30 minutes to build; it would be quite helpful to find out where the delays are. We do indeed use templates a lot - the chief use is reference-counted shared pointers from Boost. Would VC++ 2005 be significantly faster than 2003 for this   By "significant" I mean at least 50 percent faster with no m ...Show All

• Software Development for Windows Vista Configuration

  I setup my host to do some logging using enterprise library 2.0. Everything works fine when I log from the host, but my log calls in the workflow don't produce any output. Does workflow use a seperate config than the host process Workflow uses the same configuration files as the host process. What is the version of your workflow assemblies You can find the workflow assemblies under <system drive>\Program Files\Reference Assemblies\Microsoft\WinFX\v3.0 ...Show All

• Visual Studio 2008 (Pre-release) Error Generating Client Proxy with FEB CTP

  Hi, When trying to generate the client proxy using svcutil I get the following error. Unable to cast object of type 'System.ServiceModel.Configuration.ClientSection' to type 'System.ServiceModel.Configuration.ClientSection'. Anyone have any ideas. Cheers Sohail I am not able to repro this problem on my machine,so we are thinking there may be some installation problem on sohali machine sohali going to reinstall FEB ctp and will try to generate proxy again -Thank you Madhu ...Show All

• Windows Forms Validating event not fired

  I have a form with a number of textboxes, an errorprovider and a button. Each textbox has it's Validating event implemented like this private void TextBox1_Validating(object sender, System.ComponentModel.CancelEventArgs e) { if(ValidID()) { ErrorProvider.SetError(this.IDTextBox,""); } else { ErrorProvider.SetError(this.IDTextBox,"Du skal angive et ID"); } } This works fine when I tab through the textboxes, the errorprovider  ...Show All

• SQL Server print from report manager in landscape

  I've thrown together a homegrown Reporting Services viewer that is basically a wrapper for a browser control. It will reside in our app alongside the Crystal report viewer until we have phased out Crystal. One of the issues i'm facing is that if i press the "Print" button in the manager's toolbar, it prints as if directly from the browser. Therefore, it ignores whether the report is landscape or portrait. I know that the users have the option to select landscape or portrait in the print dialog, but I don't want to add an extra step to our users who are comfortable printing directly from the Crystal viewer. Is there a way to programmat ...Show All