JohnGreer's Q&A profile

• Visual Studio Express Editions SQL Database Connection not open?

  Well here's a summary... I've been trying now forever trying to get my VB to connect and insert a new record into an SQL database.  I created a fresh VB form and added a SQL database named customers.  Created a table named address which contained firstname,lastname,address,city,state,zip.  I then created a data source using the wizard.  All this i guess is irrelevant as i can't get even a basic SQL string to insert a new record.  Here's the SQL string that i KNOW works because I executed it into the SQL pane: INSERT address (FirstName, LastName, Address) VALUES ('MyFirst', 'MyLast', 'MyAddress') That ...Show All

• Visual Studio Express Editions win32 application

  i have read abt this frm the forum and followed steps given in the following link : http://lab.msdn.microsoft.com/express/visualc/usingpsdk/default.aspx but still i am getting the following error: 1>c:\documents and settings\administrator\my documents\visual studio 2005\projects\test\test\stdafx.h(28) : fatal error C1083: Cannot open include file: 'windows.h': No such file or directory i am missing something . plz help Looking at http://lab.msdn.microsoft.com/express/visualc/usingpsdk/default.aspx, step 3 is the problem. You should add C:\Program Files\Microsoft Platform SDK for Windows Server 2003 R2\Include to include directori ...Show All

• SQL Server Failed to decrypt protected XML node

  Failed to decrypt protected XML node ... blah blah. Looks familiar, right Package Protection mode is : EncryptSensitiveWithPassword Package runs fine from within BIDS. Close package. Open package - asks for password. So far so good. When running from command prompt with: dtexec /File "C:\Program Files\Microsoft SQL Server\90\DTS\Packages\MyPackage.dtsx" /De mypassword Get that cryptography error. Doesn't happen for other packages... what can I be doing different/wrong Thanks, Nitesh Since your protection is only EncryptSensitiveWithPassword then only sensitive information will be encrypted, and my guess is that this package has bee ...Show All

• Visual Studio Team System Testing C++ unmanaged code

  My company uses unmanaged C++.  Is it possible to generate Test Projects that test raw C++   You know, pointers, stl, and all the basic stuff. I'm noticing that there isn't much support for unmanaged C++ in the areas of class diagraming, testing, etc.  Is Team System really the way for me to go if I can't use all the bells and whistles If anybody knows anything about testing C++ then please explain to me how to test the simple class below. class myclass {    myclass();    ~myclass();    void init( int val ) { m_ptr = new int; *m_ptr = val; }    int *m_ptr; } I know t ...Show All

• Windows Live Developer Forums Bonus Challenge

  I have read the e-mail about Bonus Challenge at 18:00. Decided to participate - and to make small, but useful (I hope ) app. At 24:00 I have completed the work. During this 6 hours I had time to drive from work to home, to have dinner, to read the last news, and of course to write code and test it. As a result: 15575 characters of code and 5 images. Extreme programming At 00:30 I have submitted it. BTW, question to admin - I hope it was submitted succesfully Web page said that all right, but still it will be better to receive confirmation to e-mail... The e-mail that I was used during submission is a-vas[at]hotmail.com If it's 't4im' ...Show All

• Visual Basic HelpCursor on Menu

  Hi all, I need to enable context sensitive help in my application. For this when user clicks on a menu item( "Whatis this"), i would change the cursor to a help cursor. I used system.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Help As this code did not help in changing the cursor, i modified the code to Me.Cursor = System.Windows.Forms.Cursors.Help This code indeed worked. But when i move the cursor over a item in the menu, it changes back to the default cursor. Can someone tell me a way by which the cursor would remain as a help cursor irrespective of the item the cursor hovers over. Thanks, Suga ...Show All

• SQL Server VBA IsError function in MDX with SQL Server 2005

  In SQL Server 2000 Analysis Services, we use the VBA IsError function to determine if a generated member name actually exists in the cube. See the following example... StrToMember ( Iif ( ISERROR ( StrToValue ( "[Start Date].[Month].[" + Format(Now(), "mmm yyyy" ) + "]" )), [Start Date].[Month]. Members . Item ([Start Date].[Month]. Members . Count -3). UniqueName , MemberToStr ( StrToMember ( "[Start Date].[Month].[" + Format(Now(), "mmm yyyy" ) + "]" ). Lag (2)))) I tried the same thing in SQL Server 2005 Analysis Services, but when I processed the cube, I got the following error: MdxScript(Freight Analytics Proto) (36, ...Show All

• SQL Server Using SMO to backup / restore a SqlExpress database

  Hi all, I have seen several threads on using SMOto backup & restore sqlexpress databases but am having trouble getting my code working. Does anyone have a snippet available Current problem is connecting to the sqlexpress database file Thanks, Nick Does this thread address your problem, or is there a wrinkle I haven't figured out yet http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=89754&SiteID=1 ...Show All

• Visual Studio Team System Backup Utility not working after TFS installed on Windows Server 2003 Std Edition SP1

  I have installed Team Foundation Server (single-server deployment) and Team Foundation client, on a Windows Server 2003 Std Edition with SP1 with all windows updates. Installation was successful, I can create projects etc no problem. This was a clean install on a DELL Poweredge 800 with RAID 1 SATA HDD. Prior to installing Team Foundation Server and Client I was able to use the Windows backup utility to successfully create an ASR backup and full backup of the server. After installinf TFS I find the backup utility fails with the following error: Error returned while the creating volume shadow copy: 80042301 After ...Show All

• Visual Studio Express Editions Progress bar

  I am currently makeing a web browser in VB express and at the bottem i wish to have a progress bar . i have the bar in place .... but i need a script or the code to get it to tell the user how much the browser has loaded. Also does anyone know how to make a tool bar ... e.g. File | Edit | veiw | Help etc. I would be soooooo grateful ... thanks a bunch Rhys Durham Hi lildotti, look, for the tool bar, or menu, you select MenuStrip from the toolbox(to view toolbox, click View in the main menu-->Toolbox)... Now regarding the progress bar, use the following code on your form where you have&n ...Show All

• SQL Server Sign a document by SmartCard on the .NET client and verify on the SQL 2005 server

  Hi! I'm working on the following application: In the client application (written in C#) an user signs a document by private key, stored on chip card. Signed document and the signature are stored into database on SQL 2005 server. There is my client code for demonstration: Client application sample: System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection("Data Source=localhost;Initial Catalog=Test;Integrated Security=True"); conn.Open(); try {    CspParameters csp = new CspParameters(1, "Schlumberger Cryptographic Service Provider");    csp.KeyNumber=1; &nb ...Show All

• Visual Studio error after instaling VB studio 2005

  hi i,m geting un error . visual studio common IDE package failed to load, also other packages that are failed to load, when i instaled the beta 2 (after uninstaling the beta 1 following the exact instructions) all whent ok in the instalation, only when i start the program i get the error i mentioned. any help thank you Hi evryone to solve the error in the IDE microsoft has posted a link with clean un tools http://lab.msdn.microsoft.com/vs2005/get/vsbeta2installissues/default.aspx#packageloadfailures daniel ...Show All

• SQL Server Upgrade Desktop Engine (MSDE 2000) to standard edition 2005

  While reading through books online I found that the supported upgrade for Desktop edition (MSDE) 2000 is to SQL Server 2005 workgroup and express edition. I am looking at upgrading just the database that resides on Desktop edition (MSDE) 2000 to SQL Server standard edition 2005. Is that supported I can uninstall MSDE 2.0 and install standard edition all I need is a way to upgrade the database tah use to reside on MSDE 2.0 This setup-based upgrade path is not supported up through and including the June CTP. At RTM we will support setup-based upgrades from MSDE to SQL Server 2005. You can attac ...Show All

• SQL Server TRY-CATCH question - Errors of severity 10 or less

  According to the articles that I've read, errors (i.e., warnings) with a severity of 10 or less DO NOT trigger the CATCH block.  And none of the sample code that I've seen check for those errors. So, is it safe to ignore those errors   Or, should I be checking for them Hi Richard Yes, it is safe to ignore errors with severity 10 and under. You're correct: TRY...CATCH doesn't handle errors with severity 10 and under. This is because errors with severity 0 through 10 are informational messages and not really errors. The Database Engine does not raise system errors with severities of 0 through 9. Mess ...Show All

• SQL Server Multilingual Support in Analysis Services

  Hi Currentely i am using analysis Services with SQL SERVER 2000 OS:- Windows 2000 Server Datasource:-Oracle We need to show the data in the cubes for multiple countries. But we are not able to show the data for diferent languges at the same time becoz in windows 2000 default language on the server can be set to only one language and the data in the cube can be shown in same language Ex Let say we wud liket see the data in the cube for Russia and turkey on the same server.If we set the default language of the server as "Rusia" or "Cyrlic" We are able to see data for Special Russian cha ...Show All