Error installing SSIS's Q&A profile
Visual Studio MSSCCI example
Hi, somebody can help me please I'm developing a Source Control Plugin for Visual Studio 2003. I've written this code, and it doesn't work. Somebody can tell me why dosn't work Or better ... Somebody can pass me a working example This is a lot of important for me!! Thanks for all. This is a part of my implementation. When I start, I perform the following actions. 1. Open a project in VS 2003. 2. Choose the option: File --> Source Control --> Change Code Control ... In this point the IDE calls the SccInitialize Function, then the SccSetOption function, and finally calls SccOpenProject function. After cal ...Show All
Visual C# how can i see the real table name??
when i use DataAdapter to fill a dataset,but the real table name in original database has been changed,for ex: it will be changed as" table" ."table1"....and so forth.. can i get the real name of the table and how could you tell me Now I don't know what are you looking for. If you need to see the tables in database you can use system views for that, for example: SELECT * FROM INFORMATION_SCHEMA.TABLES If you alway know that table will begin with some string 'table', than you can make some filter from previous view and see what is the latest table that you need. But it will be better to use view. ...Show All
SQL Server Urgent! Trigger problem!
I have the follow trigger attached to table [VoucherDetail] and I want to update table RecAccount when there is change in [VoucherDetail]: Create Trigger [dbo].[tr_Account] ON [dbo].[VoucherDetail] AFTER INSERT, UPDATE, DELETE AS BEGIN Declare @BalanceDiff decimal(18,8), @AccountID int, @RecDate DateTime, @MonthStart DateTime, @MonthEnd DateTime -----------Handle INSERT---------------- IF EXISTS(Select AccountID from inserted) BEGIN Set @AccountID=(SELECT AccountID From inserted) Set ...Show All
SQL Server Import data from Excel or text
How do I import data from an Excel or text file There are a couple of different options here: Move everything to a text file and import using the BCP Utility. You should check out the following topics in Books Online: http://msdn2.microsoft.com/en-us/library/ms162802.aspx http://msdn2.microsoft.com/en-us/library/ms175937(SQL.90).aspx Link the files to Access and use Access' Export functionality to move the data to SQL Express. I've disucssed this in another posting in this forum. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=292570&SiteID=1 Regards, Mike Wachal SQL Express team ...Show All
SQL Server The version of the linked measure group on the remote instance has changed
Hi, I get this error: The version of the linked measure group, with the name of 'Currency', on the remote instance has changed... We synchronize the cubes from server A to B. The error appears after a few hours on server B (the production system). Processing the Curency cube (part of a linked measure group) solves the problem. The problem doesn't occur on server A. Any ideas Chris This construct is a result of the migration from SSAS 2000. A “Base” cube and “Currency” cube are combined together as a new virtual cube “BaseWithCurrency”. In SSAS 2005 we have the two cubes (Base and ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Is there any way to access the mixed audio result by DirectSound?
I want to get and save the mixed data by DirectSound. Is there any method to do this I guess, the way maybe access the primary buffer, but how to do in detail Thanks! There is no way to get the final mix back from DirectSound. ...Show All
Visual Studio 2008 (Pre-release) <?Mapping?> fails after upgrade to beta 2
To use a custom panel Foo.Bar.CustomPanel in XAML, I do the following: < Mapping XmlNamespace="foo/bar" ClrNamespace="Foo.Bar" > <Window xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:foobar="foo/bar" ... <foobar:CustomPanel .../> After updating to WinFX beta 2, this no longer works. I get the following error: Error 5 'CustomPanel' tag does not exist in XML namespace 'foo/bar'. Does anyone know how to use a custom class in XAML in beta 2 I'm probably not looking in the right places, but I ...Show All
Visual C++ what is the L before a string mean?
I'm new to .net 2005 and saw this generated code this->btnUpdate->Name = L"btnUpdate"; What does the L mean before the "btnUpdate" string I've tried looking everywhere on the net for an answer with no luck. thanks Being more specific, prepending a string literal with L makes the literal of type const wchar_t*, as opposed to const char*. ...Show All
.NET Development The connection's current state is Closed??
Hi all, I'm trying to use a sqlDataReader to load data into a DropDownList on a .aspx page, but get the following error: Server Error in '/YLCPDTdb' Application ExecuteReader requires an open and available connection. The connection's current state is Closed. But havn't I opened it with the conn.Open(); statement Here's my code: private void Page_Load( object sender, System.EventArgs e) { / Load country names into countryCboBx try &nbs ...Show All
Visual C++ VS 2005 Compile issue
Hi, I just got Visual Studio 2005 up and running and tried using it on a project that I have been working on in VS2003. Got a lot of compile errors. One that comes up quite frequently has to do with some generated code within InitialzeComponent(). For example a button click event line such as, this->btnRunSim->Click+= new System::EventHandler(this, btnRunSim_Click); The compiler fails on the second argument, tells me that I have to replace it with a couple of scope resolution statements, , &nameOfTheSolution::NameOfTheForm:: and then the name of the button, in the above case btnRunSim_Click. I use the conversion feat ...Show All
Visual Basic Cannot open existing form in Designer HELP! - VB 2005 Express Edition Beta
This is so aggravating because I'm sure it's a simple thing! Using the new Visual Basic 2005 Express Edition Beta. Created a project, form, controls, etc. Worked great. Love it, compiled perfectly. Saved everything, closed the program, went to bed. Woke up, opened the project, but now CAN NOT open the form (form1.vb) in Designer mode!! I can open the code, it's all there, exactly as I left it, but cannot get back to the designer mode to (easily) add more controls to it! F7 just opens the code, right-click just gives me code option, not designer option. This is amazingly fr ...Show All
Smart Device Development Basics of emulator connectivity with database,Internet and desktop
Hello Friends i am newbie in mobile development world,i have to peform following tasks connection of SQL Mobile with Sql2005 ,present on desktop my project requires webservices,so i need to connect web service on my local machine and on Internet i launched Active SYnch from Desktop,it detects All ports likr COM,USB etc,but i dont know how to connect it with my Emulator,my questions are: i am using standalone PC,means it dont have any ethernet card and internet is connected via Dialup: how to connect make connection between Sql2005 and SQL Mobile will i need to transfer my .SDF files on emulator first and then make connect ...Show All
Visual Studio Express Editions Massive iostream errors
Hey, i'm kinda new to Visual C++ Express and i'm having a problem when I include iostream. I've installed Platform SDK and this is what I compile: #include <iostream> using namespace std; int main(){ cout << "Hello" ; return 0; } I get tons of errors from this: ------ Build started: Project: empty_project, Configuration: Debug Win32 ------ Compiling... 2.cpp C:\Program Files\Microsoft Platform SDK\Include\stdio.h(103) : warning C4229: anachronism used : modifiers on data are ignored C:\Program Files\Microsoft Platform SDK\Include\stdio.h(104) : warning C4229: a ...Show All
SQL Server import tool
I was looking for an import tool that will import text, excel and access files into sql server express Does anyone have any suggestions Thanks Tom Tom, I'd like to import a .csv file as well. Do you know for certain that studio express doesn't have the ability I can't find it or references, so I just don't know if I'm looking in the wrong place or it can't do it. Have you found documentation stating that it can't Mark Kuether ...Show All
Visual Basic Reading a "text" File
Im trying a read a "text" file that is a storage file for a proprietory software package. I can open the file up in notepad and read it all fine, all the data is there and visible in a plain text format, and i can also import the file into excel or basically anything else.. My problem is that when i attempt to read the file into a VB 2005 richtextbox, or textbox it won't read the whole file. (doesn't matter if i use read, readtoend, or readline with peek etc) Has anyone come across something similar to this is there a charactor in my text file that cause the reader to think its finished Any thoughts would be appreci ...Show All
