Thomas Scheidegger MVP's Q&A profile

• Software Development for Windows Vista Problem in sending mail through web instead of localhost(Drop)

  I have done HOL 02 of wwf successfully. I want to send mail through web instead of sending it to the Drop folder of Inetpub in the local machine. So I have changed Smtpclient from "localhost" to SMTP Server name as shown in the below code. Then I am getting the following error. " An exception of type 'System.Net.Mail.SmtpException' occurred in System.dll but was not handled in user code Additional information: The SMTP server requires a secure connection or the client was not authenticated. The server response was: Authentication required " MailAddress toAddress = new MailAddress (To); MailAddress ...Show All

• SQL Server Fact table design

  Hello. I am working on an educational data warehouse. I have a semi-additive fact table that deals with student grades and averages. It's as such: School, Acad Year, Student, Course, Term, Week, Week Grade, Term Average where Week Grade and Term Average are the measures. The term average is an average calculated based on a specific formula on top of week grade. It's supposed to appear when the user is standing on All weeks member of Week's dimension. I have an average calculation problem in the term average...say i want to compare the student term averages. i don't know if its correct to write an mdx formula to get it or to cr ...Show All

• SQL Server Reading more than 1 set of files using Foreach Loop Container

  Hi, My requirement is I have to read 2 sets of files from a folder. For example, I have to read all files starting with either 'a' or 'b' only. In 'Foreach Loop', if I say 'a*,b*', it is not working. Instead of comma (,), I tried colon, semi-colon and pipeline characters also. It is not working. So I am using 2 loops now. But I would like to know is there any way to do it using a single loop Thanks. I don't think there is unfortunately. It would be nice if you could use regular expressions to define your filemask instead. -Jamie ...Show All

• SQL Server SQL Server 2005 Express on VISTA

  Greetings! I tried installing SQL Server 2005 Express on my VISTA Beta 2 Box but before doing so, I checked if IIS is already installed and running. During the assesment of my current configuration, SQL Server 2005 Express is still looking for IIS. Are the conflicts regarding IIS 7.0 to SQL Server Express or the feature is not yet available. I will be continuing to do experiments with this one and hope there will be people who can share their experiences too. Thanks! haven't done much with it yet, but I was able to install the "SQL Server 2005 Express Edition with Advanced Services SP1" on the Vista Release Candidat ...Show All

• SQL Server ~* Difference between RDL and RDLC *~

  hi, i am confused with RDL and RDLC. when to use RDL and RDLC.. can anyone help me out of this. Thanks in advance. Why don't give google a try ;) http://www.google.de/search q=rdl+rdlc Q: What is the difference between RDL and RDLC formats A: RDL files are created by the SQL Server 2005 version of Report Designer. RDLC files are created by the Visual Studio 2005 version of Report Designer. RDL and RDLC formats have the same XML schema. However, in RDLC files, some values (such as query text) are allowed to be empty, which means that they are not immediately ready to be published to a Report Server. The m ...Show All

• Visual C++ Transferring project from a computer running 2000 to a machine with XP

  I am using Visualc++.net 2003. I transferred a project from a computer with 2000 to a computer with XP. The project opens and runs ok on the 2000 computer but on the XP computer I get the message cannot open my .vcprog file. some of the assemblies referenced in your project may be missing on XP machine. Project should load fine after removing reference entries from .vcproj file for the missing assemblies. This is a known VC++ .Net 2003 issue. Please try it and let me know. Thanks ...Show All

• SQL Server How to get detailed info of views?

  Hi. We're using Sql Views to access data from our database, and I need to validate the views so that we don't loose anys data. By that I meen that e.g. if a foreign key column is nullable, we need to use an outer join to secure that we get all the rows from out "main" table in that view + some other checks on the joins and the joined columns. But I couldn't get this info from the Smo.View-object. Do I have to parse the CREATE VIEW-statement manually, or is there a better way to do this Any experiences Any good sql-parser to recommend Regards, Tomsi Thanks - that did it. I've got a lot ...Show All

• Windows Forms Which project to use?

  If I want to create a windows user control with no visual form - just properties and methods like the timer control. Which project should I use so I do not get the visual form. Thanks, Frank Daniel, Yes, you are right.. it is a component. Works !! Thanks, Frank ...Show All

• Visual Studio Tools for Office how to create shims for add-ins created with VSTO if no VS2003?

  Hi, In VS2003 it was possible to use the Shim wizard for Office add-ins created with .Net. However, as I understand this does not work with VSTO. So, my question is for those of us without VS2003, how do we create shims with VS2005 or VSTO Thanks for your help Doriak Andrew and Misha: Any progress on this It will be super if we can have a VS2005/.NET 2.0 version of the Shim Wizard in the near future :-) ...Show All

• Visual Studio Express Editions I need to get volume information from the hard disk. What can I do? - Volume Serial Number

  I am trying to implement a copy protection scheme for my programs and I need to determine the volume information of the hard disk on wich the program is installed. Is there a way to do it from VB 2005 Some information is returned by My.Computer.FileSystem.GetDriveInfo but this might not be enough for your scheme. ...Show All

• Windows Forms disappearing DataGrid row

  Hello all, I have a DataGrid bound to a filtered DataView on a DataTable.  When a new row is added through the DataGrid the new row dissapears as soon as focus is moved off of the new row. I have searched this forum and google and found similar threads that lead me to believe it has to due with rowstate for this new row but I c ...Show All

• Visual Studio Team System Running FxCop through code

  Is it possible to run FxCop from code Can I create a class to run an analysis on an assembly and then analyze the report output within my class I'm asking because the company I'm with wants to incorporate FxCop into its build process and would like the build to fail if FxCop finds certain rules broken. Thanks! Is it an absolute requirement that you access FxCop programmatically If there was sufficient support for this out there, we could consider making this more of a supported scenario. Currently, not even VS2005 accesses FxCop in this way... 8) Michael ...Show All

• .NET Development Avoid Repetition of primary tables's record

  hi all, can you tell me how to avoid repetition of main records when one main(Primary table) record have more than one child(secondry table) records. I am using DataList to show records. For example I want to show the following Tools & Equipment http://www.mobmasti.com MobMasti Mobile Portal Manufactures http://www.manu.com Manufacturer desc manufactur Rental Companies http://www.rentit.com Rent It rent it desc Buy & Sell http://www.mobmasti2.com MT desc Manufactures http://www.allofuse.com all stff desc Employment http://www.mobmasti. ...Show All

• Visual Basic About connection though MySQL

  Hi all, good afternoon! Anyone know's what's the best way to conect to MySql thought VB 5, using ADO or DAO Thanks, Vivian www.connectionstrings.com : OLE DB, OleDbConnection (.NET) Standard: "Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;" Connector/Net 1.0 (.NET) Standard: "Server=Server;Database=Test;Uid=UserName;Pwd=asdasd;" Download the driver at MySQL Developer Zone . Specifying port: "Server=Server;Port=1234;Database=Test;Uid=UserName;Pwd=asdasd;" Default port is 3306. Enter value -1 to use a named pi ...Show All

• Visual Basic opening files from outside my application (vb.net 2.0)

  I have a program that reads .txt and .rtf files, I have made an installer project for the program within vs2005 and I have put the file type and set the command in 'files types' to 'Primary output from OSSUniType (Release Any CPU)'. Now when I compile my program i look in a folder that has .rtf in it and it shows the icon to my file as expected but when I open it from windowsmy program launches but no text is shown but if I open from windows into notepad or word the text is shown. If I run my program then click 'open' and find the exact same file then the text is shown. also in file types 'arguments' is shown as "%1" ...Show All