Juco's Q&A profile

• Smart Device Development Querying from my PPC to a Desktop Database

  Hi, I would like to ask what are the things needed to connect a pocketpc to a desktop database server so it can query to it. What I mean to ask is, what pocketpc OS, database server and visual studio must be used Is it even possible without any CE Database on the pocketpc Im trying to develop a program that will help waiters in restaurant to place orders using pocketpcs. The main objective of the software is for the waiter to input the order of a customer and the data will be passed to the database to make the order. Any help would be greatly appreciated. Thanks. Jup You need: 1. Desktop server. 2. Database on desktop server which allows for remote connections (e.g. SQL Server 2005 is OK, Access i ...Show All

• Visual C# new Modifier behaviour in interfaces

  Example: public interface B { string Name { get ; } } internal interface AB : B { // new - hides a member inherited from a base class (!) new string Name { get ; set ; } } internal class MyClass : AB { public string _name; // implementation of the AB.Name property public string Name { get { return _name; } set { _name = value ; } } } then: AB ab = new MyClass (); ab.Name = "!" ; ... B b = (B) ab; Debug.Assert (b.Name == "!" ); //true! Why when I call method get_Name () form interface B - the AB.get_Name () is called I don't get it because in AB interface Name property is declared with ...Show All

• SQL Server Lookup Transform

  Hi! I am a newbie, grateful for some help. I have a Source Ole DB w sql-command selecting the customer.salary and customer.occupation, which I want to match with demo_id in Ole DB destination. salary, occupation also in dim_demographic. But in Lookup editor I find no column demo_id... how do I do this OLE db Source column: SELECT Sum, k.sum-p.price AS Profit, convert (char(8),date,112) as Date_id, salary, occupation , k.shop_id, k.customer_no, salesperson_id, p.articlenr,campain_id FROM Purchase k join product p on k.articlenr=p.articlenr join customer ku on k.customernr=ku.customernr Destination column: demo_id , Profit, customer_id, product_id, shop_id, date_id, sum, salesperson_id, campain_id Demo_id = id from Dim_demographi ...Show All

• SQL Server DTS migration wizard, how to edit MSDB packages?

  Thanks to Sean for helping me find the migrated packages. I'd like to edit one of the connections on a bunch of packages that I migrated. I see in the Run Package there are configuration options that would allow me to mofify the connection string at that point in time, but I would like to modify the package so it has the new connection string. I was thinking I could access it in BI Dev studio, but I'm not sure how to get to it. I suppose I could migrate to a file and then edit the file prior to importing, but I'm curious if there's a way I can modify the packages that show up under Integration Services/Stored Packages/MSDB. Thanks, John ...Show All

• Visual Studio 2008 (Pre-release) error 2738.Could not access VBScript run time for custom action

  Im trying to install blackberry 4.2 service pack 1 On my windows vista for my blackberry phone and i keep gettin this message.. Can someone please tell me what i need to do Ok I am not that bright, I guess but I have no idea how to do what you just said... So I guess I'm not that great when it comes to computers...Thanks for the suggestion, but if you could explain to me what I need to do I would greatly appreciate it.. Thanks alot ...Show All

• SQL Server Stored Procedure - Insert with table name from parameter

  First of all hi for all, I m trying to make insert stored procedure with parameters, i want to send table name and insert values with parameters, i m trying that below stored procedure but it gives syntax eror to me what shoul i do to correct it set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo] . [insertalepform] -- Add the parameters for the stored procedure here @type nvarchar ( 15 ), @talepbrmno int , @birimisteksayi bigint , @birimistektarih datetime , @aciklama nvarchar ( 50 ), @onay int , @seviye int , @talepformno bigint , @taleptarih datetime AS BEGIN SET NOCOUNT ON ; exec ( 'INSERT INTO [BelediyeWork].[dbo].[' + @type + 'TalepForm ...Show All

• SQL Server Stored Proc - Calling a Remote Stored Proc

  I am having trouble executing a stored procedure on a remote server. On my local server, I have a linked server setup as follows: Server1.abcd.myserver.com\SQLServer2005,1563 This works fine on my local server: Select * From [Server1.abcd.myserver.com\SQLServer2005,1563].DatabaseName.dbo.TableName This does not work (Attempting to execute a remote stored proc named 'Data_Add': Exec [Server1.abcd.myserver.com\SQLServer2005,1563].DatabaseName.Data_Add 1,'Hello Moto' When I attempt to run the above, I get the following error: Could not locate entry in sysdatabases for database 'Server1.abcd.myserver.com\SQLServer2005,1563'. No entry found with that name. Make sure that the name is entered correctly. Could anyone shed some light o ...Show All

• SQL Server execute sql task resultset

  hi all, in my execute sql task, i have a try catch statement to catch error code if there's an error... begin try insert into person.contact (contactid) values ('1') end try begin catch select @@error as ErrorCode end catch this ErrorCode will be mapped to a user variable. my problem is the value for ResultSet. in order to assign ErrorCode to the variable, i have to set the ResultSet value to Single row, but if this task does not fail, i need to set ResultSet value to None in order for it to run successfully. How do i go about solving this problem Please help. thanks! Well, I am not quite sure, but I think when you don't use the try....catch and a error occurs; the variable will ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Rotation help

  I think I'm being dense today, but I can't figure this out for the life of me. I have a model that I want to rotate across the X and Y axis. My issue is that when I rotate across the Y axis, I always want the rotation to occur as if the axis was vertical in terms of world space. If I multiply by my X rotation first, obviously the Y axis moves with it, so rotating about the Y axis will rotate it about its transformed axis. If I multiply by my Y rotation first, the X axis moves with it, so my X rotation is now turned along with it. I basically want to rotate downward and then left/right independently from what the actual transformed axes become...or, rotate left/right and then downward independently.  When I rotate about the X, it shoul ...Show All

• Visual Studio Team System Error opening project after schema import

  Created a new SQL Server 2000 database project, then use the Import Database Schema function in the Solution Explorer. This worked well, importing the DB objects, as well as displaying some errors in the project where table changes would cause views to break. However, if I close the solution, then attempt to re-open it, after about a minute of "Processing Schem Objects" in the status bar, VS reports the following error: Unable to create a new relationship because there is already an existing relationship between the specified schema identifiers. The project is unusuable. I must create a new project and re-import to continue my work. Is this a know problem, and any workarounds Hi, ...Show All

• Smart Device Development cepc connection through serial

  hello all actually i want to download my os image from platform builder to CEPC through serial i have a serial cable which i connected from my devlopment machine to cepc. also in platformbuilder connectivity option i chooses serial transfer.... enable KITL also(release mode) and also used sboot while booting CEPC but still its not working...... adding some more!!! i also used null modem cable and all options as suggested in MSDN..but all in vain have i missed something....plz suggest me..if there is some other requirement need to be done thanks vishal ...Show All

• Community Chat AIM,YAHOO and Rediff Sniffer

  Hi, I created a small sniffer which sniff rediff,aim and yahoo protocol data. you can get it here:- http://www.secgeeks.infys.net/aim_yahoo_and_rediff_bol_sniffer thanks ...Show All

• SQL Server How to Connect the Sybase IQ as a Data Source in MS SQL Analysis Services 2005

  Hi All, Can any one know how to make a data source of Sybase IQ in Analysis Services. I have OLE DB for Sybase. Can i use that to connect Sybase IQ If Yes than How. Thanks, Satish Edward, At the following link you suggest creating a linked server from SQL Server to Sybase IQ as a workaround for getting Sybase IQ data in analysis services. What are the parameters that are necessary to link IQ to SQL Server. Which Provider do I use Do I need to install a special driver Thanks, Eli ...Show All

• Visual C++ MFC ?

  Hai, To Create a time critical application, which method should i follow Using MFC in shared DLL or Using MFC in static library Can anyone help .. Thanks in advance. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Problem while installing Direct X 9.0c

  Hi I am using windows xp professional with service pack 2 installed in it. As we all know that service pack 2 has built in directx 9.0b installed in it. Now if I try update directx 9.0b with directx 9.0c it wouldn’t do it. I am still unable to install directx 9.0c into my pc. When I try to install directx 9.0c , a dialog box appear saying “The components installed are now ready for use.” Which is not true. I tried running “dxdiag” command it still shows directx version 9.0b Please help! I had a similar problem after playing around with directx. I tried to reinstall SP 2 but once I had uninstalled it, my help and support center wouldnt work and I couldnt find any other way to reinstall SP2 dir ...Show All