giddy's Q&A profile

• SQL Server Linked Server

  I have an oracel linked server that I use openqueryset statements to read the oracle tables. However, I want to update some data in a couple of these oracle tables. The linked server is setup using a readonly user. I'd like to be able to call an Oracle Set Role to grant me update capability and then perform the update. Can anyone help me out with some possibilities In case anyone needs to do this... or something similar... I have figured it out: On Oracle server, create the Oracle Package and Procedure: create or replace PACKAGE BODY Call_SEC_ROLE_Package AS PROCEDURE sec_roles (ReturnVal OUT SqlReturnTbl) is begin dbms_session.set_role('apply_security identified by secure_pass'); ReturnVal(1) ...Show All

• SQL Server COM objects under 64-bit?

  Hi everyone,   Primary platform is Framework 2.0 under 32-bit Production platform will be Framework 2.0 under 64-bit.   I'm concerned about what object should I use in order to launch DTS 2000/7.0 from our .Net service.   Currently it tested fine from a 32-bit environment (sql server 2005 as backend).   Reference: "Microsoft DTSPackage Object Library" Physical file:  dtspkg.dll   My wonder,   is there any limitation when it's gonna to work on 64-bit   Generally speaking, any limitation/issue/drawback for COM objects under 64 bit In my project properties appears Any CPU, x86, x64. I've got now Any CPU.   Thanks for your advices,   ...Show All

• Visual Basic Upgrade Issue

  Hello I am updating a VB 6.0 program to .Net using Visual Basic 2005 Express Edition. I have the program running on one computer but when I try to move it to another computer (by copying the /bin directory, I have the same problem using publish) the program crashes. The program seems to crash when it tries to load the second form which uses a grid (used to be Grid32 and is now MSGrid). Below is the error dialog I get (long). What is JIT debugging Help! Thanks See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.InvalidOperationException: An error occurred creating the form. See Exception.InnerException for detail ...Show All

• Windows Live Developer Forums Does VE mess up PNG alpha for IE7?

  I've been playing with a custom tile set generated via map cruncher. The tiles are generated from an image with an alpha channel of about 170 on coloured regions, and full transparency everywhere else. When the tiles are generated and loaded in firefox they look great... exactly as intended. IE6 used to be hideous (last month) and now seems to have the transparency handled, but no alpha. I was using Lewis Harvey's fix, but it no longer seems to be required IE7 also has no alpha on the coloured regions, either, which suprises me. I thought IE7 was supposed to support PNG alpha now. Anyone have any insight or hacks that might make IE7 work as nicely as firefox Thanks, Greg Thanks John. I'll try to get aho ...Show All

• .NET Development what mime type can I use for .msg files?

  There is a file attachment feature that allows users to attach .msg files, among others. I'm not able to find the right mime type to view the attached files. I've tried adding a .msg mime type in the IIS, adding a registry key for .msg in the HKEY_CLASSES_ROOT\MIME\Database\Content Type. But nothing seems to work. I've tried using the following MIME types: 1. appliation/x-msg (I added this to the registry but it didn't work) 2. application/outlook(I tried adding this to the IIS mime type) 3. message/rfc822 4.zz-application/zz-winassoc-MSG 5. applicaiton/msoutlook None of these have worked. Any sugesstions I also tried using a generic mime type like "text/HTML", but I could only see garbage. I'm saving the ...Show All

• SQL Server Derived Table Alternative

  I have an application that has two different database backends, one is SQL Server Compact Edition and the other is SQL Server. The reason is because the application may run at home on one of our sales agent's computers or here in the office. I have a query that uses a derived table and works just fine in SQL Server, however when I run it in the compact edtion (having the exact same table structures) it will not run. My question is...does the Compact Edtion or the Mobile Edition allow derived tables. If not is there a way to work around this I will happily give an example if it will help. Thank you, Adam Hi Dave, could you create/post a simple sample based on the Northwind.sdf included with SQL Co ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Graphics problem

  Ok, here's what I got:   ATI MOBILITY RADEON 9000 IGP, I have Service Pack 2, can run DirectX9.0c easily, I have all prerequisites & requirements I need...But I gut an error message along this line: this.GameComponents.Add(this.graphics);   message: The values used in the attempt to create the GraphicsDevice were invalid. ...Show All

• Visual Studio Tools for Office Using ServerDocument vsto2 for generating server-side Word documents

  I am designing a browser-based ASP.NET 2.0 solution and I have no experience with Office integration. My requirements are fairly straight-forward: I have a database containing identity information (e.g. name, address), and I want to create a Word document by merging the data from the database into a Word template (e.g. a form-letter) and present the result to the user. My clients are running Word 2003. I think this can be done using ServerDocument and VSTO2 but I'm not sure if this is the best way to do things. Would I need to install Word PIA or anything else on the client machine for this to work Another option might be to embed some C# code to call a web service on the server. Again - would I need to install something else (except for ...Show All

• Visual C++ How to communicate with a Command Prompt (cmd) window in VC++

  hi all i want to use the VC++ to write a program that can run the command line window and run some command on it i.e pass some commands to it like for running an .exe file with some parameters and then get back some results from it. how can i do a thing like it. Aamir Search for the system method in MSDN and you should find some entries on how to use it. e.g.: "cmd /K a.exe first_argument" Thanks, Ayman Shoukry VC++ Team ...Show All

• Visual Studio Team System Certified for Team System

  I just wonder if microsoft going to have another type of ceritification for team system, and any training available. Best Regards, we have had to hold them back for short while to match the training initiatives currently going through testing.  Eventually we will have role based certification for all VSTS current roles, expecting to start with Architecture.  I expect this to be part of the TFS RTM announcement early next year. ...Show All

• SQL Server Web Synchronization - completed synchronization starts again

  Hello everybody, There is some strange behaviour i've recently noticed while watching synchronization progress in Replication Monitor on SQL 2005 Server Standard with merge replication configured. The merge process seems to repeat several times. This is the initial synchronizaion (reinitalization at the subsciber). Client is using Microsoft.SQLServer.Replication objects from .net framework assemblies. The synchronization starts normally (status is "Running"). The last message of selected session box shows (among other messages): "Beginning evaluating partial replication filters" then "Finished evaluating partial replication filters" and finally "Merge completed after processing xxx changes... etc ...Show All

• SQL Server Migration of VB Net 2005 (Pro) app using Access 2000 DB (DAO & ADO) to SQL Express

  I've downloaded the migration tool to convert an Access 2000 DB to a SQL DB. The VB code utilizes DAO (3.6) for hourly automatic compaction and the creation of an encrypted security database. ADO is used for the data maintenance functions. I expect the current connection methodology of ODBC using Jet 4.0 will need to be modified (many articles here address this). All the SQL code is inline and also must be modified. The Coldfusion code utilizes Micrsoft Access with Unicode via an ODBC connection with only SQL Select statements. At another job, I migrated an Informix 7 database to MS SQL 7 and for the most part the SQL code remained the same except for the wildcard spec from * to %. I'm looking for insights and/or shortcuts on this effor ...Show All

• Windows Forms Adding ampersand to create hotkeys

  Hello all, I'm working on a form that contains several languages and therefore using unicode. The problem is that when I use ampersands on buttons in order to create hotkeys, the ampersand appears on the button text. Is there anyway to get around this Also, I wanted to know if there's a way just as simple to create hotkeys without having to use the button text This example here is the closest one I came up with, but it still looks rather complicated. Here's what I do: private void F_Login_Paint(object sender, PaintEventArgs e) { this.Text = Languages. Strings .LOGIN; B_Login.Text = "&" + Languages. Strings .LOGIN; B_Settings.Text = Languages. Strings .SETTINGS; } Now, Languages is a referenced project that consist ...Show All

• Visual Studio How to make Tree's?

  I need to make something like this: Element |---Group |--Value |--Value |--Group | |---Value | |---Value |---Value |---Group .... but.. Group "can't be embedded in" Group and Element. Adding hierarchies doesn't help... I could make it using relationships, but then, i couldn't use compartments... Thanks, Hi Alan, How flexible are the mappings in the current release (August 2006 CTP) Can trees be represented with embedding relationships now Thanks, Fernando ...Show All

• Visual C++ Asynchronous Sockets in C++?

  Hello, I want to use asynchronous sockets in pure C++. Is there anyone to tell me how to do it or at least show me a basic example The external libraries are appreciated too. Thanks... There are plenty of tutorials on it. Look at code project and you might be able to piece something together with win sock just looking at documentation at msdn. ...Show All