laurence's Q&A profile

• SQL Server How to allow remote connections to SQL Server 2005 Express database

  I've developed an asp.net 2.0 web app with vs 2005 and am using a SQL Server 2005 Express database. The app works fine locally, but after uploading to the remote web server the following error occures: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) How do I go about granting remote connections to SQL Server Express Does the web server have to have SQL Server Express instal ...Show All

• SQL Server Page break after X items

  Is it possible to force a page break after a specified number of items in a table For instance, I have a name badge report but I'm running into a problem where some badges are sliced down the middle at page breaks when exporting to pdf or tiff.  If I could force a page break after every 2nd or 3rd badge it would alleviate that problem. Thanks in advance. hi, I hope someone can help me! I don't understand where I must place "=Ceiling(RowNumber(Nothing)/4)" I added a new group (I selected table, right-click Proprieties, groups and add) and I've write "=Ceiling(RowNumber(Nothing)/4)" as ...Show All

• Software Development for Windows Vista Future of COM in Vista + IE

  Hi, Currently we have a streaming player that can be used within a webpage which works nicely on Mozilla based browsers (via Java) and MSIE (via COM), what we're worried about is what Vista's IE will bring forth that may trouble this. What is the future of COM in Vista's IE7 For signed activex components does the average useer have to do something special to get this to work Thanks. ...Show All

• SQL Server Unable to install SQL Server 2005 September CTP

  I am attempting to install SQL Server 2005.  I installed VS.NET 2005 (Beta2) on the machine previously, with SQL Express (the one that came with Beta2). I uninstalled the above using the vs_uninst.exe tool.  I was able to successfully install RC1 of VS.NET 2005, but cannot now install SQL Server 2005 Developer Edition - September CTP. I'm trying to uninstall everything and try again.  I've followed the list of components to 'uninstall' that the VS.NET 2005 RC1 Setup (for Uninstall) created (its shown on the last page of the uninstall wizard when its all done). All that's left are : MSXML 6.0 Parser and SDK (only on 32bit) Micr ...Show All

• Visual Studio Team System Installation of Beta 2 over VS 2005 Professional

  Can I install Beta 2 of Team System Client onto a computer that has the final release of Visual Studio 2005 Professional I noticed that it asks for Beta 2 .Net Framework to be installed, but would this interfere with the newer version already installed We already have a Team Foundation Server (Beta 2) up and running with active source control projects, so I need to be able to work with these from my new installation of VS 2005 Professional. If this cannot be done with the Beta 2 Team Suite CD I have, are there any suggested workarounds Thanks! This issue is very urgent, I appreciate all your help! If it allows you to insta ...Show All

• .NET Development how to read .dbf file in Visual C#.Net?

  I got sample of reading excel. can work. but cannot find the sample of reading .dbf (Dbase IV) file. how to read .dbf Though I have not tried it, you can use OleDb Provider of ADO.NET to connect to DBase databases. The connection string can be as follows "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\db\db.dbf;Extended Properties=dBASE IV;User ID=Admin;Password=" Once you have an OleDB connection established you can use the normal ADO.NET methods to read/write to the database. Regards, Saurabh Nandu www.MasterCSharp.com www.AksTech.com ...Show All

• Visual Studio Team System VSTS and MSDN Academic Alliance

  After doing some poking, proding and rethinking, we have refined our story with respect to VSTS and MSDN AA.  Recently I posted that VSTS is included in MSDN AA but only by request. We have decided to put the 180 day trial edition of VSTS on the MSDN AA web site and make it available to all MSDN AA members.  There will still be some TBD process to get registration keys to turn the trial edition into a "full" licensed product but we'll have 6 months to figure that part out now :) We are investigating putting the Beta 3 Refresh of TFS on the MSDN AA site too.  Once TFS releases, the 180 day trial edition will be available t ...Show All

• .NET Development How to locate an loaded assembly?

  I simply want to know how to resolve if an certain assembly (some *.dll file) is loaded (used) by other .Net application. There is an excellent and very interesting article at http://msdn.microsoft.com/msdnmag/issues/04/10/NETProcessBrowser/  that explains what you seem to be looking for. It has source code to browse managed processes and their loaded assemblies.  If you just want to see if a dll is loaded (managed and unmanaged processes) the Process and ProcessModule will give you that info. Process [] arrProcesses = Process .GetProcesses(); foreach ( Process proc in arrProce ...Show All

• Visual Studio Team System Tests cannot be found during build

  I've just got a Team Build server set up, and I'm trying to configure it to automatically run a list of unit tests during the build. When it gets to this stage, I get the following log messages: Target RunTestWithConfiguration:    Loading C:\TeamBuilds\SBD Platform\SBD Platform\Integration Build\BuildType\..\Sources\SBD Platform.vsmdi...    Search path(s) for tests:    C:\TeamBuilds\SBD Platform\SBD Platform\Integration Build\BuildType\..\Sources\..\Binaries\Debug\    C:\TeamBuilds\SBD Platform\SBD Platform\Integration Build\Sources    Search path(s) for default run ...Show All

• Windows Forms jagged arrays don't serialise correctly as properties in the visual studio designer

  Hi! I have a problem when using jagged arrays as properties. I'm using c# visual studio 2005 .NET 2.0. When I declare a propety as a jagged array, visual studio's designer seems to obmit a pair of square brackets when saving the property in the xxx.designer.cs file.   Example:     //my declaration     public int [][] MyProperty2;       //my initialisation     MyProperty2 = new int [] [] { new int [] { 25 } };       //the designers serialisation     MyProperty2 = new ...Show All

• Visual Basic Dataset HasChanged Property

  I'm Making a database program I've noticed that the property HasChanged intented to track wether the dataset has changed does not update it's value to True in case of the user has edited the data on the screen till you move to another record can I know if the user changed the data before the user leaves the current edited record to another the purpos of this is to alert the user to save data before he mopves to another record or close the form in the simplest way It colud be done Thank You all The changes you are making will be accepted into the dataset when you move to a differe ...Show All

• Visual Basic Form1_closing.. is this a bug?

  I've noticed that in visual basic 2005 that there is no form1_closing event in the event list. Is this on purpose It works if you type it in but the list doesn't show it. Any ideas on this No, Stream hasn't been superceded by StreamReader. It probably selects StreamReader because you can't create an instance of Stream as it is an abstract (MustInherit) class. ...Show All

• Windows Forms How to update dataset

  Hi, I am having some problem to update my dataset. I am basically using two forms to show the information from the database. This first form is having a datagridview to show the basic information and the second form is used insert and update the database. Now I am using the following code to fill my datagridview on the form load event.        Dim ds As New DataSet        Dim sSQL As String        VoucherEd.showdialog()        sSQL = "" 'SQL Statement         SQLHelper.FillDatase ...Show All

• Visual C# Just-In-Time Data Loading For DataGrids

  Hello! I have a database with 2 million records and I want to display these records in a data grid, but I do not want to load them all into memory from the database. I want them loaded "just in time," maximizing performance and minimizing memory load on the application. Version: Visual Studio 2005 SO: Windows XP proffessional Thank you in advance On Windows dev center there is a great article written by Kesse Liberty: Just-In-Time Data Loading For DataGrids . ...Show All

• Smart Device Development VS.NET 2005 - Howto override WinCE include folders (for using STLport)

  .Welcome { font-size:x-small; margin-top:15px; } .Welcome p { font-size:80%; } .Welcome ul { font-size:80%; } If I want to use any external library instead of a built-in library (eg. STLport instead of the built-in STL) in Visual Studio then I just add the libaries include folder above the default include folders under Tools -> Options -> Directories. But this doesn't work for Smart Devices (WinCE 5.0).  My include folders (eg. \VC\ce\include) come from somewhere else, and I guess they come before the Options -> Directories folders because adding STLPort in the usual place has no efffect. Any suggestions Thanks. ...Show All