Peterlih's Q&A profile

• SQL Server Query Oracle Table In SQL & Put In Temp Table

  Hi all, I am querying a table in oracle, the server connection to the Oracle database is determined by a criteria. Though how can I put the results from the oracle query into a temp table This is the code i'm using for the query: DECLARE @cmd VARCHAR(500) declare @Year varchar(25) set @Year = '2006' DECLARE @Link VARCHAR(100) DECLARE @Table VARCHAR(100) select @Link = Server from tbl_Conn where Area='Floor' select @Table = Target_Table from tbl_Conn where Area='Floor' SET @cmd = ' select * from OPENQUERY ( ' + @Link + ', '' UPDATE '+ @Table +' SET TARGET_VALUE = '+@Value+' WHERE Date = '+@Year' '' ) ' EXEC (@cmd) How do I put the executed results into a TEMP table Rgds, ...Show All

• SQL Server 64 Bit MSDASQL.DLL

  Is microsoft going to provide 64 bit version of MSDASQL ( OLEDB Wraper for ODBC) in future This was working great while accessing Data from IBM AS/400 on Iseries from 32 bit sql 2000. Now, it's all screwed up with rediculously slow OLEDB both from MS and IBM. I wonder if any of these guys really care! In case anyone cares. We are also in great need of this release. In our investigation of this issue, I received the following answer through another resouce. The MDAC team might want to confirm: The MDAC team is going to release 64 MSDASQL..."when Longhorn is released, which is the new version of Windows. I've read that Longhorn won't be out until 3rd or 4th quarter, so we'll have to investigate other ...Show All

• Visual Studio Easiest way to create a simple report?

  Hi there, I would like to create a simple report on a Windows Form, using a ReportViewer, so that viewing the enquiry and printing the report are really easy and can be done from the same form. How do I go about binding my dataset (containing a list of Customers) to the Table control on teh report layout Any help would be greatly appreciated! TIA, JackStri. I have a long chapter on the ReportViewer control in my new book "Hitchhiker's Guide to Visual Studio and SQL Server". I know it will help answer this and the other questions you're bound to have. See www.hitchhikerguides.net for details. ...Show All

• Architecture Which protocol?

  I'm writing a solution for communication with a (.net) server. Now I'm thinking about a protocol I should use(Remoting, WebService, Sockets, ...). There are some things to consider: There may be many clients connecting to the server with that app (100000 ) I want this app doesn't have any problems with routers (firewall, NAT) Later, there will be a C++ client (not managed) I'm tending to webservices because of (2,3) but don't know if there will be performance issues... What would you do Konstantin Arnon, I'm still waiting to see that shirt 8-) What messaging technology can fire events on the client via HTTP ...Show All

• Visual Studio Team System Hide projects from users who can't do anything in them?

  We have dozens of team projects in our TFS server for a lot of developers. Is there a way to hide the ones from the users who can't do anything in these projects Is this the permission that controls this < permission name =" GENERIC_READ " class =" PROJECT " allow =" true " /> The [SERVER]\Team Foundation Valid Users group has this permission and every user belongs to this group directly or indirectly by default. Thanks a lot everyone.  The permission is on the TFS Valid Users group by default.  But taking that away removes all the projects from the list, including the ones you do have access to.  So you can't even add a pr ...Show All

• SQL Server Between + '%'

  helloo I have this table Id Code -- -------- 1 10101001 2 10101002 3 10102001 4 10102002 5 60101001 6 60101002 7 60102001 8 60102002 9 60201001 10 60201002 11 70101001 12 70101002 I need to query this table by the following (select id, code from table1 where code between '1' + '%' and '7' +'%') to get all values of codes between (code starting with 1) and (code starting with 7) or for example: (select id, code from table1 where code between '602' + '%' and '7' +'%') ------------------------------------------------------------------------- Im not getting correct answers or let be specific in the second query im not getting codes starting with 7, im only getting codes >= 602 but less that 7, so 7 is not incl ...Show All

• SQL Server question on package configuration names

  hi, i would like to know how to get the package configuration names and values when a package is set to use package configuration. thanks. ...Show All

• Visual Studio Team System Build Failu AssemblyInfo Task

  We've been trying to automate our builds and have done so successfully using a tool called 'Automaton' and everything has been working fine uptil now. One particular project is building locally but fails to do so on the team server. I don't recognize the error: =================================================================================== Build FAILED. C:\Program Files\MSBuild\SharedTeamBuild.Targets(137,3): error MSB4018: The "AssemblyInfo" task failed unexpectedly. C:\Program Files\MSBuild\SharedTeamBuild.Targets(137,3): error MSB4018: System.ArgumentException: An item with the same key has already been added. C:\Program Files\MSBuild\SharedTeamBuild.Targets(137,3): error MSB4018: at System.ThrowHelper.Thro ...Show All

• Windows Forms user control property using a generic list

  Hello First, sorry about my bad english... that's because I'm from Argentina, so I speak spanish, not english. But I'll do my best so you can understand me... thanks. I'm developing an user control (similar to a sidebar), and one of its propertys is a list of the options that the control shows. Every option is defined by an object of the class "Opcion" defined on the same namespace of the control. Following the standar practice, I have defined a private generic list of the type "Opcion" that contains the options that the control must show, and a public get-set method to access this list, of the same type (generic List of "Opcion"). So, when I add a control on a form, on its property page there i ...Show All

• Visual C# What do all this files do?

  I have just started to learn VS and C#. I have noticed that when compiling a C# project many different files appear in the project folder, which adds to the confusion for a newbee like me. In my project folder (named HelloNET) I have the following: App.ico, icon AssemblyInfo.cs Form1.cs Form1.resx HelloNET.csproj HelloNET.csproj.user HelloNET.sln HelloNET.suo The are also folders "bin" and "obj", "obj"-folder contains the following: HelloNET.exe HelloNET.frmMain1.resources HelloNET.pdb HelloNET.projdata HelloNET.projdata1 "temp"-folder (empty) "TempPE"-folder (empty) "bin"-folder contains a "debug"-folder that contains the following: HelloNET.exe HelloNET.pdb I ...Show All

• Visual Studio 2008 (Pre-release) Hello World Logging Problem 2

  Well, I was working on this very simple yet useful tutorial. http://wcf.netfx3.com/content/BuildingHelloWorld.aspx and I posted a problem before that I couldn't get the loggin working. Followinig Madhu's suggetion to enble tracing also solved the problem However, when I created another one, it didn't work again. When I make about 5, or 6 samples, I have the same setting in the service config editor, but the very few programs create e2e file. So I'll post the app.config file and you guys can take a look at it and give me suggetions please. I was wondering if I have to specify the client too but that doesn't make sence to me. Anyhow, here's my app.config file < xml version="1.0" encoding="utf-8&qu ...Show All

• Visual Studio Express Editions Counting Pixels in a 1-bit Image

  I kind of brought this up before, but the topic headed off in a different (yet constructive!) direction. I have a 1-bit image. Of course, this means that pixels are either "on" or "off". Is there a way to quickly find out how many pixels are set on I don't need to know which bits are set, just how many. Is there a way to do this without using "GetPixel" on every pixel I was thinking I can read in each bit, then find the unique values (0 or 1), but the image is large (25M pixels) and this method may be too slow. Any other ideas As always...thanks! Yeah, I thought about that already but had to ditch the idea. What happens if the user draws over a portion that t ...Show All

• Smart Device Development how to call wince api

  I want to call the Win32 API SetSystemPowerState but not pass build. the vs.net not know SetSystemPowerState. why This is because you are needing to call a native/import dll to execute that specific function, this is not built into the managed framework. You need to P/Invoke you may need to import coredll.dll but im unsure....   check this: http://msdn.microsoft.com/library/default.asp url=/library/en-us/wceddk40/html/cxrefSetSystemPowerState.asp http://msdn.microsoft.com/library/default.asp url=/library/en-us/wceddk5/html/wce50lrfSetSystemPowerState.asp   http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=541238&SiteID=1   example of invoking from C ...Show All

• Internet Explorer Development trouble using a external c library in Activex control

  I have created a scriptable activex control which uses an external C library. I'm using this library to send http messages to a server. The control is intended to use through JSCript. What my control does is myactivexControl.send("HTTP data"). This method internally uses the c library. The c library runs and it waits for a reply. When the reply comes it hand me the response. But I have a problem. C library does not capture the response sometimes. But it captures the response most of the time. When I use the C library without wrapping it in my ATL com class this is not happening. The c library works fine alone. 1. Is this can be happening due to the interaction between c and ATL com 2. Is this happening because of the browser. (A ...Show All

• Visual C++ a problem ablut the reference

  in<think in c++>2th  Page 453 the author said :Once a reference is initialized to an object ,it  cannot be changed to refer to another  object " but  form the code  I  can see the reference  is changed to refer to another                     is  the  auther  wrong   　PS　I am using dev C++ #include<iostream> using namespace std; int main(int argc,char* argv[]){     int i,k=3;     int &x=i;     i=1;     cout<<x<<endl;     i=0;     cout<<x;   &nbs ...Show All