AllaP's Q&A profile
SQL Server Snapshot Agent - Error: Query for data failed
We've got a problem with our replication. If I try to run the snapshot agent I get the message "Query for data failed". The detail view of this message shows the following: Message: Query for data failed Stack: at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException() at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint, String strWhereClause) at Microsoft.SqlServer.Repli ...Show All
SQL Server change column names
i am trying to change column names in a bunch of tables. why is this not right is there any sp that i can use as i have to change this in a lot of tables across two databases Alter Table Answers Change Product NewProduct varchar ( 35 ) Not a very good idea messing around with system tables. Write a small SP for creating DDL and execute that DDL script. ...Show All
Windows Forms Custom Designer Window
Developing a cutom designer form for my control. Form has a treeview control in it. How do you embed a propery designer window inside a form in runtime. The property designer window is like when you are in design mode and right click a control and hit properties. I want the ability to set properties inside the property desinger  ...Show All
Windows Forms Detecting remote control device events on a browser
Hi, I'm new to dot net, was wondering if anyone here could help... I got a Windows XP PC with a remote control. ( http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnwmt/html/remote_control.asp ) I would like to grab the remote control events on a browser. I got the following C# code for the RMT events grabbing: using System.Windows.Forms; class Form1Window : NativeWindow { private const int WM_KEYDOWN = 0x0100; private int iChar; public Form1 form; protected override void WndProc( ref Message message) { // Handle the navigation and numeric buttons. & ...Show All
Software Development for Windows Vista Unloaded/Persisted Workflows.
Aside from accessing the DB directly, is there any way to query the currently active workflows that are persisted to the DB once they are unloaded I have. But ASP.Net is not persisting to DB as I've mentioned in another posting. ...Show All
Smart Device Development Problem with setup and use a GPRS RasEntry...
Hi everyone, Does anyone has already played with a PocketPC with GSM cellular I’m with a Eten P300B and I’m having some difficults to create and manage DialUp accounts (RasEntry). When I’m creating an Entry trough the Windows Mobile UI, I have to select the "Cellular Line (GPRS)" device and enter a access point name ("tim.br"). I always used the RasGetEntryProperties and RasSetEntryProperties functions to create and manage RasEntry, but I don’t know how to specify value to fill the "Access Point Name" option. If I create the dialup and call the RasDial() function, it connects without problems, but if I need to c ...Show All
Windows Forms resize a richtextbox
How do I resize a RichTextBox control to be as high as its content There appears to be no way to do this . I've seen several "solutions" which all basically revolve around this code: RichTextBox1.Height = RichTextBox1.Font.GetHeight * RichTextBox1.Lines.Length that is; count the number of lines and times it by the height of the font. Unfortunately, this counts the height of the first font on the rich text control that it encounters, which does NOT solve the problem. Rich Text can contain multiple fonts, multiple font-heights and even embedded graphics (which aren't even counted by the .Lines property!), so the calcul ...Show All
Smart Device Development How to use ws-security in M2M embedded devices?
We build telemetry applications and we are looking to design a Windows CE M2M gateway. The requirement is to make this remote device connect as a Web Service Client , but it needs to be secure. Is WSE (2.0 or 3.0) supported in CE are the tools and wizards available What should be the best turnkey security scenario for remote CE devices that connect over Ethernet, Dial-up or even GPRS/CDMA The devices are known and might have windows accounts (User name/Password) but we are not sure if itis extra overhead to maintain, or does it makes life easier... Note: For the Web Service Server we are looking at a .Net NOC wi ...Show All
.NET Development P/Invoke SetWindowLong / SetWindowLongPtr
I'm making a control that P/invokes SetWindowLong. The documentation says one must use SetWindowLong Ptr to make the app compatible with both 32 and 64 bit windows. Is this really true - won't a 32 bit app doing SetWindowLong run on 64 bit windows - or is this rather about keeping the same source natively compilable for both 32-bit and 64-bit execution, to avoid making a 32-bit-only app that must run in compatibility mode on w64 What about the oldest windows that supports .net - win 98 - does it have SetWindowLong Ptr Does the fact that .net apps are managed and my calls are P/Invoked make it possible to use old SetWindowLong and it will ...Show All
Visual Studio Team System Team Build, static analysis
Upon attempting to do a team build on a solution with static analysis, I get an error, "In order to perform Code Analysis on managed binaries, MSBuild needs to launch FxCop. MSBuild is unable to locate the FxCop binaries. Make sure Visual Studio Team Edition for Software Developers or Visual Studio Team Suite is installed and run MSBuild from within the "Visual Studio Command Prompt" or specify the path to FxCop by setting the FXCOPDIR environment variable." The build is taking place on the same machine as team foundation server and team build. Am I reading correctly that it also needs Visual Studio Suite or Test SKU on top of Team Bu ...Show All
Visual Studio Express Editions password format
I have installed the VWD on Windows 2003 server and gone through the configuration several times. At this point the applications which I have developed which worked fine on my Windows xp are not up and running because of some sort of difficulty with the password format. When using the ASP.NET Webstie Admin Tool isn't able to recognize the password format. Can someone help me figure out how to configure this. I tried adding the System.Web.Security.MembershipPasswordFormat.Hashed command recommended by the http://msdn2.microsoft.com/library/kek09k9k(en-us,vs.80).aspx library. but I'm unable to get it to move. Th ...Show All
SQL Server Problem connecting to database
I am running sql server 2005. I had to recover several databases by attaching the mdf and log files. Then I did a local registration. It appeared to work and I can open the tables. However when I try to connect to these databases in another application, it does not see these. It should recognize automatically any sql server 2005 databases. I would really appreciate assistance. I would look and check to make sure that you have enabled the remote connections to the database server. It could also be the permissions inside the database objects, if you have recovered these from a different server you migh ...Show All
SQL Server How to delete a sqlexpress database from the visual 2005
Hello, I created a database in my local sqlexpress server, using the 'Create New SQL server database ..." option in the Server Explorer of VS 2005. How can i delete this database now using VS 2005 it seems that the 'Delete' option, only remove the link in the 'Data Conncetions ' folder. Thanks and Regards Denis To delete a database go to the command line and type the following: C:\>sqlcmd -S <server_name>\<instance_name> 1> drop database <db_name> 2> go 1> e.g. C:\>sqlcmd -S dtjones\sqlexpress 1> drop database deleteme2 ...Show All
Visual Studio 2008 (Pre-release) UDDI & wcf
Hi, I am trying to run the uddi sample, but I got a configuration problem , my uddi server doesn't use https, so I try to change the appconfig file in the uddiclient application : <system.serviceModel> <bindings> <basicHttpBinding> <Binding name="Https"> <security mode="None"/> </binding> </basicHttpBinding> </bindings> <client> <endpoint name="Inquire" address=" http://localhost/uddi/inquire.asmx " binding="basicHttpBinding" bindingConfiguration="Https" contract=&q ...Show All
Windows Forms Certain Events Don't Fire
Hello, I have a windows C# project with ToolStripComboBox and ToolStripButton, and I'm also using CAB and these files are in a loaded module. I tried a SelectedIndexChanged and Click event for those two controls, but they don't fire. Why don't they fire I don't understand the reasoning for that. Thanks, Brian Hey, THis corrected itself. I'm not sure why, but they were eventually firing. I'm having a problem with VC# express compiling my changes so I'm assuming it is that... But I dont' know. Thanks, Brian ...Show All
