JVS's Q&A profile

• SQL Server UNION with the second set ordered

  Hi, I was trying to use the UNION construct to combine two tables. The second table was to be sorted before effecting the UNION. The first attempt was the following: SELECT emp_id , assigned_branch_id FROM employee WHERE title = 'Teller' UNION SELECT open_emp_id , open_branch_id FROM account ORDER BY open_emp_id The above was generating an error. I then tried SELECT emp_id , assigned_branch_id FROM employee WHERE title = 'Teller' UNION SELECT e . open_emp_id , e . open_branch_id FROM ( SELECT TOP ( 100 ) PERCENT open_emp_id , open_branch_id FROM account ORDER BY open_e ...Show All

• SQL Server Can't connect using specific UserIds and Passwords

  Folks, I'm brand new to MSSQL, I come from a DB2 background. I've installed SQL Server Express Edition on my WinXP (SP2) system. I'm able to connect to it from a command prompt using "sqlcmd -S CS288290-A\SQLEXPRESS -e". Now I want to connect using a specific UserId and Password. So I changed my "LoginMode" registry variable to "0x00000002" and restarted the service. But now when I issue "sqlcmd -S CS288290-A\SQLEXPRESS -U g2user -P g2pwd", I get error: Msg 18456, Level 14, State 1, Server CS288290-A\SQLEXPRESS, Line 1 Login failed for user 'g2user'. What am I missing Thanks. ...Show All

• Visual Studio Team System Recording Cookies?

  Hi, Serveral promotional blurbs about VSTS web testing tools mention " automatic handling of cookies ." (e.g., http://msdn.microsoft.com/vstudio/teamsystem/products/test/ ) Yet when I use VSTS to record a web test, the cookie from the site I am testing does not get automatically recorded. What does "automatic handling of cookies" mean if it does not mean that they get recorded automatically Do I have to create a custom extraction rule in order to get the cookie and include it in subseqent requests If so, do you have any walk throughs on how to do this Thank you in advance. I think VSTS is *great* tool ...Show All

• Visual C++ optimization issue with VC++ 6 SP6 compiler

  Can anyone explain the following behaviour I am using VC6 with SP6. The following code is producing different printf output if I use different optimization options in release program. It seems that the difference is caused by initialization of the member variable called 'packlength'. If I replace it in function max_length() with constant then program produces correct output. Correct output is also generated when I build this program with Microsoft Visual C++ .NET 2003. typedef unsigned int uint; typedef unsigned long ulong; typedef unsigned __int64 ulonglong; #define BLOB_PACKET_MAX_LENGH(arg) ((ulong) (((ulonglong) 1 << mi ...Show All

• Visual Studio 2008 (Pre-release) How to change property values twice or more times ??

  // seems that dlinq allows to change property value only once, the same happens when object is created not only loaded from database // is there any way how to make it work //for tests i used the standard dlinq sample database using System; using System.Data.SqlClient; using System.Query; using System.Data.DLinq; using Microsoft.VisualStudio.TestTools.UnitTesting; namespace LINQConsoleApplication1 { class Program { static void Main(string[] args) { SqlConnection conn = new SqlConnection(@"Data Source=MODA;Initial Catalog=C:\PROGRAM FILES\LINQ PREVIEW\DATA\NORTHWND.MDF;User ID=mike;Password=*********"); DataContext db = new DataC ...Show All

• Visual C# How can you scroll in a panel in Visual Studio

  Usually there is an event that is created when you have auto scroll turned on, and you can call that event to adjust image displays and such... So if you have a Panel named panel1, and that panel has autoscroll set to on.... How can you get to the scroll event handler Visual Studio says that panel1.Scroll does not exist... so I cannot add an event handler there. I am using VS 2003 If you create a class that derives from the panel control, you gain access to it's base class, the ScrollableControl. You can then override WndProc event handler, and trap the windows messages. If hscroll or vscroll have been ...Show All

• Visual Basic Is it possible to generate a solution with a class library in it using codeDom?

  Hi, I am writing some sort of codeGenerator and  it would be perfect if i could also generate a class library project or solution rather than generating only the classes. Is this possible Cannot find an example anywhere. I have seen code generator that they do this .How do they do it Just for clarity i am NOT refering to generating a dll or executable I am refering to generating a class library project or solution . NOT ONLY THE CLASS. Could you please help thanks a lot a usual . VBJUNKIE Thanks a lot for your help  and link I have seen that book and i will get it . Thanks again vbjunkie ...Show All

• Visual FoxPro how do i get a result in 4 tables in SELECT- SQL command?

  good day to the experts... My transaction has 4 tables, 1 for recording the amount of loan, 1 for check payment, & 1 for cash payment, and the vendor table. Below is the tables and its corresponding fields *// vendor table 1 (FIELDS=acct_no, acct_name,address, totalamount) * // loan table table 2 (FIELDS=or_number,acct_no, loanamount, or_date) *//cash payment table ltable 3 (FIELDS=child_numb, or_number,acct_no, amountpaid, pymntdate) *// check payment table 4 (FIELDS=child_numb, or_number,acct_no, checkamount, checkdate, pymntdate) Every end of the month I wanted that the summary of loans, and its corresponding paym ...Show All

• SQL Server Remote execution of package via dtexec and "Access Denied"

  I am finishing a port of a project that was done with RS2000/AS2000/DTS2000. The cube process is triggered remotely by a Korn Shell script from Services for Unix that runs a DTS package: dtsrun.exe /S "$ANALYSIS_SERVICES_HOST" /U "$ANALYSIS_SERVICES_USER" /P "$ANALYSIS_SERVICES_PASSWORD" /N "$PACKAGE_NAME" I have finished porting the AS and RS parts to their 2005 equivalents and now I am trying to get the cube processing converted. I have built a SSIS package that processes the cube and I have deployed it to the SQL Server in MSDB. When I am logged on to the SQL Server box directly, I can execut ...Show All

• .NET Development Where's the Web dev forum?

  Like the title says... where's the Web dev forum for us ASP.NET monkeys I think some people forget or do not know there are two specific sites for specific .net development I would always consider http://www.asp.net as the primary asp.net forums And I would always consider http://www.windowsforms.net  as the primary windows forms forums. Those site have been there since day one. These I guess would be everything else. ...Show All

• SQL Server FTP TASK PROBLEM

  Dear all, I have problem in my ftp task.For example, I create two variable remotepath and localpath to set up remote and local path of ftp task. And the IsRemotePathVariable and IsLocalPathVariable is set to true. I create two funtions to retrun the pathvalue. The return value is like 'D:\A.TXT' , but in DTSX the varible value is changed to 'D:\\A.TXT'. So my ftp task fail. How can I overcome this problem Thanks a lot. Regards wen when the path value is changed to "\\" , the error is as bellow, Error: 0xC0029183 at FTP Task, FTP Task: File represented by "User::FTPPATH" does n ...Show All

• Visual Studio Express Editions To Correct a Existing Master-Detail Form - need FK_BindingSource

  Hi all, I am new in VB Express. I just tried to do my first Windows Application - Developing a Client Database Application: Creating an updateable master-detail data-centric application by using the following 2 tables: "Person" Table: Person_ID, First_Name, Last_Name, Street_Address, City, State, Phone_No. There are 3 persons in this table. "Book" Table: BOOK_ID, Book_Title, Author_ID. There are 12 books and 3 Author_IDs in this table. I created a Master-Detail Form with MyDBdataset, PersonBindingSource, PersonTableAdapter, PersonBindingNavigator, BookBindingSource, BookTableAdapter and PageSetupDialog appeare ...Show All

• Visual Studio Express Editions e.graphics in wrong area.

  I have the following section of code that is obviously, even to me, not quite right. The Error message is that the e.graphics iss not a member of 'system.EventArgs. Basically im trying to draw a cirle on a userforn once the value in a textbox is added or changed. Private Sub TextBox1_TextChanged( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged e.graphics.DrawEllipse(Pens.Black, (bolt1_x + TextBox1.Text), bolt1_y, BoltDiameter, BoltDiameter) End Sub Thank you in advance for any help. To draw on your form, you need to handle the Paint message. When your text is chang ...Show All

• Visual J# method to cast to/from ubyte[]/byte[]

  Hi; I know I can copy a byte array to a ubyte array using System.Buffer.BlockCopy. But since the actual data is identical in both arrays, and I have some large arrays, is there a way to just case a byte[] to a ubyte[] thanks - dave This really is a great help! Thanks to everyone for the posts; all the explanations were very concise and informative! ...Show All

• Windows Forms [Bug report] Disabling ToolStripMenuItem

  Hi all, I think I found a small bug (or I supposem it is a bug ^^) in the ToolStripMenuItem class. If a particular item (parent) is disabled (setting Enabled property to false), every child is obviusly not accessible but, if a shortcut was created, it's possible to access the (let's say) Click event handler definied... I suppose it depends on the fact that disabling a parent ToolStripMenuItem doesn't disable every child... unfortunally in this way, even if it's fine for common input (you cannot access to any child control), shortcuts can still be used... have I misdjudged this behave ...Show All