Musafir's Q&A profile

• SQL Server Selling my software and SQL server 2000 as part of the package

  Hi everyone, I have developed a VB6 application that works with SQL server 2000. My client does not have a SQL server installed on their machine. I wonder do I have to purchase a copy of SQL server 2000 and install it to client's computer How much would a basic version of SQL server 2000 cost I am new to the softwarel world. Please give me some advise. Thanks assuming your application will not require a database that extends beyond the capabilities of MSDE2000 you should use it. Further more there are actually MSDE 2000 merge modules that you can use to embed the SQL Engine into your custom app's setup/msi routine. http://www.microsoft.com/sql/prodinfo/previousversions/msde/prodinfo.mspx Derek ...Show All

• Visual C++ how to play a audio/video file in a dialog window

  hi, i am the beginner of visual c++. My question has two parts. One is for video, the other is for audio. For the video : I would like to know how can i play a mpeg file in a dialog window. I find out that i can use some functions AVIxxxxx to play a ".avi" file. However, this cannot play the mpeg file. For the audio: i would like to know how can i play a mp3 file I find out that i can use Playsound function to play a ".wav" file but not a mp3 file. i have tried to use the msdn web site, i could not find anything about it. DirectX(i don't know much about this) seems too complicated for this small problem. Could someone point me where to look thank you! smile  To play the file you ...Show All

• Visual Studio Express Editions a small help please

  Hi, I have a problem in doing a simple program.I want to load the text of a notepad into the text box of visual basic.can any one help Thank You in advance. hi, you can use something like this Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim ofd As New OpenFileDialog ofd.Filter = "plain text |*.txt |htm|*.htm" Dim result As DialogResult = ofd.ShowDialog() If result = Windows.Forms.DialogResult.OK Then Dim SR As New System.IO.StreamReader(ofd.FileName, System.Text.Encoding.Default) Dim doc As String = SR.ReadToEnd SR.Close() Textbox1.text = doc End sub hop ...Show All

• SQL Server Problems with Reporting services - Solved

  I just installed SQL Server Express Advanced. I previous had SQL Server EXpress installed, which I didn't uninstalled. The problem is that, when I look in Services, it is not started and when I try to start it, I get a warning: "SQL Server Reporting Services started and stopped, some services stop automatically if they have no work to do". I have IIS installed and running. I have disabled Apache web server. What could be the problem Thank you. Just in addition, if you install the Framework before installing the IIS you will have to use the aspnet_regiis.exe -i command to make the IIS framework-ready. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server SQL Cluster Domain Move Issues

  We have: A Microsoft cluster, (SQL Failover cluster) with one node as the domain controller. The cluster was built off site and the domain name used is the same as our existing domain where we eventually need to install this cluster. We need: (At least I think we need:) To remove node 2 from the "cluster domain", DCPROMO node 1 and eliminate the "cluster domain". We then need to join the cluster (nodes) to the existing domain. We also need to recreate the accounts/groups used during installation. Questions: 1) What adverse impact will the removal of the "cluster domain" have on the security groups/accounts used in the installation 2) Will I have to re-install SQL 2005 3) Is my parano ...Show All

• Smart Device Development Embedded Visual C++ using Visual Studio 2005 running on VISTA RC1: Linker errors

  I'm using Visual Studio 2005 running on VISTA RC1 to create a simple Smart Device application. *using Embedded Visual C++(Windows CE and Platform Builder are both installed) *to access the RIL(Radio Interface Layer) of WinCE. The target device is a PPC phone (HTC with an OMAP ARM processor). I have an eVC++ source program, the RIL.h and RilClass.h headers, and Ril.lib(to import the ril functions from the ril.dll) When I 'build solution' I'm getting a ton of unresolved external symbols. I suspect that I have not sucessfully included the ril.lib into the build process, and that that is causing the unresolved externs: 'error LNK2019' and 'error LNK2001'. How do I specify that the .lib is to be used when linking my eVc++ pr ...Show All

• Visual Studio Tools for Office Adding an XML map in VS05 for Microsoft Office

  Hi, I'm tryig to add a XSD file to my excel sheet, in code using C#. When I run it, I get the following error below. I've tried with differnt types of XSD file, but no luck. I think this may be a bug. Please help Thanks, Brian Flowers Intellicorp Records Here is a smple of code I used: using System; using System.Data; using System.Drawing; using System.Windows.Forms; using Microsoft.VisualStudio.Tools.Applications.Runtime; using Excel = Microsoft.Office.Interop.Excel; using Office = Microsoft.Office.Core; using Microsoft.Office.Tools.Excel; using System.Reflection; using System.Windows.Forms.ComponentModel; private void button1_Click(object sender, EventArgs e) { string FilePath = ...Show All

• .NET Development HOW TO DELETE RECORD IN A DATABASE ?

  Hi, I have question to delete record in database. After clicked delete button I was able remove that row from view in datagridview but this record still exist in database. Here my coding : private void button3_Click( object sender, EventArgs e) { int Z; Z = dataGridView1.CurrentCell.RowIndex; maintenanceDataSet.MTN_Request.Rows .Delete(); maintenanceDataSet.MTN_Request.AcceptChanges(); } Thanks for your help. Joseph Please, get in the habit of using Parameters with your database queries. They make coding easier, in the longrun, because they will handle all the formatting. Furthermore, they will handle strings in such a way as to prevent SQL injection hacker attacks when you are wri ...Show All

• Visual Studio Team System Email notification per folder per user

  Hello! Is there anyway we can restrain the email notifications for only certain folders in the Team Project Also, not the every member of the development team checkin but just a particular developer checkin should instigate these email notifications. Thanks! Here's the command line that I used to configure an email notification for a path.  I've changed the email address ( someone@microsoft.com ), the server name (http://MyVstfat01:8080), and the path ($/TeamProject/A) from their original values, but it's otherwise what I've used to create a successful subscription. Give this a shot. Bissubscribe /eventType CheckinEvent /address someone@domain.com /deliveryType EmailHtml /server http:/ ...Show All

• .NET Development adding multiple constraint relationship in Access

  I need to add a multiple-constraint relationship between two tables in my app. The DDL for Access says that it should look something like: ALTER TABLE tbl_name ADD CONSTRAINT multi-field-index However, I can see no definition of what multi-field-index is. Have I missed something somewhere Sean Hi Paul. Thanks for this. I was just about to post that I found this very same answer by spending a couple of hours pawing through the Access docs. I appreciate your help. Sean ...Show All

• Visual C++ Junk values when build in Release mode

  Hello Everybody, I am having a strange problem in one of my VC++ code. I am setting a value in the code, which is getting retrieved perfectly when executed in DEBUG mode. But when I try to execute the same in RELEASE mode only junk values are being returned instead. I am totally clueless. Could anybody be having some idea on this My code snippet is as follows: _bstr_t szStatus = _T(""); _bstr_t szMessage = _T("not available"); // the value that I am trying to set int retVal = -1; try { retVal = m_oSql.GetStatusDescriptionSQL(...); if (retVal == 0) { szStatus = szMessage; // the value is being assigned here } } catch ( CSQLException& e ) { return this->Error(CComBSTR(e.m_szMsg), IID_ICola, E_F ...Show All

• Visual Studio Express Editions editing sorted data

  I hope this is easy to answer as it sounds to do I have a form with a listbox that shows a list of productlines, I use a bindingsource to filter the rows from a table with only the productlines selected in the listbox, what I'm trying to do is edit some columns of just the rows that was filtered with the bindingsource Any hints or help would be greatly appreciated....... OK, it took me awhile but I have figured out the answer to my own question, this really cool. The coding that I used is a bit lengthy, some of my varibles are used in other subs in the code, so If anyone would like to see my code, just send me and email at the address below, and I will send you a copy of my code. nightman28@hotmail.com If y ...Show All

• Visual C# sending and recieving mail in c#

  I need help again :( I'm trying to do send mail to a user, with a OK and Cancel button, I can send mail but I couldn't add buttons. The second and the more important problem is that: I want to take feedback from user. If user clicks Ok button then my code will add a record to my MS SQL SERVER database, if user clicks Cancel button then my code will delete a record from my SQL SERVER database. I think I couldn't ask my question correctly. I can send mail or add/remove records. My problem is that: I want to send buttons in the mail. The mail recipient will click OK/Cancel button in the mail and then my code will execute (write or delete record). ...Show All

• SQL Server DELETING ROWS with REFERENTIAL INTEGRITY

  hi there! im having problems deleting rows in a reference table. is there any tools which tables to delete first before deleting the rows in the table which contains the primary key i have a lot of tables let say over 300 so its hard for me to guess which comes first... what should i keep in mind deleting rows with a referential integrity thank... hi nitin! thank u for ur quick reply! the thing is, im copying data from server to server, after copying the data i wanted to deleted this rows i've copied to the source database and offcourse i want to delete correctly. i dont want to disable the foreignkeys because if my delete script is wrong , i wont able to delete the data correctly. by ...Show All

• Smart Device Development Mobile development Certifications

  Hi , I work for a software concerrn for 1.5 years in mobile applications for smart phone. my platform is .net and i want to do certifications, i am confused in selecting what kind of certifications to undergo...........pls some one help me out in this......... There is a sticky thread in the General Forum that states there;s a BETA one in place... http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=719777&SiteID=1 Thanks ...Show All