Kent Liu's Q&A profile

• SQL Server Problem with a proxy

  Hi i have a problem with a proxy and i don't know how to resolve this So, i want to run a SSIS package so i follow this http://support.microsoft.com/kb/918760 However, the package fails and i have a error message which tell me that i can't get proxy's data for proxy_id = 23! If someone has the solution please help me!! ...Show All

• Windows Forms Appending rows to a bindingsource?

  Bascially, Im tring to catonate to a bindingsource. Im tring to display all rows from two different tables with a very similar table definition. So I want to load all rows from table a, then add all rows from table b ( using a query of course ). How can i do this thanks, -stellar Hi, You should use Merge method from DataTable or DataSet as per your need. Here is an example, private void MergeTwoTableAndDisplay() { SqlConnection conn = new SqlConnection (); conn.ConnectionString = "data source=localhost;initial catalog=Northwind;integrated security=SSPI;persist security info=False;packet size=4096" ; conn.Open(); SqlCommand cmd = ...Show All

• Visual Basic How to use FindWindow, SetForeGroundWindow and SendKeys

  Hi All, I need to send two keys (" " and {Enter}) to a security warning in an Acrobat Window from a VB.NET application. Here is the function I use : Private Sub SendAcroKey() Dim HWND As IntPtr HWND = FindWindow("Adobe Acrobat", vbNullString) SetForegroundWindow(HWND) SendKeys.SendWait(" ") SendKeys.SendWait("{Enter}") End Sub But I can't get FindWindow() to work properly, it always returns "0". I guess I'm not giving the good parameters, lpClassName and lpWindowName, but I dont now how to get the right ones. So here is the question : How can I know the lpClassName and lpWindowName of a security warning in Adobe Acrobat 7 professional I really ...Show All

• SQL Server restoring 2005 backup with 8.0 compatability mode on 2000 - help

  Hi, I have a database that is in the SQL Server 2000 compatability mode on my SQL 2005 server. I am trying to restore a backup of this database on my SQL Server 2000 database on another server and keep getting strange messages. First trying Red-Gate and then plain SQL Server with no luck. It seems as I remember that the 7.0 and 2000 compatibility issue between backups did not arise when the compatibility mode was set to 7.0. Is this "planned" behavior or an "undocumented feature" Anyone else have success doing this Thanks, John Campbell Hi John, If you mean you're trying to restore a MSSQL 2005 database backup (regardless of the compatability mode of the originating ...Show All

• Visual Studio 2008 (Pre-release) UdpSample not Working with July Ctp

  I tried the TechnologySamples_Extensibility_Transport_Udp.zip from the official Samples. It isn't working out of the box. There is a third listener Createt with an empty context.ListenUriBaseAddress. If i intercept the UdpChannelListener Constructor, and set that empty Iri to some default it is working. Where does this empty uri come from This fix didn't make it into the July CTP. You need to modify the UdpChannelListener ctor and add the following to the end of it. This empty URI comes from the client-side listener under Composite Duplex. Uri baseAddress = context.ListenUriBaseAddress; if (baseAddress == null ) { if (context.ListenUriMode == ListenUriMode .Unique) { ...Show All

• Visual C++ packet filtering API not working

  hi all i want to make the packet filtering using packet filtering api,one api is not working it alwasy fails i dont know why may be bcos if ip adress. the code is given below. INTERFACE_HANDLE ihandle;  if(::PfCreateInterface(0,PF_ACTION_DROP,PF_ACTION_FORWARD,false,true,&ihandle)==NO_ERROR)  {   AfxMessageBox("Step 1 Done");   if(::PfAddGlobalFilterToInterface(ihandle,GF_FRAGMENTS)==NO_ERROR)   {    AfxMessageBox("Step 20 done");    if(::PfAddGlobalFilterToInterface(ihandle,GF_STRONGHOST)==NO_ERROR)    {     AfxMessageBox("Step 21 done");     if(::PfAddGlobalFilterToInterface(ihandle,GF_FRAGCACHE)==NO_ERROR) &nbs ...Show All

• SQL Server Unary Operator Column in Accounts Dimension Behavior

  I set up a cube with 4 dimensions: Time Account Department Project and 1 measure Amount Without adding the unary operator to the Accounts Dimension, I am able to drag Project to be rows and Amount to be column to break up the amount by project. Once I added the unary operator column to the heirarchy in the Accounts Dimension, I have to drag the Accounts Dimension first, followed by Project to see any breakdown at all. I couldn't do Project, then Accounts. Is this the expected behavior Using + unary operator did not resolve the error I am getting. The results appear correctly when I have a custom member aggregation formula defined. Otherwise it does not return the correct resu ...Show All

• SQL Server Simultaneous DB access

  I have C# Express and the SQL Express Management Studio CTP installed. So far, I've been forced to disconnect from the server in one app to connect to it in the other. I understand there is something around a 4 connection limit in SQLServer Express, so I don't see the problem. During one of these episodes, SQL Mgmt Studio hung while opening DB properties, then the SQLServer service couldn't be stopped. Now the DB can't be opened even after a reboot. Help Hi Al, I'm not sure about VSExpress, but what you wish to do is certainly OK with VS2005Pro. I use VSPro and SqlExpress, and there is no problem using SqlExpress in normal Server mode. Its achieved by setting your Data Connection to the Server databas ...Show All

• Visual C# Intellisense gone...

  Intellisense gone... The only change lately has been the use of bookmarks....they have also vanished.  This is only in one project. If I create a new Windows app...it's fine. TIA Please take a look at Microsoft Connect and if there is no solution for you, please send a bug report. You can also contact Microsoft Support for any further support for Visual Studio. http://connect.microsoft.com/feedback/default.aspx SiteID=210 ...Show All

• Visual Basic how to find the highest value in a list

  Hello, I have two lists: one with playernames and one with the points of the players. Dim playerNames As List(Of String) playernames.Add("One") playernames.Add("Two") playernames.Add("Three") Dim playerPoints As List(Of Integer) playerPoints.Add(20) playerPoints.Add(30) playerPoints.Add(10) I would like to find the name of the winning player, so with the highest points (here player two). I've tried so many things, but I can't find it. Does someone have an solution Thanks! Do you need to use an array as you could do it like this with a SortedList: Dim players As SortedList( Of Integer , String ) = New SortedList( Of Integer , String ) players.Add(20, "one&quo ...Show All

• SQL Server How do you get the last modified date column in SQL Management Studio

  In 2000, the last modified date was show as a column when viewing the various database objects. So, after a long off-line session with a copy of a database, you could sort the query list, by last date modified, and script the recently changed queries to a file. It was very easy to see exactly what was changed recently. How do you do this in 2005 thanks lkh wrote: One other thought....SQL Server Service Pack 2 will be released soon. It has a new feature, Custom Reports, that will allow you to create a report based on any system object with the columns you want sorted the way you want and attach it to the node you want in Object Explorer. Books Online will have How-to infor ...Show All

• SQL Server Rank function

  hello, this the MDX for my calculate measure in AS2005 Rank([SL_Territory].currentmember, order([SL_Territory].members,([Measures].[Sales],[SL_InvoiceDate].currentmember), bdesc),[Measures].[Sales]) the problem is...I get the Rank=1 on the Grand Total instead of on one Territory dimension as it should be. Am I doing something wrong Thx Since I'm still not sure how your usage of Rank() works, here's a sample Adventure Works query using Rank(). Note that the states are ranked correctly (1..4), but there seems to be a bug in the Rank() of the [All] member, which should be 0: >> With Member [Measures].[SalesRank] as Rank ([Geography].[State-Province]. CurrentMember , ...Show All

• Visual C# Unable to update the dependencies of the project

  I have had this error every time I try to check my program into source control after making changes. The project builds and works fine until I check it in and check it back out then it won’t build. I have deleted the setup project and built a new one only to have the same problem after checking it into source control. It also givs me a warning that " Assembly ' FolderName\FileName.exe ' is incorrectly specified as a file. Any suggestions would be helpful. Me too - I just got this problem with a project I have been working on for a couple of months. Having found this thread, I removed the setup project and was just about to start another one from scratch, when I tried reloading it (File, Add, Existing Pr ...Show All

• SQL Server Transfer database from SQL Server 2000 / 7.0 to SQL Server 2005 Express Edition

  I want to transfer a database located on a older SQL server version mentioned above to an SQL 2005 Express Edition. On a SQL Server 2005 Standard Edition, I did this with the Copy database wizard. But when I try to specify an Express Edition as the destination server I get message telling me that no sql agent is running on the destination server and here I stand What can I do in in this case Thanks for any help Armin If not you can either perform a BACKUP & RESTORE statement to get that backup, also make sure to transfer the logins from that server as the logins will be mismatched once you have the copy on destination server. Also you need to run the SQL Service account on your local machine ...Show All

• Smart Device Development Is way to Override the Disabled appearance of ListView Control

  Hi all, is it possible for me to override the appearance of the ListView Control when its enabled property is set to False (disabled) I guess I need to change the colour as when the ListView Control is disabled, its very hard to actually see what value is selected if there are only two entries in the ListView. Thanks Try this Listview.Enabled = false ; // Disables listview // suppose you want to select the 3rd item in the list view.. . now write Listview.Items[2].Selected = true ; // This will highlight the 3 rd item as selected ( with blue color) in the listview Regards Ratheesh ...Show All