Marc Selman's Q&A profile

• SQL Server Restore a set of databases from a SQL2000 server to a SQL2005 server

  I can restore databases one by one, setting .mdf and .ldf destination paths. How can I restore all my Databases at the same time Thanks G. Zanghi Your Email doesn't run! check this link: fengyu.china.com/source/sp_CSS_RestoreDir.sql It's very similar to mine. ...Show All

• SQL Server Select All = no Result

  hey there I have parameters in my report set up CallStatus = string Available Values are non-queried and values are listed in the value list closed, open, pending, select all If I choose each one separately I get a result - if I choose select all I get no result. This worked fine attaching to another datasource - I have now attached it to a new source. Tried altering the relationship to properties to a left outer join but this made no difference. Can someone tell me what else I should check thanks thanks but no different to the others maybe it would help if I post the code SELECT Company.CompanyName, Ticket.TicketNumber, Status.StatusName, Application.ApplicationName FROM ...Show All

• Visual Studio Where is the resource editor file

  Hi, VS crashed the other night and after I rebooted my project setting.settings, resource.resx and project properties are not showing and more. The first 2 are just showing as text. I need to set the default editor to the file types but I don't know the default VS files. Anyone know the file paths so I can reset them. Thanks ...Show All

• Visual FoxPro Why the datas from the .dbf file (table) are not displayed?

  Hi all Need help very badly.. I purely have no idea where i go wrong. I'm trying to get the datas (such as CHEVSINSMZ 100,CHEVSINSMZ 100, CHEVSINSMZ 101, CHEVSINSMZ 102, etc) from the table (.dbf) display and then trim into "CHEVSINSMZ 100 & 101 & 102 itself. What i get the result on {.xdf_bl.value= OutPutSTring} of the form is (1)_________ when testing this form. Why cannot the datas be shown on the text field when searching for the value in the .dbf _-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-_ tnfjob is the name of the table. Jt_hblno is an attribute of the table (.dbf)in the form. It is like something that originally contains CHEVSINSMZ 100,CHEVSINSMZ 100, ...Show All

• Visual Studio Express Editions Solution Problem

  Hello there, I'm curently building a solution. I have added some projects I had already made to the solution (locker, general(used to be prog_1)) and I also made some new ones, and now I am willing to build the solution. But the problem is: I can't find the folder in wich the solution has been set when build. Here is a picture of the looking of my project: http://www.freewebs.com/tomthe1337/images/problem_solution.jpg and here is a picture of the map: http://www.freewebs.com/tomthe1337/images/problem_map.jpg I hope that anyone of you guys can help me out as this is very frustrating for me because I need to test the solution etc. Grtz, Tom. You found out where your solution files are stored. Now find out where the project files ...Show All

• Visual Studio Express Editions Write native Windows 98 Application in VB Express

  Is it possible to write an application in Visual Basic Express which runs 'natively' (i.e. without the need for .NET frameworks) on Windows 98 If so, how is this done If not, what's the best alternative for developing such an application on a Windows XP machine Thanks John Unfortunately no. Any application you write with a .NET language will require the use of the .NET Framework. The one quasi-exception to this is if you use C++ Express (or C++ from a higher version of Visual Studio) to make a native Windows application. If I may ask... why not target the framework and make sure it is installed on the 98 machine for your app to be used Just so long as you target 1.0, 1.1 or the 2.0 framework you' ...Show All

• Smart Device Development VS.Net 2005 how to clear form?

  I would like to call a method to clear the controls inside a form. eg. i am having textboxes,comboboxes,buttons....functions,methods etc in a form. Now i would like to use a method to clear everything that is in the form, making it into the default state. is there a way i can go about doing it like there has a method to remove the controls/methods in the form. then doing so the form will be like its original state when created. ...Show All

• SQL Server Smart Client - Data Centric - SQL 2K to SSE local

  Trying to develop a smart client which will have data centric approach for storage of local data. The server is SQL Server 2000 and foot print database is going to SQL Server Express 2005. Is Merge replication a vaiable option. Can somebody guide me on this approach Is there any other architecture proposed for Smart client arcjitecture where the data tranfer will be in a couple of GBs. Can somebody tell me more about SOA as well Thanks! As I read that it was possible, I have been trying to setup SQL Server 2000 as a publisher/distributor and sql server everywhere as the subscriber. I have not yet been successful. What I am thinking is that we can help each other. I would like to exchange conta ...Show All

• Visual Studio 2008 (Pre-release) The handle is invalid. (Exception from HRESULT: 0x80070006 (E_HANDLE))

  I am having "one of those issues", IIS is randomly failing with an "The handle is invalid. (Exception from HRESULT: 0x80070006 (E_HANDLE))" error. The error is literally random. All I can say is that if I do an iisreset it works for a while until it fails with the exact same error again. Here's some information I am getting from IIS Health Checks: Application information: Application domain: /LM/W3SVC/1/Root/EModServices-5-128008423022079854 Trust level: Full Application Virtual Path: /EModServices Application Path: C:\Program Files\Oxford Media\Accounting & Support System\Services\EModServices\ Machine name: OMASSSERVICES Process information: Process ID: 5540 Process name: w3wp.exe Account ...Show All

• Visual Basic About ActiveX in VB.NET

  I want to create an ActiveX to embed to my HTML file. Can I do it by using VB.NET Here's a link to get you started http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpguide/html/cpconexposingnetframeworkcomponentstocom.asp and here's one to show you the way http://www.vbdotnetheaven.com/UploadFile/dsandor/ActiveXControlInVBdotNET04112005081747AM/ActiveXControlInVBdotNET.aspx good luck richard ...Show All

• Commerce Server Taxation data

  Hi, following on from my previous question: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1094829&SiteID=1 I'm looking for the most suitable place to store tax rates. I thought of creating a new profile object but don't think that is the most efficient place to store the data. The tax rates need to be easily accessible for my tax pipeline, without having a large performance hit. Thanks in advance Paul Hey Paul, I've been out with the flu this week and I haven't had time to wrap everything up. If you can send me an email (colin.bowern@officialcommunity.com) I'll give you a drop of the code to look over and I'll get it posted in full this weekend. Thanks, Colin ...Show All

• Visual Studio Express Editions DataGride View Question

  I have a DataGridview being filled by SQL. My question is how do I only show certain columns. Here is my code that I am working with. My rows that I want to show are name,id,DE_status Dim connectionString = "Data Source=localhost;Initial Catalog=TESIS;User ID=sa;Password=passw" Dim theDataSet As New DataSet() Dim theSqlCommand As New SqlCommand( "Select * from [FR-DEVICE-TABLE] WHERE [DE_STATUS] = 'Active'" , New SqlConnection(connectionString)) Dim theDataAdapter As New SqlDataAdapter(theSqlCommand) 'SqlDataAdapter.Connection.Open() theDataAdapter.Fill(theDataSet) theSqlCommand.Connection.Close() DataGridView1.DataSource = theDataSet.Tables(0).DefaultView thank y ...Show All

• .NET Development System.Transactions issue

  I have been trying to run the following piece of code : using ( TransactionScope txRequest = new TransactionScope ( TransactionScopeOption .Required)) { using ( SqlConnection conn1 = new SqlConnection ( "Data Source=XXXX;Initial Catalog=ULTIPRO_USG;uid=dev;pwd=pass;" )) { conn1.Open(); } using ( SqlConnection conn2 = new SqlConnection ( "Data Source=XXXX;Initial Catalog=ULTIPRO_USG;uid=dev;pwd=pass;" )) { conn2.Open(); } } The SQL server 2005 is in a different machine. Due to the fact that there is a second connection inside the transactionscope DTC is necessary and is enabled for Network Access on both machines. Whenever we run this piece of code we are ab ...Show All

• .NET Development How To Credit Card validation

  How To Credit Card validation in asp.net in Real Time project. please gives ideas. Thanks Off the top of my head... implement an ASP .NET web service. Credit cards use the mod 10 luhn algorithm to add the last check digit - and that validates the card number - google "luhn". To check the card type, have a look at the first digit to see if it matches the card type that the user selected - afair 4 is visa, 5 is mastercard, 6 is switch/solo. You should be able to find a full list somewhere on the web. To check the card details properly you'd have to hook up to a financial institution database. ...Show All

• Visual Studio Team System bug when stopping running build?

  Hi I cannot start a new build if I stopped the previous one during compiling with the command " tfsbuild stop ...." the error is: Target CoreClean: Removing directory "c:\testbuild\captia41\test\BuildType\..\Sources". C:\Program Files\MSBuild\Microsoft\VisualStudio\v8.0\TeamBuild\Microsoft.TeamFoundation.Build.targets(230,5): error MSB3231: Unable to remove directory "c:\testbuild\captia41\test\BuildType\..\Sources". The directory is not empty. C:\Program Files\MSBuild\Microsoft\VisualStudio\v8.0\TeamBuild\Microsoft.TeamFoundation.Build.targets(230,5): error MSB3231: Done building target "CoreClean" in project "TFSBuild.proj" -- FAILED. If I try to delete folder ...Show All