Necromantici's Q&A profile

• SQL Server timeout errors, and General Network Error messages

  Hi We have a VB6 app, with SQL2005 database, SQLOLEDB driver We have it installed at many clients and normally works fine. We've migrated one client from SQL2000 to SQL2005 and had to move the database to a new machine. It's now running SQLExpress sp1, on a Win XP sp2 machine The clients now frequently get either a) SQL timeouts or b) Runtime Error’2147467259 (80004005) [DBNETLIB][Connection Read(recv()).]General network error. Check your network document Errors I suspect it is something to do with connections not be released (even though we explicitely free them in the app). Where do I look Thanks Bruce XP Pro We only have a handful of 3-4 users doing any meaningful # ...Show All

• Visual Studio Exporting to Excel Using Old Code

  I am trying to create a page to export a report to a pdf. I am using the same code I used in Visual Studio 2003, but it can't find the report class. Is it because the rpt file is not in the same namespace as the export code Here is my code. Is there an easier way to do this in 2005 Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Imports System.IO Namespace DocumentComments Partial Class pdfActivityReport Inherits System.Web.UI.Page Dim oRpt As New rptActivityReport() # Region " Web Form Designer Generated Code " 'This call is required by the Web Form Designer. <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeCompone ...Show All

• Visual C# Capture Data From Modem

  hi there I want to capture received data from modem.I have been testing it with serialport class in .Net , but it diden`t work completely. What should i do for it. Unfortunately I couldn`t send or receive data from modem.Here is what exactly i want to do: I have a modem, a phone line. I want when everybody calling me(from phone to modem) i receive the hole data sending by them and saving their voice. the phone line is analog. second i want to order the modem to dial a number. if you can help me with serialport in .Net, it would be wonderful. sample code will be helpful for me. ...Show All

• Smart Device Development [Smartphone-c#] Word files

  hi! i have created an application that open a specific *.doc file in a directory. but when i try to run it the smartphone gives an error on the "Microsoft.Office.Interop.Word.dll"... i have tryed to import the dll and copy it on the phone, but it doesn't work... why     //-------------------------------------------------// this is the error message: TypeLoadException was unhandled" Corpo: "File or assembly name ' Microsoft . Office .Interop. Word , Version=10.0.4504.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35', or one of its dependencies, was not found. not as far as I know im afraid. you can open pocket word docs etc... (mobile word) on PPC or devices that have the p ...Show All

• SQL Server im going crazy

  I just got bought a used computer, and Im trying to change the server name, I've changed the computer name and restarted the computer, I've also used query analyser and changed the server name, but when I try run an c# appication that connects to a sql database I get a server does not exist/access denied error message. when I go to enterprise manager and server service manager the server name still comes up as PICARD\HOMESQL obvuiusly I cant use a "\" in the connection string of my windows application. does anybody know how I can change the server name to PETER. thanks in advance Hi, try using "server=MARCUS\\HomeSQL; database=Northwind; integrated security=sspi;")] OR @&qu ...Show All

• Windows Live Developer Forums Polyline Craziness

  I am working on a mapping project that allows the user to draw polylines. It all seems to work when the user clicks points of the polyline. From there I save the gps coords to a database. When I then retrieve the coordinates and display the polyline it does crazy things. It initially displays correctly but when zooming in, the line sometimes disappears, or draws in incorrect locations. If it does draw in incorrect locations and you pan, the polyline constantly moves. Can anyone please help, this problem is starting to drive me crazy. I have included "some" of my code. function loadMap() { mapDiv = document.getElementById( "myMap" ); new VEMap( 'myMap' ); map.LoadMap(); map.HideDashboard(); ...Show All

• SQL Server Mix and Match Rows

  In the trading (stock market) industry there is a practice of rolling up (merging) multiple trades into a single trade in an effort to save on ticket charges. The way this is done is performing a SUM() on the quantities and calculating an average price. (Average price is the SUM(Qty * Price) / SUM(Qty). So, given : Qty     Price 20      $5 20      $10 You get: 40      $7.5           -- 20 + 20 and SUM(20 * $5, 20 * $10) / SUM(20 + 20) Here is my dilema: If given a set of trades, I need to loop through them and check every combination to determine which one matches the expected ...Show All

• SQL Server Data search

  I use SQL server to connect to a HUGE odbc compliant db with 1000's of tables. The db contains tons of data. I am looking for specific data elements. Is there any way to search the entire db for a data value Thanks Marcie ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Looking for Custom Importer Example

  Hi I am looking for a Custom Importer example or tutorial. The information in help-file is a little bit too basic. I want to know how to write a custom importer yourself. Thanks a lot. Best Regards Gerhard Results from a simple Google search. ...Show All

• SQL Server datetime datatype conversion

  Hello I have 1 column in table with char datatype that stores datetime values (e.g.: 20061207091510 which translates to 2006-12-07 09:15:10). Is there a way to convert this string into datetime datatype to preserve the time part (hours:minutes:seconds Thanks, Lena SELECT CONVERT ( DATETIME , LEFT( '20061207091510' , 8 ), 112 )+ CONVERT ( DATETIME , SUBSTRING ( '20061207091510' , 9 , 2 ) + ':' + SUBSTRING ( '20061207091510' , 11 , 2 ) + ':' + SUBSTRING ( '20061207091510' , 13 , 2 ), 114 ) ...Show All

• Smart Device Development Opening So many Forms & Task Manager!!!

  Hello, I'm working on a chat application where i need to open seperate Forms for private chat with each user. For Each New form I saw a Seperate instance in Task Manager, timg_msft suggest me a solution like this: Form1 frm1 = new Form1(); string myText = this.Text; this.Text = string.Empty; frm1.ShowDialog(); this.Text = myText; in Post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=703794&SiteID=1 problem with the above code is that I dont want to show it as a Modal form with ShowDialog() because I need to keep them open: Taking help from this code, I wrote 2 classes here is the code: public static class OpenedFormCollection { private static Dictionary < string , FormComm ...Show All

• Visual Studio 2008 (Pre-release) MS: UIElement.IdealSize property request

  Hi Microsoft, I'd like to request that you add an IdealSize property to the UIElement class. This property would essentially return the result of a measurement of the UIElement with "new Size(double.PositiveInfinity, double.PositiveInfinity)" passed to it. Right now the issue is that when you have a UIElement with collapsed visibility or a fixed width/height (like 0), there is no way to easily determine what the UIElement would like to be. There are many cases I'm running into where I really need access to the "ideal" size for the element. Hopefully this can be added in the next version of the framework. Thanks! I think we can call ctrl. Measure( new Size ( Double .PositiveInfinity, double .PositiveIn ...Show All

• Visual Studio Team System How to differentiate the Constructor which generated by Compiler or writen by user

  How to differentiate the Constructor which generated by Compiler or writen by user: I have overrided the check method: public override ProblemCollection Check(TypeNode type) { if (type.NodeType == NodeType.Class) { int memberCount = type.Members.Length; int constructorCount = 0; for (int i = 0; i < memberCount; i++) { Here: What can I do to differentiate the constructor which generated by Compiler or writen by user if (type.Members .NodeType == NodeType.InstanceInitializer) { { constructorCount++; } } } Problems.Add(new Problem(GetResolution(constructorCount.ToString() + NodeType.InstanceIni ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Framework Beta 2???

  I recognized there are some posts which mention XNA Framework Beta 2. I looked at connect but I can only download Beta 1. Is Beta 2 not for all members of connect When will Beta 2 be public available It's here: http://www.microsoft.com/downloads/details.aspx FamilyId=AADBB141-D28F-4ED0-9673-DF4D16DE3AFA&displaylang=en ...Show All

• Visual Studio Unable to delete or rename share project

  Hi All, I've accidentally share a project from trunk. When I delete or rename this share project. I got message: "file \\vsserver\data\b\bsqbaaaaa.b is already open". Now I'm unable to create any new share/branch from the trunk. Has anybody experience the similar problem, please share. I'm very appreciated. Best Regards, Try closing all VSS clients connecting to this VSS database and also stop VSS LAN service. Run analyze on the database and then try your action again. If this does not help try to find out which process is using this file. You could use Process Explorer from Sysinternals to do that. http://www.sysinternals.com/Utilities/ProcessExplorer.html ...Show All