Paulredman's Q&A profile

• .NET Development Randomly GNE "General Network Error" after upgrade MSDE 2000 to Sql2005 Express

  I wish nice day, we have many, many bugs ( arround 10 errors messages from every user per week --- today 300 users using our application and up to end of May, 2006 we reinstal Sql 2000 MSDE -> 2005 Express next 750 users) from our application ( .NET 1.1, localDB on Sql2005 Express ) with exception bellow: ----------------------------------------------- General network error. Check your network documentation. -> ExecuteReader [.Net SqlClient Data Provider] | Call Stack | at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.Exe ...Show All

• Windows Forms Concerned about designer stability...

  I recently lost a good amount of time trying to move a dataset out of a project.  Things seem very brittle with VS 2005. I dropped a bunch of fields from a data source on a page, then closed the form.  When I returned, it would not load, but instead made a stack dump where it complained about the dataset I just designed. "The designer cannot process the code at line X  Me.Subscriber.DataSetName = "..." The code within the method 'InitializeComponent' is generated by the designer and should not be manually modified. Please remove any changes and try opening the designer again. " I then removed all references to bound ...Show All

• Smart Device Development Compact Framework 2.0 & Windows Mobile 5.0 NotSupportedException

  I have recently starting developing with VS2005, Windows Mobile 5.0 and the CF 2.0. I have noticed that recently I am receiving a NotSupportedException whilst trying to change the text of a textbox from a background thread. I used to get a detailed exception telling me not to update the textbox from a background thread. The only difference these days is that I am developing for Windows Mobile. Is there something I am doing wrong My App seems to hang when debugging instead of giving me a proper exception. I hope I have explained this well enough. Thanks Hi.. I have face the problem when I con ...Show All

• Visual Studio Tools for Office Add/Remove Worksheet in VSTO Workbook

  I created various worksheet inside a VSTO workbook, but now, I can't remove my testing worksheet and add blank new worksheet. 1. I can't select Delete in solution explorer when right-clicking on the worksheet item. 2. Even I remove worksheet in Designer pane (right click the tab at the bottom of Excel workbook and selete Delete), rebuild the VSTO project and then the deleted worksheets are all still here. I then Refresh the workbook object in Solution explorer, and all deleted worksheets come out again. I tried to use the "Add new Excel Worksheet" from the function menu by right clicking on the workbook in solution explorer, it ha ...Show All

• SQL Server Connection between 2 databases in local sql server

  Hi, I have two different applications based on SQL server database. In one of the applications I need to use the information stored in the second database, only for read purpose. As I understand I need how some to make a link between the databases in order to share tables. Can anybody advise me how to do that, if it is possible at all Thanks Just use a fully qualified name i.e. Server.Database.Owner.Table for example: Select * from MyServer.Northwind.dbo.Customers Regards Paul ...Show All

• .NET Development userSettings and dlls?

  I'm rather confused on the whole use of user and application settings in project properties (the values that get serialized in the app.config file under userSettings and applicationSettings). For instance, I create a solution that has a console app and a class library. In the class library I add a DateTime user setting variable with some default value. I create a class in the class library that has this code: using System; namespace ClassLibrary1 { public class Class1 { public static DateTime TestSetting { get { DateTime dt = Properties.Settings.Default.TestSetting; Properties.Settings.Default.TestSetting = Da ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Problem with ComputeBoundingSphere

  I'm trying to use the Geometry.ComputeBoundingSphere method to get the radius of the bounding sphere of a simple mesh. The code is as follows: using (VertexBuffer buffer = this.mesh.VertexBuffer) { GraphicsStream graphicsBuffer = buffer.Lock(0, 0, LockFlags.None); Vector3 center; boundingSphere = Geometry.ComputeBoundingSphere(graphicsBuffer, this.mesh.NumberVertices, this.mesh.VertexFormat, out center); buffer.Unlock(); } For some reason, this code is always returning 0 as the radius of the sphere. My mesh is just a simple 7 vertex hexagon that renders fine. Thoughts ...Show All

• SQL Server xp_sendmail issue

  I'm using Server 2000....I have pointed the master database to the sqlmap70.dll so now QueryAnalyzer understands the xp_sendmail syntax; EXEC master..xp_sendmail 'Callan' , @query = 'qmtest' ....however, I now receive the following error; xp_sendmail: Procedure expects parameter @user, which was not supplied. ....yet, when I add the parameter @user = 'guest' It tells me; xp_sendmail: Invalid parameter '@user' Any help would be GREATLY appreciated... Hi, I am using sql server 2005. I have configured Database Mail using my office email account profile. when i try to use the master . dbo . xp_startmail 'myaccount','mypass ...Show All

• SQL Server Linking to a DB2 database from SQL Server 2000

  I am using SQL Server 2000 (client-side tools including Enterprise Manager) and need to link to tables in a DB2 database so that I can run queries that will import data into my SQL database. My understanding so far is that I need the DB2 ODBC driver (which I have installed) and the DB2 OLE DB Provider. I downloaded the DB2 Application Development Client from IBM, which is supposed to include this provider, but I still don't see it in SQL nor can I reference it in an sp_addlinkedserver statement without getting an error. I know that SQL Server 2005 Developer Edition includes the provider but I'm hoping for a solution that won't require an upg ...Show All

• SQL Server Putting Multiple Field data in a report table cell

  I'm using report designer and Visual Studio .net 2003.  I have a table in the report and would like to put multiple field values in a single cell.  Something along the lines of this in the cell: =Fields!Phone.Value, Fields!.Fax.Value.   I don't know how to seperate the values to get them to work in the same table cell.   I've tried commas, semi colons, spaces, parens.   How would I do this I couldn't use IsNull because it says it is not decleared.  I can use IIF, so the correct code is =Fields!Phone.Value & IIF(Fields!Fax.Value=nothing,"",",") & Fields!F ...Show All

• Windows Forms Drag from Toolbox to form needs to add two references!

  I have a custom control called ControlX that is compiled into assembly AssemblyX. I have another assembly called AssemblyY that implements a custom control ControlY that derives from ControlX. The problem is that when a developer drags ControlY from the toolbox onto a form at design time the project is only given a reference to AssemblyY. This is no good because it also needs a reference to AssemblyX in order to compile and work because of the inheritance. How do you mark a control, or assembly, so that it will automatically add the extra reference to a project at design time Phil Wright http://www.componentfactory.com Free user interfac ...Show All

• SQL Server SSMS Express: Creating Parent-Child Table via LEFT OUTER JOIN - Error Message 156

  Hi all, I got an error message 156, when I executed the following code: ////--SQLQueryParent&Child.sql---//////// Use newDB GO ----Creating dbo.Person as a Parent Table---- CREATE TABLE dbo . Person ( PersonID int PRIMARY KEY NOT NULL, FirstName varchar ( 25 ) NOT NULL, LastName varchar ( 25 ) NOT NULL, City varchar ( 25 ) NOT NULL, State varchar ( 25 ) NOT NULL, Phone varchar ( 25 ) NOT NULL) INSERT dbo . Person ( PersonID , FirstName , LastName , City , State , Phone ) SELECT 1 , "George" , "Washington" , "Wash ...Show All

• SQL Server using SQL for small apps

  I’ve been programming against Access databases under VB6 for a while, but since everyone is talking about moving to the latest and greatest of .NET, SQL, etc. I’ve been trying to learn these new technologies, however, I’m unsure if they’re right for me. My database programming has been on a small scale, using databases for personal applications, for example, the way Adobe Photoshop Album uses an MDB file to keep track of all the tags and pictures in it’s database. Another common scenario where I utilize MDB files is when I have reasonably complex user settings that need to be saved and manipulated. I generally don’t progr ...Show All

• Windows Forms Runtime error, File Format is not valid in RichTextBox.LoadFile()

  Hey, I have a starnge runtime error, when I run my program and click ont he load option it opens up the load dialog, so then I click on Text FIle(*.txt), and then click on a text file to open and then when it is opening it, it gets a runtime error, it highlights this line of code: RichTextBoxPrintCtrl1.LoadFile(openDialog.FileName) This is the load code: Private Sub openMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles openMenuItem.Click openDialog.Title = "Open File" openDialog.Filter = "Rich Text Files (*.rtf)|*.rtf|Word Files (*.doc)|*.doc|Text Files (*.txt)|*.txt|All Files ...Show All

• Visual Studio Express Editions SQL EXPRESS too sloooow...

  Could someone please help. I used to have a very smooth running SQL EXPRESS server. After I installed Beta 2, the server got very very slow with massive resource consumption. It can now take in and around 30 seconds just to login with massive use of the hard drive. Does anyone else have this problem I am using SQL EXPRESS version: 9.00.1116 Thank you, Hi, Thats correct and SQL Server Express does support all of those. In fact open up 2 or 3 instances of the Express Manager and it does not give you any errors if you try to open the same database. The issue comes when you try to directly access the .MDF file of the database ...Show All