Zero_'s Q&A profile

• SQL Server Using SQL Server CE in a NON .NET Delphi Application

  Hi, I'm looking at using SQL Server CE as a replacement for MS Access in a WIN32 Delphi Application. This limits my database options to Providers that is usable from ADO. I see that the OLE DB Interfaces are implemented, but I can't connect to a SQL Server CE database from Delphi. I've cut and paste a sample connection string (replacing the data source bit) but no go I've installed the Runtime Environment, VS2005 bit, Connectivity Tools and the SDK :) Any help Anything that I might have missed Thanks, Dawid The reason for the "Sary Bit" is that most people like me use things like SQLite, Advantage or DBISAM when writing Delphi apps, I stumbled across your posting while researc ...Show All

• Internet Explorer Development IE7, OE6 Printing problems with headers

  Having an intermittent problem printing To: From: CC: Subject: Attachments: headers on emails. Usually happens with larger emails or emails with large attachments or emails that have been replied to or forwarded from other people. Have installed Generic/text printer and sent the email to this printer but sometimes the headers are still missing even printing this way. I have if I open the offending email and highlight just one or two words in the text of the email eg Dear John and then print the email using my HP printer (not as text on Generic printer) - the headers then print and so does the selected words. Don't suggest using Outlook as often we only print the first page of emails as we already have the rest of the email on file especial ...Show All

• .NET Development Dublicate Communication with a Socket

  Hi, I am writing a multiplayer game in Visual Basic using the System.Net.Sockets.Socket interface for the network communication. A problem I have encountered is that the socket will lose or dublicate data bringing the game to a standstill. I have run traces on the send and recive methods but any problem dissapears when stepping through the code. Any help would be apperciated. " A problem I have encountered is that the socket will lose or dublicate data bringing the game to a standstill." Can you elaborate a bit and show some code snippet if you like Best Regards, ...Show All

• Visual Basic Checklistbox Useage

  Hi all, I am looking for a bit of guidance for using a checkboxlist in Visual Studio 2005. I am wanting to use this to have each checkbox set to checked or unchecked, depending on a value contained in the registry. I have 10 items in the list at the moment. Here is a screenshot of what I currently have. Any help on setting the checked state of each individual checkbox within the list will be greatly appreciated. Thanks, Andrew Robinson Dim Index As Integer = 0 Dim CHeckState As Boolean = True Dim NumberOfItems As Integer = Me . CheckedListBox1 . Items . Count Me . CheckedListBox1 . ClearSelected () Me . CheckedListBox1 . SetItemChecked ( Index , CH ...Show All

• .NET Development Bug in CultureInfo.Calender.GetWeekOfYear

  I've just developed an application an ran into a bug in the .Net Framework I wrote this code: CultureInfo culture = CultureInfo.CurrentCulture; //It's da-DK int y = culture.Calendar.GetWeekOfYear(new DateTime(2007, 12, 31), CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday); Sadly this returned 53, but since december 31, 2007 is a monday it should return 1. /Rasmus Are you sure you are interpreting that right The method will return the # of the week for the entire year. The result in your case is the 53rd week. Why would the last day of December be the first week of the year Are you trying to get the day of the week instead Given your code you are telling .NET that you want the week # for the entire year with the day of ...Show All

• Visual Basic Vb.net, local and remote server

  Hi, I'm a newbie. I created an application using vb 2005 and SQL 2005. In this application I have windows forms that manipulate data on a local sql server. May I use this application to work with a data base that is located on a remote server over the net Thanks One of the sites that I find handy is www.connectionstrings.com . On this site you will find what you are looking for. ...Show All

• Smart Device Development Sending packets out UdpClient on Motorola Q Smartphone

  K, thanks to Ilya, I'm making definite progress. I've now got lots of nice debug output going to a TextBox. I'm now trying to send a packet out a UdpClient. A call to Send seems to return successfully but I see no packet emerge on my Ethereal trace of the network interface. Likewise, there is no response coming back as expected. This despite the fact that I can see both web requests and DNS queries and responses going back and forth, obviously bound for the phone over ActiveSync. The UdpClient is bound to port 5060 (SIP for those that may not have guessed already). I have turned off the Windows Firewall. Any other ideas about what might be blocking this packet Thanks, FM OK, so I just discovered that Act ...Show All

• Windows Forms data adapters

  In Visual Studio 2005 I am trying to use data adapters. In the Choose Toolbox Items list, among the items I have selected are SqlCeConnection, SqlCeDataAdapter, and SqlCommand, which is what the Help system says to do. But in the Toolbox Data tab, the data adapter does not show up. Any help would be appreciated. Thanks. Hi, First you need to create a Dataset (Project/Add new item/data set). The toolbox items the change so that you can drag table adapters. The easiest way to build the dataset is to connect to the database (view / server explorer/ add data connection) and then to drag the database's tables directly in the dataset. The adapters will be created automatically. Charles ...Show All

• Visual Studio Tools for Office ThisApplication_Startup not being called - ie. plugin not loading

    I have written an outlook plugin using VSTO. The plugin loads fine and works great if the user clicks on the outlook icon. On the other hand, if outlook is started via automation and then outlook is opened, the plugin does not load. These cases are described below. When the user signs on to windows xp with activesync set to run on startup. ActiveSync syncs with outlook by starting it through, AFAIK, automation. Now when the user opens Outlook by clicking on the outlook icon,  the plugin is not loaded. Another example is when the user has Outlook closed and they click on an oft file on their desktop, and then open Outlook, the plugin is not loaded. Please advise. Thanks. ...Show All

• SQL Server select based on repeated numbers

  i have telephone numbers in my table and i want to select based on numbe of repeated numbers.. for example.. 39657777 39111132 36399991 The first has foue 7s, second has four 1s and the thrid has four 9s. Jassim: I am not sure how to filter the data. Are you looking for a predefined number of 7's Are you looking for records with an aggregate digit count of 4 or more A you looking for numbers with four digits in a row that are all the same I cannot be sure of exactly what pattern I am looking for. What follows might be what your looking for; do any of these look like the idea Dave set nocount on declare @phone table (phoneNo varchar (10)) insert into @phone values ('39657777') insert into ...Show All

• SQL Server Offline/remote backups

  Hi What is the best way to perform daily offline/remote/off-premise backups of our websistes Sql Server 2005 database I've looked into using SSIS but for one reason or another am having serious problems with this. Ideally we'd like to be able connect over the internet and/or lan and pull the entire database down in one go. Our db is ~600mb so isn't major. We used to use Sql Server 2000's DTS and this worked well, but I'm having a real hard time using SSIS to do the same so was wondering what the other options are Many thanks Ben Hi Kevin The reason we used DTS originally was that it allowed us to backup over the internet. Obviously, upgrading to Sql Server 2005 made SSIS the logi ...Show All

• Visual Basic Scripting Support in Developed Applications

  I would like to provide for some simple scripting support in my application. I came across two of them on Codeproject.com Tangram: Visual Basic TOOL: C While Tangram is no longer available, tool seems a bit difficult for the user. Is any one aware any other open source or commerical SDK's to provide for such support. Any help is this direction will be appreciated. Thanks ...Show All

• Visual C# Windows Task Scheduler C# 2.0

  I wanted to know if there is a task scheduler in C# (windows application). I need to start an application function at a specific time. Can someone point me in the right direction. See this post for more help. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1182589&SiteID=1 I hope this will help. Best Regards, Rizwan aka RizwanSharp ...Show All

• SQL Server ::FN_VIRTUALFILESTATS doesn't work in Sql2k critical

  Hi everyone, I perfectly know that this post is bad allocated but it's a critical one. We've a cluster and there it don't get rows. I'm trying this sentence: SELECT * FROM ::FN_VIRTUALFILESTATS and from our production server doesn't return results. Why the hell not However from other servers it returns data. Thanks for your time, ...Show All

• .NET Development How to make Windows forms responsive to buttons while main thread is busy?

  Hello, I don't want to do thead programming. Is there an easy way to make form to resond to button click event while main thread doing some processing If I need to cancel that long process what is prefered way to handle this with minimum amount of code. Thanks, G Thanks, I'm almost 80% done. One thing which I was unable to accomplish is to display messagebox when processing is done inside RunWorkerCompleted event of BackgroundWorker. How can I do that MessageBox.Show throws an error becouse I assume it's running on separate thread from main form. Generally speaking how can I change my form before background work starts and finishes I want to change mouse pointer before it started to hou ...Show All