Long Yan's Q&A profile
SQL Server RS2005 Multiple Parameters
Hi I'm new to RS, I've got SQL2005 installed and I'm trying to use the multiple select report parameter. I'm using a report filter to = database.field IN =Parameter.value(0) etc and even though I'm select more than one in the drop down it's only returning values for one of the options! Helps what else do I need to do Thanks! ...Show All
SQL Server SSMSE Cannot show requested dialog
In Database Properties | Permissions when I highlight a "user or roles" and click "Effective Permissions" I get an error dialog as indicated below. Given that this is beta software, is it a known bug, or is it something I'm doing John =================================== Cannot show requested dialog. =================================== Could not load file or assembly 'file:///C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\C ...Show All
Visual C++ Parameterized type as arg to function template specialization
I want to specialize a method in a class template using a parameterized type. The code below is only meant to show what I'm after. Is there a way to code this, or is it unsupported template <class T> class Foo { public: void goo(void); }; template <class T> class Hoo { }; template<> void Foo<Hoo<T> >::goo(void) { } As far as I am aware, you cannot specia ...Show All
Visual Studio Express Editions Platform SDK wont work with VC++ Express
When i try to make a new project it tells me The following error had occured during XML parsing File: C:\Program Files\Microsoft Visual Studio 8\VC\VCProjectDefaults\CoreWin_Express.vsprops Illegal qualified name character Sounds like you made a mistake when you were editing the corewin_express.vsprops (when you were following brian johnson's steps). Some examples of people having similar problems are: http://forums.microsof ...Show All
SQL Server Windows XP SP2 (32-bit), Athlon 64 X2, SQL Server 2005
I upgraded from a P4HT processor/mobo to an AMD Athlon 64 X2 platform and now, I cannot install SQL Server 2005 on this new build. Does SQL Server 2005 install to this setup Getting Windowx XP 64-bit IS NOT an option given how little hardware and software support currently exists. There are two folders on the DVD: Servers and Tools. If setup is launched from the Servers folder you can install everything. If ...Show All
Software Development for Windows Vista Issue Moving Lab 04 (Beta 2) to VB
In order to try and have a workflow example running in VB (I tried the code examples that I got from http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=139052&SiteID=1 and they don't seem to build properly - could they be for ver.1.2 ) I've taken my favorite example, (StateMachine, 04) and I've tried to move it to VB. The actual code in the OrderWorkflows project was easy enough but the code in form1 from the OrderApplication project was ...Show All
Visual Basic getting application data folder!!
i want to know if there is a api for getting application data folder in windows xp!! like getsystemdirectory or getcurrentdirectory n does the path like( c:\documents and settings\"username"\local setings\.. )does this type of path varies for different windows versions!!:) Hi, For ClickOnce published application, I think IsolatedStorage is a better solution. .NET Framework 2.0 introduces a new Application scope that will move with your a ...Show All
SQL Server SQLSERVER 2005 Sept CTP BACKUP AND RESTORE Transactions
Problems with Backup and Restore using WIN XP service pack 2, and the September CTP Standard Edition of SQL SERVER 2005. I have a empty database which is using the full recovery model. To start with I run the following : backup database dbTO DISK ='E:\current\dbase.db' WITH INIT backup log db to DISK = 'E:\current\dbase.ldf' WITH INIT I then makes changes to my database, few inserts etc. Then backup the transaction log again using: b ...Show All
Visual C# blocked zip files using zipsharp library
I had a program created in C#.net that zips a folder up for me automatically. We used the zipsharp library and it seems to work great execpt when you try to open it using windows to extract the files from the zip. If you try to extract the files you get a message saying "windows has blocked access to these files to protect your computer" and it tells you you can fix this by right clicking the zip file and go to properties and check the "un ...Show All
Smart Device Development Full screen problem
Hi, I've got a problem on by Windows Mobile 2003 Application. I set my form to be fullscreen, which works fine. But when I show an other form, the bar at the top of the display (containint "Start", icons and time) shows up for a very short time. How can I avoid this Thank you! I verified that this problem is new to netcf v2. The only "work around" to prevent the start button (and top row) f ...Show All
Visual Studio 2008 (Pre-release) Width and Height values in markup
What are the values the Width of an element can take So far I know that you can write a number, Auto or *. Anything else I have the following code, I don't know how to tell the last element to fill up the space: <StackPanel Orientation="Horizontal"> <Separator Width="20" Margin="5,5,5,5" /> <TextBlock Text="Device Setup" /> <Separator Width="Auto" Margin=" ...Show All
Visual Studio Tools for Office Cell.Range catches more than it's supposed to?
Hi! I have a Word document with a table on it. The table consists of two rows and three columns. The first row contains headers and the second row contains bookmarks. There is one bookmark per cell but in the final application there can be zero or more bookmarks per cell. What i'm trying to do is to get a hold of the bookmark(s) in one cell. I iterate through the cells like this (C#): foreach (Microsoft.Office.Interop.Word. Cell c ...Show All
SQL Server SQL 2005 changing default port no from 1433
Just installed the 180 day trial of Enterprise SQL 2005 - does anyone know how to change the default port No - use to use Server Network utility in 2000 and a cycle of the SQL instance. From BOL: If enabled, the default instance of the Microsoft SQL Server Database Engine listens on TCP port 1433. Named instances of the SQL Server Database Engine and SQL Server Mobile are configured for dynamic ports, which mean ...Show All
.NET Development How to only copy access database data table in new table?
Hi to all, I'm trying to copy data from an access database using Microsoft PIA Assemblies. Hope I'm in the right place. The problem is that: I'm using Microsoft.Office.interop.access.DoCmd.copyObject method to copy tables from an Access database to another. Table A ---> Table B But there is no option to only copy data in a new table. The table B has all the columns of the A, but we just added a new column. And the method overwrite the o ...Show All
SQL Server Unsupported Datatype
I have an output column of DT_DECIMAL I want to assign values to this column so use SetDecimal I keep getting the following error Source Adapter [144]: Microsoft.SqlServer.Dts.Pipeline.UnsupportedBufferDataTypeException: Column data type is not supported by PipelineBuffer class. at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetDecimal(Int32 columnIndex, Decimal value) BOL lists it as a valid datatype and the column should ...Show All