salafa's Q&A profile

• SQL Server Encrypt and ??Decrypt Data??

  I Also Post this to SQL Server Security section no one aswered. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1047735&SiteID=1 Here is the post: CREATE TABLE TabEncr ( id int identity (1,1), NonEncrField varchar(30), EncrField varchar(30) ) CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'OurSecretPassword' CREATE CERTIFICATE my_cert with subject = 'Some Certificate' CREATE SYMMETRIC KEY my_key with algorithm = triple_des encryption by certificate my_cert OPEN SYMMETRIC KEY my_key DECRYPTION BY CERTIFICATE my_cert INSERT INTO TabEncr (NonEncrField,EncrField) VALUES ('Some Plain Value',encryptbykey(key_guid('my_key'),'Some Plain Value')) CLOSE SYMMETRIC KEY my_key OPEN SYMMETRIC KEY my_key DECRYPTION BY CERTIFICATE ...Show All

• Visual C# Intellisense

  Hi I made a reference to a class library in my project , but i cannot see it's members through intellisence. Is it because it's a console application Does intellisense work in console pplications BTW - the project compiles OK, and runs as expected. it's just that intellisense does'nt work. Any ideas TIA 1)No. 2003. 2) Yes. csharp. 3) Yes. As said, It compiles, and runs OK, using methods belonging to this type. 4) Have'nt tried it. 5) The namespace is the default one: ClassLibrary1(I'm just practicing here...) . I thought about namespaces. 6) I tried both. project reference or a reference to the dll itself. didnt work. 7) Yes i have. TIA ...Show All

• Software Development for Windows Vista July CTP breakpoint on state machine workflow can't open the workflow designer

  Dear all, I am trying to debug a state machine workflow in the July CTP of WF. I have set a breakpoint on the state machine workflow, but when I debug and the breakpoint is hit, I get: Yes, I am. Since making some other changes to the workflow, the first breakpoint on the workflow is now successfully hit, and the designer appears correctly. I have no idea why this is. However, when I press F11 to step, the workflow claims to be running, and the breakpoint on the first state within it never gets hit. There appears to be something fundamentally wrong here, but I don't know what it is. I still get: ...Show All

• Internet Explorer Development IE 7 RC1 Breaks Scripts

  I just installed IE 7 RC1 and my application scripts stopped working. An example: Dim IE, doc, pics Set IE = CreateObject("InternetExplorer.Application") IE.navigate "about:blank" Do until IE.ReadyState = 4: WScript.Sleep 50: Loop Set doc = IE.document doc.write("test test <img src='abc.jpg'> test") set pics = doc.all.tags("IMG") pics.length now returns 0 Help! Help! What should I modify Thanks in advance kk PS: It was still ok in the beta before RC1 Reinstalled IE 7.  Put a document.close() as suggested by someone in msnews after document.write() .  Didn't work either.  Hope someone from IE7 team is monitoring this.&nbs ...Show All

• Visual C++ Isue with Afx.h

  Hi I have C++ code which i am porting from VS6 to VS2005. The compiler is giving error message with include file "afx.h". Any idea 1>AreaTree.cpp 1>C:\Program Files (x86)\Microsoft Visual Studio 8\VC\atlmfc\include\afx.h(484) : error C2146: syntax error : missing ';' before identifier 'AfxCrtErrorCheck' 1>C:\Program Files (x86)\Microsoft Visual Studio 8\VC\atlmfc\include\afx.h(484) : error C2433: 'errno_t' : 'inline' not permitted on data declarations 1>C:\Program Files (x86)\Microsoft Visual Studio 8\VC\atlmfc\include\afx.h(484) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int 1>C:\Program Files (x86)\Microsoft Visual Studio 8\VC\atlmfc\include\afx.h ...Show All

• SQL Server Help! The transaction log is full error in SSIS Execute SQL Task when I execute a DELETE SQL query

  Dear all: I had got the below error when I execute a DELETE SQL query in SSIS Execute SQL Task : Error: 0xC002F210 at DelAFKO, Execute SQL Task: Executing the query "DELETE FROM [CQMS_SAP].[dbo].[AFKO]" failed with the following error: "The transaction log for database 'CQMS_SAP' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. But my disk has large as more than 6 GB space, and I query the log_reuse_wait_desc column in sys.databases which return value as "NOTHING". So this confused me, any one has any exp ...Show All

• Visual Studio Print dialog box

  Hi all, I have a VB 2005 app that utilizes a Crystal Reports viewer (CRViewer). I have this code: CRViewer.PrintReport A print dialog box appears when the code is run. I want to do one of two things: 1. eliminate the box all together. 2. run code following the PrintReport command if user chooses to cancel printing. How do I accomplish these Viewing related posts and searching MS Knowledge base has not helped. I am new to VB 2005 and CR. TIA. Hi Steve, There's a tutorial in the documentation called Printing and Setting Print Options that goes over how to print a report without prompting the user. I think it might help out. - Dave ...Show All

• Windows Forms MouseHover Event for Form Buttons (help please)

  This is my 1st time at using certain MouseEvents,what i'm want to do is this...The buttons i have now the Form and ToolStrip all have a Black BackColor..What i'm looking to do is when the persons mouse "RollsOver" a Button the Background color will change... The over all Effect i'm trying to Achive is similar to the Windows Media Player Beta 11 the button is Black ,but when Rolled over it Lights up!! Can someone help me with this cant seem to find any good example in any of my books to achive this look... Thxs in advance PS: here is some code i'v got to work partly..lol seems the only time the Button lights up Red is when the Mouse touches the very outer right side of the button...Not even the button itself,when i roll the mous ...Show All

• Windows Forms Flickering when drawing with graphics object

  I usually write game code using directx. i wanted to see how well the graphics object holds up. (not that it's anywhere as powerfull as directx) I'm getting 'flickering' when running the app though. I've read some other threads saying to double buffer. A bit of extra info, i'm rendering out to a picturebox. Here's the code to double buffer the PB. Public Class GW Inherits PictureBox Public Sub New() Me.DoubleBuffered = True End Sub End Class Problem is, whether not i'm doublebuffered, it still flickers. basically, the draw code runs in a loop timed by a performance timer. Draws backgrounds first, then objects from a back to front method. (so things occlude properly) Before the beggining of each loop, it clears the pic ...Show All

• Visual Studio Express Editions Question in outputing a file

  I would like to output file to My Documents on any machine. What location should be used after output.open(" "); Thank You in Advance This is not a Visual C++ issue, You need to look at Windows APIs ...Show All

• .NET Development System.Runtime.InteropServices.COMException: This command is not available

  The application is working fine in my local machine.But after deployment in client's machine I am getting this error.Please help me. How are you writing to the Word document if not via the COM-based Office automation APIs Anyway, it sounds like you should add proper exception handling and logging to your application so you can tell where the exception originates from. ...Show All

• .NET Development SQLDataReader.GetOrdinal() fails rarely with IndexOutOfRange

  Hi everybody, We were developed some Web-Services that run against SQL Server 2000 with SQLDataReader that executing Stored Procedures in the DB. Most of time (95%) everything is running well, but sometimes (when exactly, we don't know) the same WebService that worked 200 times, fail. The code is simple:         public string myFunction( int ANumber )         {             string strRetVal = null ;             SqlDataReader myReader = null ;             SqlConnection MyConn = null ;             ...Show All

• Visual Studio Team System SBS2003 to SBS2003R2

  Who can i upgrade SBS2003 to SBS2003R2. Exists any file to do this Best Regards. These forums are related to programming questions, and this forum, in particular, is related to the Team Foundation Server component of Visual Studio Team System. Windows Small Business Server has a newsgroup here for future reference. From the SBS site , I found this page which has a section titled "How can you get SBS 2003 R2". Hope this helps- Cheers, Adam ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 2 or 1 more day(s) depending where u are

  So who else is excited that we're finally gonna get it soon Woohhooo!!! I've had C# Express installed for months. I've started working on some game object classes already. Just waiting for notification that it's up. The MS servers are going to be hammered! ...Show All

• Smart Device Development Question on compiling _vstprintf_s(i.e. vswprintf_s)

  Hi there everyone I am using the _vstprintf_s function in my Smartphone C++ app, and this is the region where it is used: void Add2List (HWND hWnd, LPTSTR lpszFormat, ...) { int nBuf, nLen; TCHAR szBuffer[512]; va_list args; if (hWnd == 0) hWnd = hMain; EnterCriticalSection (&csPrintf); va_start(args, lpszFormat); nBuf = _vswprintf(szBuffer, lpszFormat, args); va_end(args); nLen = (lstrlen (szBuffer)+1) * sizeof (TCHAR); WriteMsgQueue (hQWrite, (LPBYTE)szBuffer, nLen, 0, 0); PostMessage (hWnd, MYMSG_PRINTF, 0, 0); LeaveCriticalSection (&csPrintf); } but when I try to compile, I get this linker error : 1>Linking... 1>BTHello.obj : error LNK2019: unresolved ext ...Show All